Finally, an R book that’s not overwhelming

R for Excel Users Cover

You want to learn R and do more with your data.  But it’s all so overwhelming.  Maybe you’ve tried some tutorials but didn’t really get anywhere.  Or maybe this is your first time coding, so you’re feeling a bit uneasy.  Or maybe you’re not overwhelmed at all, but you know Excel and want to learn R quickly.

Either way, R for Excel Users will get you up and running.

You will finally be able to work with bigger data.  Take on more interesting projects at work and look like a genius to your coworkers.

“I like how you write in an easy-to-understand manner, and your comparisons with how Excel and R work really helped clarify some points in my head.”
– Mark Farrell, Business Intelligence United States Postal Service

How is this different from other R books?

R for Excel Users is unique in a few ways.

  • As much as possible, things are put in context of something you already know: Excel.
     
  • It’s written with the functional corporate data analyst in mind, not the professional statistician. This means we can ignore large swaths that simply won’t be as important for you (at least not yet), like matrices.
     
  • It keeps you focused on mastering a really important topic: vectors and data frames. No modeling, no beautiful graphics. Just data. The goal is to build a solid foundation you can easily build on. It’s all about crawling before you run.

Readers are loving it!

Just wanted to let you know that I am LOVING your R for Excel Users book! OMG, dude, you are a life saver!!! I think its the best book out there especially for novices and the connection to Excel makes it the easiest thing in the world to understand!

Arlene B
Digital Marketing Strategist

I am only on page 7 of your book and I had to stop to thank you. Your book is EXACTLY what I needed. I’ve taken the R programming class three times from Coursera and actually only passed it by doing the last assignment in Excel. Your book and blog would have helped me so much during the class. I know it’s going to help me learn what I couldn’t from the class!

Sheryl Z
Supply Chain Analyst

I came across your site while looking for a way to use R for an Excel vlookup/index-match equivalent, and really appreciated it. I felt like your description of the merge function was the best I had read, and I had looked at a few sources.

Zachary S
MBA Student


R for Excel Users Cover
Print and Kindle Format
Available on Amazon

Questions?

Why start with data manipulation in R?

Because the sexy stuff is actually not too hard once you know what you’re doing. Here’s an example. Running a linear regression is a simple command that looks like this:

lm(y ~ x1 + x2 + ... xn, data = dname)

That’s it. And if you understand regression already, then interpreting the output will be easy. But getting your data set in the right format, combining it with other data sets, manipulating columns, filtering rows and working with lists — that is the hurdle I will help you overcome.

Is it available in hard copy?

Yes! On Amazon.

Is this a watered-down book on R?

Nope. Where applicable I draw parallels to Excel to aid in the instruction, but in no way are things oversimplified. There is very little on visualization and statistical analysis, and that is intentional.

–>