Excel 2013: PivotTables & PivotCharts

Expected Duration
Lesson Objectives
Course Number
Expertise Level


Analyze data efficiently using Excel 2013. Discover how to work with PivotTables, including formatting, sorting, filtering, grouping, and using slicers. In addition, explore how to insert, modify, and analyze using PivotCharts.

Expected Duration (hours)

Lesson Objectives

Excel 2013: 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 & filtering data in your PivotTable
  • 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