R Programming for Excel

• Experience with Excel

Audience

• Data Analysts

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.

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