Modules – Intro to Excel 2016 Pivot Tables

​Module 1
1.1 Pivot Table Structure
1.2 Assigning Names to Tables – Practice Exercise 1
​1.3 Creating a Pivot Table – Practice Exercise 2
1.3.1 Creating a Pivot Table Using the Standard Method – Practice Exercise 3

Module 2
2.1 Customizing the Pivot Table – Practice Exercise 4
2.2 Compact, Outline, Tabular Views – Practice Exercises 5 – 7
2.3 Adding, Removing, Relocating Subtotals – Practice Exercises 8 and 9
​2.3.1 Add Subtotal to a Specific Field – Practice Exercise 10
2.4 Removing Grand Totals, Insert Blank Lines, Repeat All Items Labels – Practice Exercises 11 – 13
​2.5 Improving Pivot Table Readability – Practice Exercise 14

Module 3
​3.1 Create and Remove Calculated Fields – Practice Exercises 15 and 16
3.2 Create and Remove Calculated Item – Practice Exercises 17 – 19
​
Module 4
​4.1 Create a Pivot Table Slicer – Practice Exercise 20
​4.2 Create a Pivot Table Timeline – Practice Exercise 21
​4.3 Create a Pivot Table Chart – Practice Exercise 22

To begin the course, go to Module 1 Section 1.1 Pivot Table Structure