R for Excel Users - First Steps
Presented by George Mount
If you’re a data analyst steeped in Excel, chances are you could benefit greatly from learning R. To make things even better, you may already know more about programming than you think.
This presentation serves as a hands-on introduction to R for Excel users:
- How R differs from Excel as an open source software tool
- How to translate common Excel concepts such as cells, ranges, and tables to R equivalents
- Example use cases that you can take and apply to your own work
- How to enhance Excel and Power BI with R
By the end of this presentation, you will have a clear path forward for building repeatable processes, compelling visualizations, and robust data analyses in R.
Bio
George Mount is the founder of Stringfest Analytics, a consulting firm specializing in analytics education and upskilling. He has worked with leading bootcamps, learning platforms and practice organizations to help individuals excel at analytics. George regularly blogs and speaks on data analysis, data education and workforce development. He is the author of Advancing into Analytics: From Excel to Python and R (O’Reilly)
Link to George's white paper “Five things Excel users should know about R”https://stringfestanalytics.com/five-things-r-excel/
Working group sign-up for those interested!
Within many organizations Microsoft Excel is a preferred tool for working with data for non data analytics users. In order to build a data driven organization, source data and analytical models must be accessible to all data users (technical and non-technical) within their preferred tool. Let’s rally the R community to welcome Excel users into our data driven culture by building an Excel add-on to access data and models available within RStudio. If you're interested in continuing this conversation and joining a working group, let us know! rstd.io/excel-r-community