Module 1
1.1 Pivot Table Structure
1.2 Assigning Names to Tables – Practice Exercise 1
1.3 Creating a Pivot Table Using Recommended Feature – Practice Exercise 2
1.3.1 Creating a Pivot Table Using the Standard Method – Practice Exercise 3
1.2 Assigning Names to Tables – Practice Exercise 1
1.3 Creating a Pivot Table Using Recommended Feature – Practice Exercise 2
1.3.1 Creating a Pivot Table Using the Standard Method – Practice Exercise 3
Module 1 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:
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 main components of a pivot table structure
- Identify the consequences of using an unsuitable data table for a pivot table
- Identify the best practices used for creating a suitable data table candidate for a pivot table.
- Identify the steps used in creating a pivot table from the Recommended Pivot tables option
- Imitate the instructor’s action in performing steps using the Recommended Pivot tables option
- Identify the steps used in creating a pivot table using the standard method
- Imitate the instructor’s action in performing steps for creating a pivot table using the standard method