How to Transition from Excel to R: An Intro to R for Microsoft Excel Users by Tony Ojeda.
From the post:
In today’s increasingly data-driven world, business people are constantly talking about how they want more powerful and flexible analytical tools, but are usually intimidated by the programming knowledge these tools require and the learning curve they must overcome just to be able to reproduce what they already know how to do in the programs they’ve become accustomed to using. For most business people, the go-to tool for doing anything analytical is Microsoft Excel.
If you’re an Excel user and you’re scared of diving into R, you’re in luck. I’m here to slay those fears! With this post, I’ll provide you with the resources and examples you need to get up to speed doing some of the basic things you’re used to doing in Excel in R. I’m going to spare you the countless hours I spent researching how to do this stuff when I first started so that you feel comfortable enough to continue using R and learning about its more sophisticated capabilities.
Excited? Let’s jump in!
Not a complete transition but enough to give you a taste of R that will leave you wanting more.
You will likely find R is better for some tasks and that you prefer Excel for others. Why not have both in your toolkit?