Course ID: EPT30907 - Pivot Tables 2007
Author: Patricia McCarthy
CPE Credits: 1
Pivot Tables have been around for a long time but I still think they 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 2007. You will see how to use this feature to analyze complex data. 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.
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
Sample page
Learning Objective
Learn how to manage data more effectively and transform it into information that can then be analyzed.
Delivery
Interactive
Level
Basic to Intermediate Excel user
Version
Excel 2007.This course is designed for users of Excel 2007 and is not intended for earlier versions of Excel. It assumes a familiarity with Excel 2007 and is intended for an intermediate Excel user. If you have an earlier Excel version please see the course entitled Pivot Tables (2003)
Prerequisites|
See Version
NASBA Category
Specialized Knowledge/Computer Science
Format
Course Manual in PDF format a well as accompanying exercise files.
Reviewed/Revised: October 2011 | 
