Thomas Fragale

Microsoft Certified Trainer



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

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


Here's the link to my first lesson:


Please sign in or sign up to comment.