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