iCellini Computer Training

San Diego’s Onsite Computer Training Company

home icon email icon

Introduction to Microsoft Excel 2007 - 2013 Pivot Tables

Duration: ½ day (3½—4 hours)
Prerequisite: Basic knowledge of Excel including knowing how to perform basic tasks such as creating worksheets, selecting ranges, and managing files.
Course Materials: Course manual with CD containing exercises
Prices: $175 for 1 student (one-on-one training)
$125 each for 2 to 3 students
$110 each for 4 to 6 students
$110 for the first 6 students, $90 for each additional student

A PivotTable is one of Excel's most popular and most powerful tools. PivotTables allow you to quickly and easily "pivot" data to view them in different ways. In this class, you will learn to create and use PivotTables. Once you create a PivotTable, you will learn to format it, filter it, and group data from its data source.

Understanding PivotTables and Charts

Understanding Data Sources for PivotTables

Using PivotTable Tools and Formatting

Working with PivotTable Components

More About PivotTable Components

Top of Page

Return to Microsoft Office list of classes