The Ultimate Guide to Data Analysis with Pivot Tables

The step by step system to building pivot table reports that will impress your boss!

Pivot Tables allow you to easily summarize large amounts of data and quickly turn it into meaningful insights.

With little more than a few drag and drop or point and click actions, you’ll be able to summarize and visualize your data. No complicated formulas or code is required.

Pivot-Table-Quick-Demo Pivot Table Course


In this step by step system, you’ll learn how to create dynamic reports your boss will love!

Learn the secrets of Excel's most useful and powerful feature. Using pivot tables requires the least amount of effort but will give you the maximum amount of use and value.


Your Instructor


John MacDougall
John MacDougall

I’m John! I’ve worked all over the world as an actuary and data analyst. I’ve been using Microsoft Excel for over 15 years.

I started the HowToExcel website and blog in 2016 to share my passion and expertise with the world. The site now has well over 50k followers that are learning how to Excel.

In 2017, I was awarded the Microsoft Excel MVP status (most valuable professional) from Microsoft for sharing my technical expertise and knowledge with the community. This is a distinction that only 83 others around the world have been awarded!


Course Curriculum


  Downloads
Available in days
days after you enroll
  Introduction
Available in days
days after you enroll
  Step 1: The Pivot Table Basics
Available in days
days after you enroll
  Step 2: The Secrets To Making Your Pivot Tables Look Amazing
Available in days
days after you enroll
  Step 3: The Easy Tricks to Sorting Data the Way You Want
Available in days
days after you enroll
  Step 4: Filtering to Focus on Only the Data You Want to See
Available in days
days after you enroll
  Step 5: Grouping Data Together to Find Hidden Trends
Available in days
days after you enroll
  Step 6: Extending Your Analysis With Calculated Fields & Calculated Items
Available in days
days after you enroll
  Step 7: Discovering The Power Of Show Values As
Available in days
days after you enroll
  Step 8: Creating Visuals With Your Data Using Dynamic Pivot Charts
Available in days
days after you enroll
  Step 9: Adding Impressive And Interactive Slicers & Timelines
Available in days
days after you enroll
  Step 10: Putting It All Together And Building A Beautiful Dashboard Your Boss Will Love
Available in days
days after you enroll
  Extras: Additional Tips And Tricks To Do Even More With Pivot Tables
Available in days
days after you enroll
  Case Study: Chicago City Employee Salaries
Available in days
days after you enroll
  Case Study: Titanic Survivor Data
Available in days
days after you enroll
  Pivot Table Webinar
Available in days
days after you enroll

Frequently Asked Questions


How often do you release new content?
Content is updated whenever new features are added to Microsoft Excel that relate to pivot tables. Content for new features will be added shortly after they are released in the Office 365 bi-annual update.
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
You can cancel your order anytime within the 30 day money back guarantee. I’m so confident this is the best course on pivot tables, that I’ll gladly give you a full refund if you don’t think so. Regardless of whether or not you’ve watched all the videos.
Is there a free option to try it out?
Yes! Check out the lessons available to preview in the course curriculum section.
Who is this video course for?
This course is desiged to take a complete beginner in Excel pivot tables to an advanced user. No knowledge of pivot tables is required, but you should have a basic level of knowledge with Excel including entering and editing data in a worksheet. Intermediate pivot table users will also gain a deep understanding and learn new tips, tricks and tools they can use.
What if I get stuck on a lesson?
I want you to succeed, so I’ll be there every step of the way to help you if need. Ask me any questions and I will personally answer you. I will even be available to jump on a quick screen share call to clarify any questions.
Why can't I download the videos?
You will need to purchase the download option on the course to download any of the videos. If you’ve purchased the download option, you will need to wait for the 30 day money back period to expire before you can download any of the videos.

Your videos are amazing! Simple and to the point. They go beyond just the basics and explain the more advanced topics. Thanks so much for the great course. It's already saving me tons of time in my work!

Steven H. Senior Accountant

I've never really used pivot tables before as I found them complicated and didn't have any clue what they could do. You've shown me just how easy they actually are.

Maria V. HR Manager

Wow! I never knew summarizing data could be so quick and easy as it is with pivot tables. Glad I found this course!

Brian L. Research Associate

I've been trying to learn about pivot tables on my own and didn't get too far, basically I wasted a lot of time. These tutorials are organized and well presented. It's been the key to quickly learning for me! I'm going recommend this course to anyone wanting to get straight to it.

Laura T. Marketing Specialist

Get started now!