SkillSoft Explore Course – Lambers, Inc.

Desktop Certifications Isograd TOSA Desktop TOSA Excel 2016

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.

Asset ID	ds_msex2016_12_enus
Course Type	Video Course
Course Category	Isograd

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

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