1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel Pivot Tables Step by Step Tutorial

By

1 of 6

Pivot Tables Overview
Excel Pivot Tables Tutorial

Excel Pivot Tables Tutorial

© Ted French

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

Related Video
Create Excel Pivot Tables

©2014 About.com. All rights reserved.