Module 4 – Intermediate Excel 2016

Module 4
4.1 Determining Pivot Table Need – Create a Pivot Table – Practice Exercise 23
4.2 Creating a Pivot Table – Practice Exercise 24
​4.3 Customize a pivot table by applying filtering – Practice Exercise 25
4.4 Customize pivot table by adding fields to Rows quadrant – Practice Exercise 26
4.5 Customize a pivot table by changing the Form Type – Practice Exercise 27

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 activity of video(s), at the end of the module the student will be able to:

  • Identify the elements of a pivot table
  • Imitate the instructor’s action in customizing a pivot table by applying filtering
  • Imitate the instructor’s action in customizing a pivot table by adding fields to the Row’s quadrant
  • Identify the attributes of the three basic pivot table form types
  • Imitate the instructor’s action in customizing a pivot table by changing the form type
  • Imitate the instructor’s action in customizing a pivot table by changing Value Field Settings
  • Imitate the instructor’s action in customizing a pivot table by preparing it for printing