Overview
R is a programming language and software environment for statistical computing. Together with R and Excel, users are able to implement R Tidyverse standards and more powerful R features for improving data analytics in Excel.
This instructor-led, live training (online or onsite) is aimed at data analysts who wish to program in R for Excel.
By the end of this training, participants will be able to:
- Toggle and move data between Excel and R.
- Use R Tidyverse and R features for data analytic solutions in Excel.
- Update their data science skills by learning R.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
Requirements
- Experience with Excel
Audience
- Data Analysts
Course Outline
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