Course Overview and Files
  • Introduction
  • Course Files
Pivot Table Basics
  • Creating a pivot table
  • Formatting Data
  • Summing values
  • Changing Items
Value Field Settings - Summarize Values By
  • Overview and Summarize by Count
  • Nested Fields
  • Nested Fields and Drill Down
  • Summarize by Average
  • Summarize by Min and Max
  • Other Ways to Summarize
Selecting, Moving, and Clearing Pivot Tables
  • Selecting, Moving, and Clearing
Pivot Table Design
  • Design Overview
  • Subtotals and Grand Totals
  • Report Layout and Blank Rows
Value Field Settings - Show Values As
  • Overview
  • % of Another Number
  • % of
  • % of Parent Total
  • Difference From and Rank Order
  • Running Totals
  • Index
  • Practice - % of Another Number - Problem 1
  • Practice - % of Another Number - Problem 2
  • Practice - % of Another Number - Problem 3
  • Practice - % of Another Number - Problem 4
  • Practice - Difference From
  • Practice - Misc 1
  • Practice - Misc 2
Filtering
  • Filtering Basics
  • Multiple Filters
  • Slicers
  • Slicer Options
  • Timeline
  • Timeline Options
  • Report Filter Pages
Grouping
  • Manual Grouping
  • Automatic Grouping
  • Automatic Grouping with Ranges
Calculated Fields & Items
  • Calculated Fields
  • Calculated Items
Other Pivot Table Concepts
  • Referencing Pivot Table Cells
  • Sparklines
  • Pivot Charts
  • Refreshing Pivot Table Data
"Homework" Practice Problems
  • Overview and File
  • Basic Concepts
  • Grouping
  • Referencing Cells
  • Calculated Fields