Excel 2010-Analyzing Data with Pivot Tables

About the Class:

This workshop lasts 50 minutes.

Pivot tables are very useful in summarizing and analyzing large datasets. This 50-minute workshop will show you how to quickly create and modify a pivot table and will also introduce the new slicer tool introduced in Excel 2010, which provides buttons for quick filtering.

This content is also covered in the 3-hour workshop titled Excel 2010 – Analyzing Data with Pivot Tables.

What You’ll Learn:

  • Create pivot tables
  • Add filters to view data
  • Group and sort within a pivot table
  • Use the pivot table slicer

What You Need to Know:

  • Enter text or numeric data
  • Create simple formulas and functions
  • Create named ranges

If you don’t have those skills, consider first taking the workshop:

  • Excel 2010 – The Basics

Resources

Excel 2010(PC) Excel 2011(Mac)
 Microsoft Office: Create or Delete a PivotTable or PivotChart Report Microsoft Office: Analyze Data with a PivotTable
 Microsoft Office: Overview of PivotTable and PivotChart Reports Microsoft Office: About PivotTables
 Microsoft Office: Quick Start: Create a PivotTable Report Microsoft Office: Create a PivotTable