Course Description

Course length:

4 Hours

Course Objective:

You will create and analyze PivotTable data.

Target Student:

This course is meant for people with a sound working knowledge of Microsoft Excel and general computer proficiency.


Before starting this course, students are recommended to take the following Element K courses or have equivalent knowledge: Microsoft® Office Excel® 2010: Level 1 and Microsoft® Office Excel® 2010: Level 2

Course Objectives

Upon successful completion of this course, students will be able to:

  • build a PivotTable.
  • analyze data using PivotTables.
  • present PivotTable data visually.

Course Content

Lesson 1: Building a PivotTable

Topic 1A: Insert a PivotTable

Topic 1B: Create a PivotTable Based on External Data

Topic 1C: Categorize PivotTable Data

Topic 1D: Customize a PivotTable

Lesson 2: Analyzing Data Using PivotTables

Topic 2A: Create Custom Calculations in a PivotTable

Topic 2B: Restructure a PivotTable


Lesson 3: Presenting PivotTable Data Visually

Topic 3A: Format a PivotTable

Topic 3B: Present a PivotTable in a PivotChart

Topic 3C: Print PivotTables and PivotCharts


Appendix A: Solvers
Appendix B: Goal Seek
Appendix C: Troubleshooting PivotTables