Excel 2016: Creating PivotTables & PivotCharts


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

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)
1.1

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:
    ds_msex2016_12_enus

    Expertise Level
    Intermediate