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