        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