Abstract:
Excel's built-in programming language has served as an entry point to coding for many. If you’re a data analyst steeped in Excel, chances are you could also benefit from learning R for projects of increased scope and complexity.
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.
Speaker 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”[ Ссылка ]
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
Links shared at the meetup!
✨ George's GitHub/ Presentation Resources: [ Ссылка ]
✨ Packages? Where to find them & recommendations:
CRAN Task Views: [ Ссылка ]
Mark shared: for folks who primarily use excel to present formatted tables, the `gt` package is a great way to start doing this programmatically in R: [ Ссылка ]
Ivan shared: In addition to regular Google, I'd recommend [ Ссылка ], given that the character 'R' is sometimes not search friendly :)
Jeff shared: Fpp2 is great for forecasting and time series analysis - [ Ссылка ]
Floris shared: [ Ссылка ]
Ivan shared: If you're into tidyverse, there's an equivalent for time-series: [ Ссылка ]
George shared: [ Ссылка ]
Ryan shared: This can be a helpful package for dynamically editing tables, like in excel [ Ссылка ]
Ryan shared: This is a great package for making and learning ggplot visualizations: [ Ссылка ]
✨ Other resources:
Monaly shared: There is a R help group: r-help@r-project.org
George shared: Helpful book/site on statistics: [ Ссылка ]
Ryan shared:Harvard has a good online source (free options) that has a number of classes, the following for stats: [ Ссылка ]
George shared: R for Data Science free book: [ Ссылка ]
Fernando shared: big book of R [ Ссылка ]
Floris shared: Advanced R Book: [ Ссылка ]
Pedro shared: The R for Data Science Slack channel is a great learning resource! r4ds.io/join (we just made a channel there called #chat-excel_to_r
Ivan shared: For teams who are deeply entrenched in Excel (like my old team), this tool may be useful - [ Ссылка ]. It allows running R code in .xls, so you can learn R while doing .xls :)
✨ Re: Glossary of terms:
Ivan shared: inner_join() is like VLOOKUP in .xls.
Dan shared: Here's one cheat sheet (glossary of Excel to R) that I just found; [ Ссылка ]
✨ Extra Meetup Links
Feedback: rstd.io/meetup-feedback
Talk submission: rstd.io/meetup-speaker-form
If you'd like to find out about upcoming events you can also add this calendar: rstd.io/community-events
RStudio conference/submit a talk: [ Ссылка ]
Recordings of all meetups: [ Ссылка ]
![](https://s2.save4k.ru/pic/hyvClyUOY04/mqdefault.jpg)