iCellini Computer Training

San Diego’s Onsite Computer Training Company

home icon email icon

Microsoft Excel 2007 - 2013 PivotTables and PivotCharts

Duration: 1 day (about 6 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: $225 for 1 student (one-on-one training)
$160 each for 2 to 3 students
$130 each for 4 to 6 students
$130 for the first 6 students, $100 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. You will also extract hard data from a PivotTable and apply functions for further analysis. You will also create PivotCharts from your PivotTables.

Understanding PivotTables and Charts

Understanding Data Sources for PivotTables

Using PivotTable Tools and Formatting

Working with PivotTable Components

More About PivotTable Components

Understanding and Using PivotCharts

Getting Hard Data from a PivotTable

PivotTable Alternatives

Top of Page

Return to Microsoft Office list of classes