Aug 20, 2014

Transition from Excel to R

The R language is a powerful tool but the learning curve could be very steep and intimidating. However, as a business user you might be looking into it in search of speed, flexibility and better handling of larger data. An Excel user would be thinking in terms of the most common tasks in Excel - summaries, pivots, look-ups, filtering and charting and the first questions about R naturally would be how to perform these tasks. The answers are not always easy to find. Fortunately, there are some good people on the Internet come to help. I have put together a short list of blogs and sites that could be very useful for the initial part of the Excel to R transition.

How to Transition from Excel to R- nice blog post with direct answers to how to do average, sum, pivots, charts and other common tasks
R for Excel Users - video series covering the basics. Explore the whole blog for more lessons.
LearnR Toolkit To Help Excel Users Move Up To R- charting examples

These 3 links are a good starting point before digging deeper into the R documentation and a quick reference afterwards.

No comments:

Post a Comment