Module 2 – Intro to Excel 2016 Pivot Tables

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 2 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 strengths and weaknesses of using the Compact View, Outline View, and Tabular View formats for pivot
  • Imitate the instructor’s action in building a pivot table using the Compact View, Outline View, and Tabular View
  • Identify how to relocate the subtotal position of a pivot table
  • Imitate the instructor’s action of relocating the subtotal position of a pivot table
  • Identify how to remove the Grand Total Column and Row Capabilities
  • Imitate the instructor’s action of removing the Grand Total Column and Row Capabilities
  • Identify how to insert blank lines after each pivot table item
  • Imitate the instructor’s action of inserting blank line after each pivot table item
  • Identify how to perform the Repeat All Items Labels feature
  • Imitate the instructor’s action of performing the Repeat All Items Labels feature
  • Identify basic steps used to improve pivot table readability
  • Imitate the instructor’s action of improving pivot table readability