Welcome to the Course!
  • Welcome to the Course on Excel 2016 Pivot Tables
  • Life Before Excel Pivot Tables
  • Life After Excel Pivot Tables
  • Download Course Resources from Here
Excel Pivot Table Fundamentals
  • Why Should You Use Excel Pivot Tables?
  • When Should You Use a Pivot Table?
  • Anatomy of an Excel Pivot Table
Creating a Basic Excel Pivot Table
  • Preparing Your Data For Excel Pivot Tables
  • Summary of Preparing the Data Source for a Pivot Table
  • Case Study: Cleaning Up Data for Pivot Table Analysis
  • Creating a Basic Pivot Table - Part 1
  • Creating a Basic Pivot Table - Part 2
  • Filtering Pivot Tables with Slicers
  • Updating Pivot Table Data Sources
  • Deferring Layout Update, Starting Over with One Click and Relocating Pivot Table