Course ID: EPT20507 - Excel Pivot Tables
Author: Patricia McCarthy

I think pivot tables are one of the hottest features in Excel if you are dealing with a lot of data.

Course Description:
This course covers the basics and more of pivot tables for Excel 2003. They allow you to analyze complex data and are powerful. A pivot table's greatest advantage is that you can easily change the way data is summarized. You get to tell Excel how you want to see the data that is within the spreadsheet by specifying what fields should display in a row or a column and how it should be summarized.  Turn the reams of data into something useful.  

Price: $8.00

  

This one hour course covers:

• Creating a pivot table
• Rearranging a pivot table
• Filtering Data in a pivot table
• Creating Calculations in a pivot table
• Grouping Dates in a pivot table
• Autoformatting a pivot table
• Creating a simple Pivot Chart

Download a Sample page

Learning Objective:
Learn how to manage data more effectively and transform it into information that can be analyzed and utilized.

Delivery: Interactive

Level: Basic to Intermediate Excel user

Version: Excel 2003

Prerequisite: Working knowledge of Excel 2003

NASBA Category: Computer Science

Format: Ebook is in PDF format. Excel exercise files are also included.

Reviewed/Updated: November 2011