Excel 2016: Creating PivotTables & PivotCharts

Expected Duration
Lesson Objectives
Course Number
Expertise Level


Excel 2016 includes powerful tools to summarize, sort, count, and chart data. Learn how to create, edit, and format PivotTables and PivotCharts; use calculations; sort, filter, and group data; and work with a slicer.

Expected Duration (hours)

Lesson Objectives

Excel 2016: Creating PivotTables & PivotCharts

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

    Expertise Level