SkillSoft Explore Course – Lambers, Inc.

Collections Essentials Microsoft Office 2010: Intermediate Excel (No Assessments)

A PivotTable is one of the most powerful and intimidating features in Excel. Discover how to get the most out of a PivotTable or PivotChart to help you summarize and extract information from your data.

Asset ID	ds_msex2010_12_enus
Course Type	Video Course
Course Category	Essentials

Objectives
Excel 2010: PivotTables & PivotCharts Creating a PivotTable Editing your PivotTable Formatting your PivotTable Comparing values in a PivotTable Copying & reusing your PivotTable Inserting a calculation in your PivotTable Sorting data in your PivotTable Filtering your PivotTable data Grouping data in your PivotTable Inserting a slicer Customizing a slicer Inserting a PivotChart Modifying your PivotChart Analyzing your database tables in a PivotChart

Objectives

Excel 2010: PivotTables & PivotCharts

Creating a PivotTable
Editing your PivotTable
Formatting your PivotTable
Comparing values in a PivotTable
Copying & reusing your PivotTable
Inserting a calculation in your PivotTable
Sorting data in your PivotTable
Filtering your PivotTable data
Grouping data in your PivotTable
Inserting a slicer
Customizing a slicer
Inserting a PivotChart
Modifying your PivotChart
Analyzing your database tables in a PivotChart