Pivot Table Data Crunching

Table of Contents

Introduction

1 Pivot Table Fundamentals

What Is a Pivot Table?

Why Should You Use a Pivot Table?

When Should You Use a Pivot Table?

The Anatomy of a Pivot Table

Data Area

Row Area

Column Area

Page Area

Pivot Tables Behind the Scenes

Limitations of Pivot Table Reports

Next Steps

2 Creating a Basic Pivot Table

Preparing Your Data for Pivot Table Reporting

Ensure Your Data Is in a Tabular Layout

Use Unique Headings That Occupy Only a Single Row of Data

Avoid Storing Data in Section Headings

Avoid Repeating Groups as Columns

Eliminate Gaps and Blank Cells in Your Data Source

Apply Appropriate Type Formatting to Your Fields

Summary of Good Data Source Design

Cleaning Up Data for Pivot Table Analysis

Creating a Basic Pivot Table