R Explained for the Spreadsheet Analyst
So you want to learn R. Maybe you are looking to move to an advanced analytical role that requires it. Or you have found some limitations to the type of operations you want to perform in Excel.
Perhaps you have tried books or online courses to learn R and found them unhelpful. It was like they were speaking a different language – and they were. Because this is probably your first time programming.
The easiest way to learn something new is to make connections with something you already know.
That is why this course specifically frames learning R with the needs and experiences of Excel users in mind.
This course aims to augment your analytics skills with R rather than replace Excel. I will not claim that R is “better” than Excel; this is merely another tool in your toolshed.
Who is this course for?
- Professionals who analyze data in Excel and want to augment their skill base
- Those looking to speed up or automate advanced statistical techniques
- Analysts looking for a free program for sophisticated data visualizations
No prior programming experience is required. As an Excel user, you know more than you think about data, and this knowledge is the basis for learning R.
Topics covered (currently under development):
- An introduction to R and RStudio
- Data Types and Structures
- Reading, Writing and Exploring Data
- Data Management and Transformation
- Charting and Visualization
Getting Started with your FREE Course Preview - 5 Things Excel Users Should Know About R
This course is currently closed as it is under development. But, I want to get you started with R, and I also want to learn from you!
This mini-course and accompanying report covers "5 Things Excel Users Should Know About R."
Please stick around at the end of the course for a short poll surveying you on your experiences with Excel and R so I can build the best course possible.
By signing up for the preview of this course, you will be the first to know about its launch.
I like helping people manage their data so they can think more creatively.
Armed with a liberal arts degree and a master’s from a leading business school, I set out into the world to become an amazing analyst.
Over the past few years I have worked on projects ranging from Canadian retailing to neurosurgeon compensation.
While I had big ideas about making an impact to the business, I felt drowned and overwhelmed in the data. There was no way to see the forest, because I was stuck in the trees of confusing spreadsheets.
Through this experience, I’ve noticed patterns of what makes a good analyst. Specifically, I’ve seen the best and worst in Microsoft Excel and data analysis.
RankedBlogs.com and Feedspot.com have both recognized me as a top online authority on Excel. This mastery forms the basis for posts on business analytics, career management and innovation which have been featured on leading sites like Excel.TV and Brazen.
As featured on:
More about me…
I hold a bachelor’s in economics, magna cum laude, from Hillsdale College and two master’s degrees from Case Western Reserve University’s Weatherhead School of Management, in finance and information systems.
I have also completed a certificate in business analytics from Indiana University’s Kelley School of Business as well as a Certificate of Achievement in Quantitative Methods, also from Weatherhead.