Module 1 – Intro to Excel 2016 Pivot Tables

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

  • 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