Excel Pivot Tables Step by Step Tutorial

By Ted French, About.com Guide

Excel Pivot Tables Tutorial

Related tutorial: Excel 2003 Pivot Table Tutorial (video).

Pivot tables in Excel are a versatile reporting tool that makes it easy to extract information from large tables of data without the use of formulas.

Pivot tables are extremely user friendly in that by moving, or pivoting, fields of data from one location to another using drag and drop we can look at the same data in a number of different ways.

This tutorial covers creating and using a pivot table to extract different information from one data sample.

The steps in this tutorial are:

1. Enter the Pivot Table Data
   
   
2. Create the Pivot Table
   
   
3. Adding Data to the Pivot Table
   
   
4. Filtering the Pivot Table Data
   
   
5. Change the Pivot Table Data
   
   

• Pivot Tables Overview
• Enter the Pivot Table Data
• Creating the Pivot Table
• Adding Data to the Pivot Table
• Filtering the Pivot Table Data
• Changing the Pivot Table Data