Excel: Pivot Tables – Full Day

Excel: Pivot Tables – Full Day

Learning Outcomes:

  • Describe the Anatomy of a Pivot Table including limitations, with Instructors approval.
  • Demonstrate proficiency in using Pivot Tables to answer questions by category and by month and use a chart to view the summary graphically.
  • Successfully use a PivotTable to sort and group data using the information in the Lesson Lab.
  • Demonstrate the best options for importing and exporting data with 100% accuracy.
  • Use PivotTables to summarize the results of two different kinds of business surveys.


During this full day course, students will learn how to use Pivot Tables to summarize and analyze large amounts of data.

  • When to use a Pivot Table & Why
  • Create a PivotTable
  • Create a Chart from a PivotTable
  • Group data
  • Use Running Total Options
  • Spot Trends using Pivot Tables
  • Multiple Consolidation Ranges
  • AutoFormatting

Excel: Pivot Tables – Full Day

Upon completion of this course, students should be comfortable with the below objectives:

Click here for Registration Form

Request More Information