The Ultimate Guide to Pivot Tables
The Step by Step system to building pivot tables that will impress your boss!
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.
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 value.
Meet Your Instructor
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.
Step 1: Pivot Table Basics
Learn all the basics you need to know to work comfortably and efficiently with pivot tables.
- Inserting your first pivot table using a few different methods.
- Getting to know the pivot table tools tab and field list.
- Building your first pivot table.
- What is a pivot table actually doing?
- Refreshing your pivot table data.
- Changing your source data.
- Selecting, clearing and moving pivot tables.
- Field settings and value settings.
Step 2: The Secrets To Making Your Pivot Tables Look Amazing
Make your pivot tables look amazing!
- Format numbers to make them more readable.
- Change report layouts.
- Add or remove subtotals and grand totals.
- Change style options.
- Add conditional formatting like data bars or icon sets.
Step 3: The Easy Tricks to Sorting Data the Way You Want
Learn the easy methods to getting your pivot tables sorted the way you want.
- Sort Alphabetically from A to Z or from Z to A.
- Sort from smallest to largest or from largest to smallest.
- Manually sort field items.
- Create custom sort orders.
Step 4: Filtering to Focus on Only the Data You Want to See
Filter your pivot tables in many different ways to see exactly the data you want to see.
- Text based label filtering.
- Numerical based value filtering.
- Manually filtering.
- Create powerful and flexible filters with wildcards..
Who is this Course For?
Quick description about who should take this course.
What People are Saying About the Course
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.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.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.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.Clear and concise explanations with simple demos. Really awesome course!!!
John responded to all my questions quickly and was able to help me with my specific data. Certainly one of the best courses for pivot tables available because of the personal touch!
Greg P.The course was well designed and arranged in a logical order.
The explanations were simple enough, yet thorough. I loved it (as much as you can love an Excel course).
Janice R.Awesome Bonuses Just For You!!!
Awesome Bonus #1
Get a free copy of my e-book 101 Awesome Pivot Table Tips and Tricks!
- This book is packed with an amazing 101 (well actually 102, but who’s counting) awesome pivot table tips!
- Fully illustrated and written straight to the point style.
- Many tips you won’t find anywhere else.
A $25 value, but yours free when you sign up for the course.
Awesome Bonus #2
I’ve partnered up with Vertex 42, the leader in Excel & Word templates, to offer The Vertex42® Spreadsheet Tips Workbook.
It’s a downloadable spreadsheet file for Excel that lets you learn and practice essential skills directly within Excel. The 142 tips are mini tutorials that teach basic to advanced Excel skills, with examples taken from some of the most popular Excel templates on Vertex 42.
- 142 beginner, intermediate and advanced tips.
- Crucial keyboard shortcuts.
- Powerful formulas and advanced formatting techniques.
- Charts, graphs and useful drawing tools.
A $30 value, but yours free when you sign up for the course.
Awesome Bonus #3
You get ME, your personal Microsoft MVP to help you every step of the way!
I regularly charge clients between $100 and $150 per hour for my consulting, but you get access to me for free when you enroll in the course.
I’ll be there to answer any course questions and help you apply the topics covered to your own data.
A $500 value, but yours free when you sign up for the course.
Awesome Bonus #4
Everyone likes a deal, right?
Buy the course today and take an additional 20% off when you use the coupon code 20OFFTODAYONLY.
Save $49 when you enroll! Discount available today only!
Choose Your Course Option
Lifetime Online Only or Lifetime Online + Download
Ultimate Pivot Table Course
3 Easy Payments Option
USD $297
- ✔️ Three Easy Payments for Lifetime Online Access
- ✔️ Download Videos
- ✔️ Unlimited 24/7 access
- ✔️ Pause, Rewind, Replay
- ✔️ Download Workbooks and Practice Data
- ✖️ Save $48 with a One Time Payment Option
- ✔️ 30 Day Money Back Guarantee
Ultimate Pivot Table Course
One Time Payment Option
USD $249
- ✔️ One Payment for Lifetime Online Access
- ✔️ Download Videos
- ✔️ Unlimited 24/7 access
- ✔️ Pause, Rewind, Replay
- ✔️ Download Workbooks and Practice Data
- ✔️ Save $48 with a One Time Payment Option
- ✔️ 30 Day Money Back Guarantee
What you Get by Enrolling
Himenaeos. Sed molestie, velit ut eleifend sollicitudin, neque orci tempor nulla, id sagittis nisi ante nec arcu.
Examples
Download all the workbooks and data to follow along with the course.
Videos
Pause, rewind or replay any of the videos. Bookmark key learning points to come back to later.
Certificate
When you complete the course, you’ll receive a certificate of completion from Microsoft MVP John MacDougall.
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 latest in pivot tables.
Mobile
Content is easy to access either on mobile or desktop.
Personal Help
Get expert help from a Microsoft MVP. I’ll be there to personally answer your questions.
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
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, and anything I put my name on needs to be the best! If you follow the course, I guarantee you’ll master using pivot tables.
ABSOLUTELY NO RISK!
Take the whole course, watch all the videos, download all the resources.
If you are unhappy for whatever reason just email me within 30 days of purchase and you will receive a full refund. No questions asked! I stand behind The Ultimate Pivot Table Course 100%.