Module 4 – Intro to Excel 2016 Pivot Tables

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
Module 4 Learning Objectives
Given a standard IBM-compatible personal computer with Microsoft Excel 2016 installed, after reading the assigned study guide pages as well as watching the instructor-led video(s), at the end of the module the student will be able to:

  • Identify the steps used in creating a Slicer for filtering a pivot table
  • Imitate the instructor’s action in creating a Slicer for filtering a pivot table
  • Identify the steps used in creating a Timeline for filtering a pivot table
  • Imitate the instructor’s action in creating a Timeline for filtering a pivot table
  • Identify the steps used in creating a pivot table chart
  • Imitate the instructor’s action in creating a pivot table chart
 To begin Module 4, go to Section 4.1 Create a Pivot Table Slicer