Originally published at: https://tutorials.datasciencedojo.com/introduction-to-r-programming-for-excel/
R programming is rapidly becoming a valuable skill for data professionals of all stripes and a must-have skill for aspiring data scientists. Adding R programming to your data analyst skillset allows you to leverage powerful data visualizations, statistical analyses, and even machine learning in your daily work.
In this presentation, Dave Langer illustrates how your knowledge of performing data analyses in Microsoft Excel gives you a unique foundation for quickly learning how to apply R in your daily work.
No knowledge of R coding is required for this meetup as Dave will illustrate scenarios in Excel and then walk through how each Excel scenario is implemented in R.
Viewers will learn how:
• Fundamental concepts of Excel (e.g., working with tables, collections of cells, and functions) translate 100% to working with data in R.
• Excel pivot tables translate to R code.
• Creating charts in Excel is very similar to creating data visualizations in R.
• R offers visualizations not available in Excel out of the box.
The accompanying Excel spreadsheet and R code can be found here