Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.
Read instantly on your browser with Kindle for Web.
Using your mobile phone camera - scan the code below and download the Kindle app.
Follow the author
OK
R for Excel Users: An Introduction to R for Excel Analysts
Purchase options and add-ons
R has a steep learning curve and, if taken in all at once, it can be overwhelming. But we can tame this curve by putting aside visualizations and analysis, and focusing on working with data.
This book is all about data manipulation: importing, creating, modifying, filtering, summarizing and reshaping data sets. You will also go deep on the building blocks of R: vectors and functions.
The language is simplified and technical lingo is kept to a minimum. You will see analogies to Excel where applicable, to ease your understanding of concepts.
Supplemental articles and videos can be found at rforexcelusers.com
- ISBN-101500566357
- ISBN-13978-1500566357
- Publication dateAugust 8, 2016
- LanguageEnglish
- Dimensions7.44 x 0.48 x 9.69 inches
- Print length212 pages
Frequently bought together

Customers who viewed this item also viewed
- The Book of R: A First Course in Programming and StatisticsPaperbackGet it as soon as Tuesday, Sep 8
- R for Data Science: Import, Tidy, Transform, Visualize, and Model DataPaperbackFREE Shipping by AmazonGet it as soon as Monday, Aug 31
- Python Crash Course, 3rd Edition: A Hands-On, Project-Based Introduction to ProgrammingPaperbackFREE Shipping on orders over $35 shipped by AmazonGet it as soon as Monday, Aug 31
- Learning R: A Step-by-Step Function Guide to Data AnalysisPaperbackGet it as soon as Saturday, Sep 19
- Hands-On Programming with R: Write Your Own Functions and SimulationsPaperback$3.99 shippingGet it Sep 9 - 14
- The Book of R, 2nd Edition: A First Course in Programming and StatisticsPaperbackFREE Shipping by AmazonGet it as soon as Monday, Aug 31
Customers also bought or read
- The Book of R: A First Course in Programming and Statistics
Paperback$41.59$41.59FREE delivery Sep 8 - 12 - R for Data Science: Import, Tidy, Transform, Visualize, and Model Data
Paperback$43.99$43.99FREE delivery Mon, Aug 31 - Learning R: A Step-by-Step Function Guide to Data Analysis
Paperback$17.17$17.17Delivery Sep 19 - Oct 1 - R Programming for Beginners: An Introduction to Learn R Programming with Tutorials and Hands-On Examples
Paperback$19.95$19.95Delivery Mon, Aug 31 - Hands-On Programming with R: Write Your Own Functions and Simulations
Paperback$24.10$24.10$3.99 delivery Sep 9 - 14 - The Art of R Programming: A Tour of Statistical Software Design
Paperback$24.73$24.73Delivery Sep 8 - 12 - Statistical Analysis with R For Dummies (For Dummies (Computer/Tech))
Paperback$15.77$15.77Delivery Thu, Sep 3 - Practical SQL, 2nd Edition: A Beginner's Guide to Storytelling with Data
Paperback$19.99$19.99Delivery Mon, Aug 31 - R for Biologists: Learn R programming from scratch | No prior coding experience required | An absolute beginner's guide (Biotechnology Books)
Paperback$22.99$22.99Delivery Mon, Aug 31 - Learning SQL: Generate, Manipulate, and Retrieve Data#1 Best SellerSQL
Paperback$36.11$36.11FREE delivery Sep 3 - 5 - The Book of R, 2nd Edition: A First Course in Programming and Statistics
Paperback$50.58$50.58FREE delivery Mon, Aug 31 - Extending Excel with Python and R: Unlock the potential of analytics languages for advanced data manipulation and visualization
Paperback$44.99$44.99FREE delivery Mon, Aug 31 - Learn Microsoft Power BI: A comprehensive, beginner-friendly guide to real-world business intelligence
Paperback$44.99$44.99FREE delivery Mon, Aug 31 - Master Your Data with Power Query in Excel and Power BI: Leveraging Power Query to Get & Transform Your Task Flow
Paperback$27.09$27.09Delivery Mon, Aug 31 - SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL
Paperback$42.59$42.59FREE delivery Mon, Aug 31 - R Cookbook: Proven Recipes for Data Analysis, Statistics, and Graphics (O'reilly Cookbooks)
Paperback$30.93$30.93Delivery Sep 4 - 8 - R for Everyone: Advanced Analytics and Graphics (Addison-Wesley Data & Analytics Series)
Paperback$31.90$31.90Delivery Thu, Sep 3 - Beyond Spreadsheets with R: A beginner's guide to R and RStudio
Paperback$37.99$37.99$3.99 delivery Sep 11 - 18 - Data Visualization with Microsoft Power BI: How to Design Savvy Dashboards
Paperback$41.33$41.33FREE delivery Mon, Aug 31 - Practical Statistics for Data Scientists: 50+ Essential Concepts Using R and Python
Paperback$71.17$71.17FREE delivery Mon, Aug 31 - Head First SQL: Your Brain on SQL -- A Learner's Guide
Paperback$29.17$29.17$5.85 delivery Wed, Sep 2
Editorial Reviews
From the Back Cover
About the Author
In his 12+ year career, John Taveras has consistently driven big insights and large scale analysis through a masterful use of Excel, R, SQL and other tools. He has also taken time out to teach his peers - at Google, PwC, Travelers and business school - helping turn anxious learners into avid users of these tools.
Most recently, John led product development and analysis for an email marketing team at Google. He earned a BA in math and economics from Wesleyan University and an MBA from MIT Sloan School of Management.
Product details
- Publisher : CreateSpace Independent Publishing Platform
- Publication date : August 8, 2016
- Language : English
- Print length : 212 pages
- ISBN-10 : 1500566357
- ISBN-13 : 978-1500566357
- Item Weight : 15.3 ounces
- Dimensions : 7.44 x 0.48 x 9.69 inches
- Best Sellers Rank: #268,923 in Books (See Top 100 in Books)
- #97 in Data Modeling & Design (Books)
- #2,024 in Computer Science (Books)
- Customer Reviews:
About the author

In his 12+ year career, John Taveras has consistently driven big insights and large scale analysis through a masterful use of Excel, R, SQL and other tools. He has always taken time out to teach his peers - at Google, PwC, Travelers and business school - helping turn anxious learners into avid users of these tools.
Most recently, John led product development and analysis for an email marketing team at Google. He earned a BA in math and economics from Wesleyan University and an MBA from MIT Sloan School of Management.
Customer reviews
Customer Reviews, including Product Star Ratings help customers to learn more about the product and decide whether it is the right product for them.
To calculate the overall star rating and percentage breakdown by star, we don’t use a simple average. Instead, our system considers things like how recent a review is and if the reviewer bought the item on Amazon. It also analyzed reviews to verify trustworthiness.
Learn more how customers reviews work on AmazonCustomers say
Generated from the text of customer reviewsSelect to learn more
Top reviews from the United States
- 5 out of 5 stars
For people who think in spreadsheets and struggle learning programming
Reviewed in the United States on May 8, 2022Great book for people who think in spreadsheets and struggle learning programming. This is a pure beginners book to get you started in R and helps you understand basic concepts and uses Excel as a base knowledge to teach the concepts. I have various learning challenges that can make learning math and programming more challenging if it’s too abstract but the way the author approaches the topics in this book works for my learning style.
The layout and design of the book is very simple, easy to read without being overwhelming. I purchased both the Kindle and Print versions and found both formats good quality.
2 people found this helpfulSending feedback...Sending feedback...HelpfulThank you for your feedback.Sorry, we failed to record your vote. Please try againThanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again - 4 out of 5 stars
Very good introduction to R for Excel users
Reviewed in the United States on May 14, 2017Very good introduction to R for Excel users. Like others, I've often been intimidated by R when first opening any number of R guides, I think because I've entered the world of programming without consciously knowing it. By addressing basic data manipulation tasks any Excel analyst must do, in clear, step-by-step language, this book fills a gap in the R literature and does so in a manner friendly to those with no programming experience.
I will agree with an earlier reviewer that the Advanced Topics section does what I've praised above less convincingly. It in fact jumps into programming without any foundation, and seems to abandon the step-by-step clarity used in earlier sections. Perhaps it's just meant to give a taste of more advanced programming topics, but if you're like me you might find yourself confused at the sudden increased complexity and sparse explanations.
16 people found this helpfulSending feedback...Sending feedback...HelpfulThank you for your feedback.Sorry, we failed to record your vote. Please try againThanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again - 5 out of 5 stars
Very Detailed and Easy to Understand. I LOVE IT!
Reviewed in the United States on July 2, 2023I literally just got this book and I am a few chapters into it. I love it so far. Since I have been using Excel for so many years, his explanations are very understandable. I have taken a few R online classes and so I know the basics but sometimes get stuck. This book have helped me get more clarity in just a few days. I am looking forward more books from John Taveras because I will buy them ASAP. I hope he can create a larger book with more projects based on his work experience.
2 people found this helpfulSending feedback...Sending feedback...HelpfulThank you for your feedback.Sorry, we failed to record your vote. Please try againThanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again - 5 out of 5 stars
For those who want to take it to the next level
Reviewed in the United States on August 14, 2016I use Excel on a constant basis for work, but never had the occasion to use R in my day to day projects. I've often seen R referred to with mystical tones, as some sort of "black magic" that we would need to engage PhDs for if a conjoint analysis was called for. The friendly titling and simple explanation of John's book really drew me in however, as it illuminates the ways that R can be useful to me by drawing on Excel concepts I am already familiar with. I am already exploring avenues where I can provide a more granular analysis than I would have in the past, without needing to get external consultants on the case. This is a great intro for those of us who have some analytical experience, but are looking to take it to the next level.
14 people found this helpfulSending feedback...Sending feedback...HelpfulThank you for your feedback.Sorry, we failed to record your vote. Please try againThanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again - 5 out of 5 stars
Very good book for R beginners
Reviewed in the United States on June 18, 2017I really loved the book. I tried a few other volumes to start R, but this book was the one who got me into R immediately. The clear description and examples helped a lot, e.g. the examples on P162-163 to explain the course of the loop were really simple, easy to understand and humorous at the same time :)
Even though the title relates to Excel, I would still recommend this book for beginners of R even if they don't have a lot of experience in using Excel. The explanation are so clear and precise at the same time that it is a delight to read.
5 people found this helpfulSending feedback...Sending feedback...HelpfulThank you for your feedback.Sorry, we failed to record your vote. Please try againThanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again - 4 out of 5 stars
Great intro to R
Reviewed in the United States on October 30, 2016Great intro to R, especially the sections that focus on dplyr. Some of the later chapters were difficult to follow, and it seemed like the quality control went a little haywire during those parts. But it's a nice gentle introduction for Excel users. You won't be an R coder by the time you read through this, but if you work through the examples a few times, you will know enough to know how to start. I recommend going through the book at least twice - I certainly plan to.
7 people found this helpfulSending feedback...Sending feedback...HelpfulThank you for your feedback.Sorry, we failed to record your vote. Please try againThanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again - 5 out of 5 stars
This book was a truly fantastic resource for learning R
Reviewed in the United States on August 12, 2016This book was a truly fantastic resource for learning R. I have tried a number of other resources like Datacamp and Coursera videos, but this book gave the clearest and most straightforward explanations. At first I was skeptical of it being limited to just data manipulation, but now it makes sense to me because it really is the hardest part to learn. I actually started getting overwhelmed by all the cool advanced things you can do in R, but this book got me to focus on the foundational stuff.
I strongly recommend this book to anyone learning R!
14 people found this helpfulSending feedback...Sending feedback...HelpfulThank you for your feedback.Sorry, we failed to record your vote. Please try againThanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again - 5 out of 5 stars
This are both good resources but I always felt like I still didn't ...
Reviewed in the United States on March 17, 2017I just got this book and I'm through chapter 4. Finally someone wrote a book that hits the foundations and helps you conceptualize working with data in R. I've gone through the John Hopkins R Coursera course and some lessons on Datacamp. This are both good resources but I always felt like I still didn't understand the basics. This book bring it together. Highly recommend this book as your first exposure to R.
4 people found this helpfulSending feedback...Sending feedback...HelpfulThank you for your feedback.Sorry, we failed to record your vote. Please try againThanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again
Top reviews from other countries
Hubert Senyah5 out of 5 starsSimply amazing!!
Reviewed in the United Kingdom on July 30, 2019This is such an amazing book! It is well laid out and easy to understand. In my opinion the best introduction to R for excel users. I hope the author writes a sequel to this book because I will be the first in line to get it. Simply brilliant!!
Sending feedback...Thanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again
Adam5 out of 5 starsVery basic text & excellent intro to R
Reviewed in Australia on September 26, 2018This book is at the very very basic level and therefore the best book for non programmers wanting to learn R. The author starts with Excel concepts and then explains the process in R. The only requirement is an understanding of excel. Knowledge from this book is a good foundation to move onto other books on R.
Sending feedback...Thanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again
laksh5 out of 5 starsNice Reading
Reviewed in India on December 8, 2016It explains the R in excel way.
Worth spending few dollars. I felt that the book is priced bit high.
Sending feedback...Thanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again
Raúl5 out of 5 starsExcelente libro.
Reviewed in Mexico on January 12, 2017Explica a detalle el código que utiliza comparándolo con excel. Ademas de que trabaja con ejemplos muy fáciles de entender.
Sending feedback...Thanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again
Glen Hardingham5 out of 5 starsFive Stars
Reviewed in Australia on January 12, 2018It's much better than what I thought it would be.
Sending feedback...Thanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again
























