Excel Pivot Table Step by Step Tutorial

Excel Pivot Table Tutorial

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

An Excel pivot table is a versatile reporting tool that makes it easy to extract information from a large table of data without the use of formulas.

A pivot table is 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 Table Overview
• Enter the Pivot Table Data
• Create the Pivot Table
• Adding Data to the Pivot Table
• Filtering the Pivot Table Data
• Change the Pivot Table Data