Description: The Introduction to Excel 2016 Pivot Tables course is a 4-hour course, designed to teach a student business functionality of Excel in terms of relating information. This course is especially helpful if you are required to produce reports regularly in your work.
Module 1 – Intro to Excel 2016 Pivot Tables
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
Lessons
Lesson 1 Preview Lesson 2 Preview Lesson 3 Preview Lesson 4 PreviewModule 2 – Intro to Excel 2016 Pivot Tables
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:
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 tables
- 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
Lessons
Lesson 5 Preview Lesson 6 Preview Lesson 7 Preview Lesson 8 Preview Lesson 9 PreviewModule 3 – Intro to Excel 2016 Pivot Tables
Module 3 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 steps used in creating a Calculated Field in a pivot table
- Imitate the instructor’s action in performing the creation of a Calculated Field in a pivot table
- Identify the steps used in removing a Calculated Field in a pivot table
- Imitate the instructor’s action in removal of a Calculated Field in a pivot table
- Identify the steps used in creating a Calculated Item in a pivot table
- Imitate the instructor’s action in creating a Calculated Item in a pivot table
- Identify the steps used in removing a Calculated Item in a pivot table
- Imitate the instructor’s action in removal of a Calculated Item in a pivot table
- Identify the steps used in finding a Calculated Field in a pivot table
- Imitate the instructor’s action in finding a Calculated Field in a pivot table
- Identify the steps used in finding a Calculated Item in a pivot table
- Imitate the instructor’s action in finding a Calculated Item in a pivot table
Lessons
Lesson 10 Preview Lesson 11 PreviewModule 4 – Intro to Excel 2016 Pivot Tables
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 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 steps used in creating a Slicer for filtering a pivot table
- Imitate the instructor’s action in creating a Slicer for filtering a pivot table
- Identify the steps used in creating a Timeline for filtering a pivot table
- Imitate the instructor’s action in creating a Timeline for filtering a pivot table
- Identify the steps used in creating a pivot table chart
- Imitate the instructor’s action in creating a pivot table chart