The Ultimate Pivot Table Course

8 Hour Video Course

The Step by Step system to learning and understanding pivot tables in Excel.

Why Learn Pivot Tables?

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!

Meet Your Instructor

John-Macdougall-work-profile-photo-525x525-e1521506913655 Pivot Table Course
Microsoft-MVP Pivot Table Course

John MacDougall

Microsoft Excel MVP

Hi, 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 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!

What are you Going to Learn?

The Ultimate Pivot Table Course makes learning pivot tables easy with our step by step system delivered in manageable sized videos (average is 3 minutes long). You’ll be creating pivot tables with your own data in no time.

coding-icon_4 Pivot Table Course

Step 1 : The Basics

Descriptions blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah.

1 hr 10 min

coding-icon_4 Pivot Table Course

Step 2 : Formatting

Descriptions blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah.

1 hr 10 min

coding-icon_4 Pivot Table Course

Step 3 : Sorting

Descriptions blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah.

1 hr 10 min

coding-icon_4 Pivot Table Course

Step 4 : Filtering

Descriptions blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah.

1 hr 10 min

coding-icon_4 Pivot Table Course

Step 5 : Grouping

Descriptions blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah.

1 hr 10 min

coding-icon_4 Pivot Table Course

Step 6 : Calculated Fields & Items

Descriptions blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah.

1 hr 10 min

coding-icon_4 Pivot Table Course

Step 7 : Show Values As

Descriptions blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah.

1 hr 10 min

coding-icon_4 Pivot Table Course

Step 8 : Pivot Charts

Descriptions blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah.

1 hr 10 min

coding-icon_4 Pivot Table Course

Step 9 : Slicers and Timelines

Descriptions blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah.

1 hr 10 min

coding-icon_4 Pivot Table Course

Step 10 : Building a Dashboard

Descriptions blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah.

1 hr 10 min

coding-icon_4 Pivot Table Course

Extras: Additional Tips and Tricks

Descriptions blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah.

1 hr 10 min

Who is this Course For?

Quick description about who should take this course.

What People are Saying About the Course

3 to 4 testimonials go here

Choose Your Course Option

Lifetime Online Only or Lifetime Online + Download

What you Get by Enrolling

Himenaeos. Sed molestie, velit ut eleifend sollicitudin, neque orci tempor nulla, id sagittis nisi ante nec arcu.
coding-icon_15 Pivot Table Course

Examples

Download all the workbooks and data to follow along with the course.

coding-icon_20 Pivot Table Course

Videos

Pause, rewind or replay any of the videos. Bookmark key learning points to come back to later.

coding-iconArtboard-19-copy-10 Pivot Table Course

Certificate

When you complete the course, you’ll recieve a certificate of completion from Microsoft MVP John MacDougall.

coding-icon_4 Pivot Table Course

New Content

Course content is updated whenever new pivot table features are added to Excel, so you’ll always be up to date with the lastest in pivot tables.

coding-icon_21 Pivot Table Course

Mobile

Content is easy to access either on mobile or desktop.

coding-icon_16 Pivot Table Course

Personal Help

Get expert help from a Microsoft MVP. I’ll be there to personally answer your questions.

Knowledge-vs-Success-Graph Pivot Table Course

Become an expert Today

By now, we all know that those with the top technical skills get the top pay. Get the skills you need to succeed and become an expert today with this step by step course to mastering pivot tables.

FAQ’s

Answers to some frequently asked questions.

Is there a free option to try it out?

Check out my FREE 1 hour webinar. It’s packed with a ton of great pivot table content you can start using today! If you like what you see, you can then upgrade to the full paid course.

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.

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.

Can I cancel at any time?

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.

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.

My 100% money back guarantee

Temp-Guarantee Pivot Table Course

HOW ABOUT A GUARANTEE?

The Ultimate Pivot Table Course comes with a 30 day 100% money back guarantee. I pride myself on high quality teaching that actually works. If you follow the steps, I guarantee you’ll master using pivot tables.

ABSOLUTELY NO RISK!

If you are unhappy for whatever reason just email me within 30 days of purchase and you will receive a full refund. I stand behind The Ultimate Pivot Table Course 100%.

Pin It on Pinterest

Share This