
R Programming for Excel培训
Introduction
Core Programming and Syntax in R
Variables
Loops
Conditional statements
Fundamentals of R
What are vectors?
Functions and packages in R
Preparing the Development Environment
Installing and configuring R
R and Excel
Moving data between R and Excel
Working with bivarite analysis in R and Excel
DescTools
Controlling output in R
Running DescTools functions on variables
R Tidyverse
Loading and filtering data
Pivoting with R
Using Power Query
Data Visualization with R
Creating static visualizations with GGPlot
Layering multiple charts
Transforming visualizations into HTML widgets with Plotly
Working with interactive tables
Using R Markdown
Summary and Conclusion