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
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