Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

How to get meaningful results from your raw data using Excel Pivot Tables, Pivot Charts and Slicers

Tom Fragale, Microsoft Certified Trainer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
9 Videos (36m)
    • Pivot Tables Lesson 1 - Getting Started

    • Pivot Tables Lesson 2 - Getting a Drill Down

    • Pivot Table Lesson 3 - Changing the Calculation Type

    • Pivot Table Lesson 4 - Adding Levels of Detail

    • Pivot table lesson 5 - Creating a Monthly, Yearly, Quarterly, or Daily Report

    • Pivot Table lesson 6 - Sorting and Filtering the Pivot Table

    • Pivot Table Lesson 7 - Adding a Chart to the Pivot Table

    • Pivot Table lesson 8 - Adding Slicers and Timelines

    • Pivot Table lesson 9 - Creating many Summary Sheets


About This Class


This video will show step-by-step how to take your raw data that you have in Microsoft Excel and get great results that can help you make better decisions using pivot table.This will make it super easy so anybody can get great results pretty quickly

You will learn the following topics:

  • How to make a basic pivot table
  • Generating a drill-down to show the detail breakdown of any number shown in the pivot table
  • How to change the type of calculation
  • How to add multiple calculations
  • Where to find even more calculation types, including % of total
  • How to add more summary levels
  • How to make the pivot table into a daily, monthly, quarterly, or yearly summary
  • Sorting and Filtering the pivot table
  • Adding a chart to your pivot table
  • Adding some more filters with the powerful new slicer and timeline features, which create an easy to use dashboard.
  • Creating multiple sheets from a pivot table

6 of 6 students recommendSee All

An excellent tutorial of Excel's powerful but somewhat puzzling feature, the Pivot Table. Explained very well, simply and clearly. Great examples, not too simplistic, nor too complicated. And a whole load of useful features demonstrated one after the other with great clarity. Thank you !
Informative, short and concise and always included a summary of the steps again at the end of the videos. However, would prefer if there is a "goal" clearly set out in the beginning of the video so that we know what we are trying to achieve through the video. Overall: Learnt lots of new stuff about Pivot Tables; great if you have just 1/2 hour to spare and want to improve your Excel skills. Loved it!
I'm a fairly experienced Excel user but I still learned something new (there's always more to learn with Excel), particularly in the later lessons. I like Tom's concise style.





Tom Fragale

Microsoft Certified Trainer