Pivot Table Data Crunching: Microsoft

2. Creating a Basic Pivot Table

In This Chapter

Preparing Data for Pivot Table Reporting 21

Case Study: Cleaning Up Data for Pivot Table Analysis 25

Creating a Basic Pivot Table 26

Introducing Slicers 35

Case Study: Analyzing Activity by Market 38

Keeping Up with Changes in the Data Source 39

Sharing the Pivot Cache 40

Saving Time with New Pivot Table Tools 42

Preparing Data for Pivot Table Reporting

When you have a family portrait taken, the photographer takes time to make sure that the lighting is right, the poses are natural, and everyone smiles his or her best smile. This preparation ensures that the resulting photo is effective in its purpose

When you create a pivot table report, you are the photographer taking a snapshot of your data. ...