• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Excel PivotTable Course

You are here: Home / Excel PivotTable Course

PivotTables enable you to take massive amounts of data and quickly summarise and analyse it with just a few clicks of your mouse.

This power means you can create reports extremely quickly, and respond to the inevitible report change requests without dread.

Just look at how quickly the data below is transformed into meaningful information with little more than a drag and drop. And changes are easy; no formulas to edit, no copy and paste - just PivotTable power.

Your browser does not support modern web standards. Please update it.


Xtreme PivotTable Course

Our Xtreme Excel PivotTable course makes mastering PivotTables easy with video tutorials delivered in bite size chunks (average is 3 minutes long). We'll have you pivoting your data in no time.

  • Comprehensive syllabus covering every aspect of PivotTables - It's the most extensive PivotTable training available, leaving no menu unturned. Every feature is covered in detail and then applied to real life scenarios.

    Xtreme PivotTables Syllabus

  • Tips and Tricks - we'll teach you the tips, tricks and shortcuts that would take you years to learn on the job

  • Practice Workbooks - Get hands on experience as you practice what you learn using the actual workbooks you see in the videos

  • Real Life Case Studies - the course includes loads of examples applied to real business scenarios that people like you experience in your day to day work.

  • PivotTable Cheat Sheet - Bonus cheat sheet to stick on your desk

  • Watch on any device quality HD videos are compatible with PC, Tablet, iPad or phone

  • Compatible - The training was recorded using Excel 2010 and it is compatible with Excel 2007, Excel 2013, Excel 2016, Excel 2019 and Microsoft 365. Some concepts are not available in Excel 2007 (like Slicers and some Pivot Table Calculations)

  • 12 Months Support - I'm here to help if you get stuck with a PivotTable problem. This isn't one of those online courses where you're on your own.

  • 30 day money back guarantee - If you are not satisfied with the course, I will return 100% of your money without any questions. That's my personal guarantee to you!

Who's Teaching the Course?

I'm John Michaloudis. I'm a long timer lover of Excel and PivotTable Geek.John

I hold a bachelors degree in Commerce (Major in Accounting) from La Trobe University in Melbourne, Australia and speak English, Greek and Spanish. In 2020 I was awarded Microsoft MVP for my contribution to the Excel community.

My journey in to Excel began after I graduated and have since helped many of my colleagues around the world understand this underutilised but powerful tool. Now its my turn to teach you!

Who is the course for?

  • Suitable for all levels - From someone who has picked up Microsoft Excel for their first time, to someone who uses it around 2-3 hours a day, as well as long time Excel users who want to go deep in to learning all the commands, tricks and visual analytical reports that Pivot Tables have to offer.

  • Scared of PivotTables - if you've tried to learn PivotTables before but have struggled then this course is for you. I start from the very beginning and have broken it down into small steps to allow you time to practice as you go, which helps to cement your understanding. Once you get up to speed you'll see they're actually very easy to use... much easier than formulas

  • PivotTable Intermediate - if you're familiar with PivotTables but would like to tackle some of the more advanced topics like Calculated Fields, Show Values As, Conditional Formatting with PivotTables, Grouping, Slicers etc. then you can skip the topics you already know and go straight to the more advanced lessons.

  • Update your Skills - PivotTables are a must have Excel skill. If your resume is missing PivotTables then you're going to find it that bit harder to convince a prospective employer of your Excel abilities.

  • Handle Big Data - if you work with big data, or even large data then PivotTables are going to make your life easier. They're far more efficient than formulas and are handy for quickly getting a feel for new data and what patterns exist.

Watch Sample Tutorials

Inserting a PivotTable

Your browser does not support the video tag.


Creating Multiple Sub-Totals

Your browser does not support the video tag.


What Past Students have said

“The videos are short and precise, easy to understand and gives you the ability to refer back to them at any time” - Keith, Australia
"I have learned more about Pivot Tables within a week of taking this course than I have over the last couple of years. Really amazing stuff!" - Joyce, England
This course is tremendously comprehensive. The best part is that the course is served in small bite-sized pieces that are easily digested. A teaching course that doubles as a reference guide. Definitely worth your time and money.” James - Atlanta

Choose Your Course

  • Online Only : 12 months online access to the course(s)
  • Online + Download : 12 months online access to the course(s) + download the course videos to keep
  • GST : Prices are shown exclusive of GST for Australian customers.
These Prices Already Have The 20% Discount Applied
Add Discount Code PIVOTWEB in the shopping cart to get 20% off these prices.
Currency
Choose Currency
Xtreme PivotTables Online Xtreme PivotTables Download
30 Day Guarantee
Note: prices are +GST for Australian customers.

$149Add to cart

$149Add to cart

12 Months Online

$149Add to cart

$299Add to cart

$299Add to cart

12 Months Online + Download

$299Add to cart

Power BI Course InformationXtreme PivotTable Videos
11hrs 6min
One Payment for 12 Months Online Access
Download Videos * See Notes
Unlimited 24/7 access
Pause, rewind, replay
Download Workbooks
and Practice Data
30 Day Money Back Guarantee


Add Other Courses and Get 20% Off Each One.

  • power query coursePower Query
  • Get data from almost anywhere. Clean, transform, merge & append data. Load into Excel/Power Pivot for reporting.
  • Online Only

    $129Add to cart

    $129Add to cart

    $129Add to cart

  • Online + Download

    $259Add to cart

    $259Add to cart

    $259Add to cart

  • Excel Course InformationPower Query Videos 4h 22m
  • Download Sample Excel Workbooks
  • Download Completed Power Query files
  • Compatible with Excel 2010, 2013 and 2016
  • BONUS e-Book: M is for (Data) Monkey by Ken Puls and Miguel Escobar
  • power pivot coursePower Pivot
  • Transform enormous quantities of data from different sources, into meaningful information.
  • Online Only

    $169Add to cart

    $169Add to cart

    $169Add to cart

  • Online + Download

    $339Add to cart

    $339Add to cart

    $339Add to cart

  • Excel Course InformationPower Pivot Videos 5h 42m
  • Hands on project based learning
  • Download Sample Excel Workbooks
  • Download Completed Power Pivot files
  • Compatible with Excel 2010, 2013 and 2016
  • BONUS e-Book: Learn to Write DAX by Matt Allington
  • premium coursePremium
  • Master the core tools any professional needs : Excel, Word & Outlook.
  • Online Only

    $199Add to cart

    $199Add to cart

    $199Add to cart

  • Online + Download

    $399Add to cart

    $399Add to cart

    $399Add to cart

  • Excel Course Information30+ hours of videos : Excel 2007, 2010, 2013, 2016, 2019 & O365
  • Word Course Information20+ hours of videos : Word 2007, 2010, 2013, 2016, 2019 & O365
  • Outlook Course Information30+ hours of videos : Outlook 2007, 2010, 2013, 2016, 2019 & O365
  • Download Sample Excel Workbooks and Word Documents
  • Customized Learning : Only Learn What You Need
  • excel expert courseExcel Expert
  • Start with the essentials then cover must-know skills to go from Zero to Hero in Excel
  • Online Only

    $119Add to cart

    $119Add to cart

    $119Add to cart

  • Online + Download

    $239Add to cart

    $239Add to cart

    $239Add to cart

  • Excel Expert Course Information35+ hours of videos
  • Download Sample Excel Workbooks
  • 102 Excel Tips & Tricks Videos
  • BONUS eBook : CTRL + SHIFT + ENTER Mastering Excel Array Formulas by Mike Girvin
  • excel for finance courseExcel for Finance
  • Leverage Excel's tools for financial analysis. Ideal for accountants, executives, analysts and busines school students.
  • Online Only

    $19Add to cart

    $19Add to cart

    $19Add to cart

  • Online + Download

    $39Add to cart

    $39Add to cart

    $39Add to cart

  • Excel for Finance Course Information1h 24m of course videos
  • Time Value of Money
  • What-if Analysis
  • Future Value
  • Amortization
  • Depreciation
  • Case Study
  • excel for customer service courseExcel for Customer Service
  • Efficiently and accurately collect and analyze data in customer service or call center environments.
  • Online Only

    $49Add to cart

    $49Add to cart

    $49Add to cart

  • Online + Download

    $99Add to cart

    $99Add to cart

    $99Add to cart

  • Excel for Customer Service Course Information2h 52m of course videos
  • Download Workbooks & Practice Data
  • Download 36 Excel Software Models
  • Detailed 215 Page Reference Guide
  • excel for decision making courseExcel for Decision Making
  • Make business decisions using Monte Carlo simulations, Decision Trees and Forecasting with the Data Analysis Toolpak
  • Online Only

    $49Add to cart

    $49Add to cart

    $49Add to cart

  • Online + Download

    $99Add to cart

    $99Add to cart

    $99Add to cart

  • Excel for Decision Making Course Information2h 14m of course videos
  • Download Workbooks and Practice Data
  • Examine Real Business Case Studies
  • Practice Exercises
  • excel analysis toolpak courseExcel Analysis Toolpak
  • Statistics, histograms, correlations, regression, rank & percentile, random numbers and sampling.
  • Online Only

    $19Add to cart

    $19Add to cart

    $19Add to cart

  • Online + Download

    $39Add to cart

    $39Add to cart

    $39Add to cart

  • Excel Analysis Toolpak Course Information1h 20m of course videos
  • Download Workbooks and Practice Data
  • Examine Real Business Case Studies
  • Practice Exercises

Notes

  • Videos will be available for download after the 30 day Money Back Guarantee period ends. You can watch the videos online in the meantime.
  • Membership and access to the training materials is for one person only. Logons are not to be used by multiple people.
  • Downloaded videos are to be used only by the registered member, they are not to be transferred/shared amongst other people.
  • You can request a refund provided that no more than 30% of the course videos have been watched.
20% Discount Ends In
  • 00

  • 00

  • 00

DAYS HOURS MINS

Added to Cart

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
 
  • About My Online Training Hub
  • Contact
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Copyright © 2023 · My Online Training Hub · All Rights Reserved

Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.

Download A Free Copy of 100 Excel Tips & Tricks

excel tips and tricks ebook

We respect your privacy. We won’t spam you.

x