Excel 2010: PivotTables & PivotCharts

Expected Duration
Lesson Objectives
Course Number
Expertise Level


A PivotTable is one of the most powerful and intimidating features in Excel. Discover how to get the most out of a PivotTable or PivotChart to help you summarize and extract information from your data.

Expected Duration (hours)

Lesson Objectives

Excel 2010: PivotTables & PivotCharts

  • Creating a PivotTable
  • Editing your PivotTable
  • Formatting your PivotTable
  • Comparing values in a PivotTable
  • Copying & reusing your PivotTable
  • Inserting a calculation in your PivotTable
  • Sorting data in your PivotTable
  • Filtering your PivotTable data
  • Grouping data in your PivotTable
  • Inserting a slicer
  • Customizing a slicer
  • Inserting a PivotChart
  • Modifying your PivotChart
  • Analyzing your database tables in a PivotChart
  • Course Number:

    Expertise Level