• 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
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • 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
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Excel PivotTable Course – Quick Start

You are here: Home / Excel PivotTable Course – Quick Start

Many people are afraid of PivotTables, but in this course I’ll quickly have you building your own PivotTables with confidence. Once you understand the key ingredients of a PivotTable, you’ll wonder what all the worry was about.

Sample - Introduction to Pivot Tables and Data Layout

Your browser doesn't support HTML5 video. Here is a link to the video instead.



I know your time is valuable, which is why the complete course is just under 1.5 hours long with tutorials broken into short videos (on average 5 minutes long).
And when you're finished we'll send you a Certificate of Completion to add to your résumé.

Excel PivotTable Course Syllabus

  • Ideal Data Layout for PivotTables - get this wrong and you'll have nothing but trouble
  • Creating PivotTables
  • Formatting, Grouping Data and Sorting
  • Aggregation Options and Show Values As
  • Pivot Charts
  • Filters, Slicers and Timelines
  • GETPIVOTDATA Function
  • Adding New Data and Refreshing
  • Troubleshooting - what causes problems and how to fix them
  • Conditional Formatting
  • Calculated Fields and Items
  • Introduction to the Data Model
  • PivotTable Options and Settings
Note: this course is an extract of our Advanced Excel Course.

Who is Teaching the PivotTable Course?

Mynda MVP

That would be me, I'm Mynda Treacy, Co-founder of My Online Training Hub, and a Microsoft Excel MVP.

I have been working with Excel since 1995 and teaching since 2010 (not including teaching many colleagues over the years), and I'm excited to be able to share what I have learned with you.

Back when I started using Excel I was lucky, in that you weren't expected to know how to use it! As you'd know, that's not the case these days.

Once you've completed the course and practiced what you learn you’ll be able to build PivotTables with ease.

Separator Image

Course Prerequisites

  • Requires Excel 2007 or later. The course was filmed in Excel 2019/Office 365.

Choose Your Membership Level

Choose Currency
cart images
These Prices Already Have The 20% Discount Applied

PivotTables Quick Start - Online

$39Add to cart

$39Add to cart

12 Months Online

$39Add to cart


Online Only Access
To Course
PivotTable Quick Start Course Videos 1hrs 27mins
One Payment for 12 Months Access
Unlimited 24/7 access
Pause, rewind, replay
Download Workbooks and Practice Data
30 Day Money Back Guarantee

 

PivotTables Quick Start - Online + Download

$79Add to cart

$79Add to cart

12 Months Online + Download

$79Add to cart


Online Access + Download & Keep Course Videos
PivotTable Quick Start Course Videos 1hrs 27mins
One Payment for 12 Months Access
Unlimited 24/7 access
Pause, rewind, replay
Download Workbooks and Practice Data
30 Day Money Back Guarantee

 

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.

Added to Cart

Blog Categories

  • 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
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

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.