Skip to content
Write a review
UdemyExcelPaid courseBeginner levelCertificate

R Tidyverse Reporting and Analytics for Excel Users (Udemy.com)

From Excel To Big Data and Interactive Dashboard Visualizations in 5 Hours

4.5
783 reviews

Created by: Jonathan Ng

Last updated August 2021

How it compares

Against the other 355 rated Udemy courses in Excel on CourseDuck:

  • Rating4.5 out of 5higher than 39% of them
  • Reviews783#195 of 356 by number of reviews
  • Length5.3 hoursshorter than 52% of them
  • Last updatedAugust 2021earlier than 67% of them

icon
Course Description

If you use Excel for any type of reporting or analytics then this course is for you. There are a lot of great courses teaching R for statistical analysis and data science that can sometimes make R seem a bit too advanced for every day use. Also since there are many different ways of using R that can often add to the confusion. The reality is that R can be used to make your every day reporting analytics that you do in Excel much faster and easier without requiring any complex statistical techniques while at the same time giving you a solid foundation to expand into those areas if you so wish. This course uses the Tidyverse standards for using R which provides a single, comprehensive and easy to understand method for using R without complicating things via multiple methods. It's designed to build upon the the skills you are already familiar with in Excel to shortcut your learning journey.

When I first started using R I thought that it could be a good replacement for the automation type processes I used to write in VBA. This can be quite off putting for a lot of Excel users as VBA often adds an extra layer of complexity to your work and is often only something which is done to automate a process which has already been established in Excel. One of the key benefits of Excel is that you are working directly with the data without having to go through the complexity and overhead of using a programming language.

Programming languages such as VBA are actually very difficult for working with data as there isn't even any concise way of referencing common data elements such as named table columns. To carry out an operation on every row would take several lines of code which runs slow and ends up hiding your formula which actually contains your business logic.

Despite all of this people use VBA anyway as once you invest the time to setup your processes you can run the exact same steps thousands of times with a click of a button.

What if there were a way to work directly with your data as simply as Excel but also have more programming power than VBA? That's what R can do for you.

Since I've started using R people have asked me when it would be beneficial to use R instead of Excel. Here are some examples

1. vlookups and sumifs on large datasets can run very slowly in Excel. I've helped people to replace multiple lines of vlookups that take 80 minutes to run in Excel with a single function in R that takes less than 1/10th of a second.

2. Exploring and analysing your data in R can be Viewed in a simple table like Excel but also has a wide range of other methods which can be more effective.

3. Dashboards and visualisations are much richer and easier to construct than in Excel

4. Distributing your work in Excel can be beneficial since almost everyone has Excel installed. The problems with this are that not everyone always has the same version of Excel or addins installed which means your work might not be compatible. Also files are usually emailed around which can very quickly lead to hundreds of untracked copies of your Excel files with slight variations in them. The outputs from R can be simple Excel or csv files however your output can also be a web app that can be centrally stored and tracked on a server compatible with any web browser on your computer or smart phone.

5. Team collaboration and version control in Excel is done via shared workbooks and track changes. Turning on these features in Excel disables some of Excels best features and still results in file locking. Team collaboration in R is done on github which allows you to easily work across teams without file locking issues and full audit histories of your work.

The beauty of R is that once you start using it you will no longer have to make a special investment of time to automate your processes after your analysis is done. Practically anything that you can do in Excel you'll be able to do faster and better for even your first round of analysis and will leave you with an script which means your work is reproducible and automated from the very beginning.

Even though your existing Excel skills will help you to pick up R one of the hardest things is that you're so familiar with Excel that it's too easy to keep on using it. I used Excel for years and spent thousands of hours studying how to use it more efficiently, I even taught advanced courses in it. It seemed obvious to me at the time that it was one of the most efficient ways to work with data. Even though working with a programming language might be more powerful it often had too much over head and was too removed from the actual data analysis. R is the programming language I wish I learnt 20 years ago. Perhaps somewhat counter intuitively you'll end up spending less time thinking about how to put a piece of work together than Excel and more time looking at your data in new ways that you've probably never even thought of.
Who this course is for:
If you are currently using Excel to deliver a regular reporting requirement this course will be a good fit for you. This course is designed to introduce R to non programmer Excel users who are already familiar with Pivot Tables, vlookups ,if statements and charts.
Read More Beginner Beginner Level product length iconTime: 5.3h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Jonathan Ng

I've always enjoyed figuring out how to get things done in the most efficient way possible. How do you achieve 10x more results with 10x less work? Whether you're looking to get in shape, learn a new sport, invest for your future or get better at your job there are tips, tricks, strategies and shortcuts that can help you achieve that more effectively.
One of your key tools will absolutely be the effective use of technology. Technology is a multiplier of results and learning to use the right technology for the job is key.

Read More

icon
More courses by Jonathan Ng

$64.99

$79.99

All courses by Jonathan Ng

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

All Excel courses

icon
Reviews

4.5

783 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By Masedi Sesele on 9/27/2020

good

By Krzysztof Kleczewski on 8/15/2020

Without acquaintance with Shiny it would not be effective.

By Margaret Yuan on 8/2/2020

Advance Excel User. Want to learn R as another tool

By Nic Spearman on 7/25/2020

An intuitive introduction to R for data visualisation

By Nicolas Cocaro on 7/20/2020

Excellent course. Johnatan really hits the nail on what to explain and how. Super usefull. Looking forward to the next series of Johnatan.

By Avinash Patil on 7/14/2020

bit explanation was required. on the packages and how you came to know that the rlang only work for you.

By Praful. Gharpure on 6/23/2020

Intresting

By Ray K on 6/15/2020

It Is very practical, and he knows his subject very well and his focus is to get the student up and running as soon as possible. Ive just started watching and its very good so far.

By Joel Rodriguez on 6/5/2020

Wow, I truly feel like I should pay more for this course.
I am going through this course slowly and I am enjoying every bit of it.
I feel like I have gotten more than what I paid for.

By Prateek Shridhar Verma on 5/21/2020

Amazing. Very clear delivery.

By Michael Greiner on 5/13/2020

Seems well organized and focused.

By Philippe BENITEZ on 5/12/2020

Great course.

Showing 12 of 100 reviews

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 90 / 100

R Tidyverse Reporting and Analytics for Excel Users
Visit course on Udemy Write a review
  • Video Duration: icon 5.3h
  • Price: $99.99
  • Provider: icon Udemy
  • Updated: icon August 2021
  • Level: Beginner Beginner
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com