Excel 2010 Bible

xxxi

Contents

Adding and editing records in external database tables ............................................693

Formatting data .......................................................................................................693

Learning More about Query ..............................................................................................693

Chapter 34: Introducing Pivot Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . 695

About Pivot Tables ............................................................................................................695

A pivot table example ..............................................................................................696

Data appropriate for a pivot table ............................................................................698

Creating a Pivot Table .......................................................................................................701

Specifying the data ..................................................................................................701

Specifying the location for the pivot table ................................................................701

Laying out the pivot table ........................................................................................702

Formatting the pivot table .......................................................................................703

Modifying the pivot table ........................................................................................706

More Pivot Table Examples ...............................................................................................708

Question 1 ..............................................................................................................708

Question 2 ..............................................................................................................709

Question 3 ..............................................................................................................710

Question 4 ..............................................................................................................710

Question 5 ..............................................................................................................711

Question 6 ..............................................................................................................712

Question 7 ..............................................................................................................713

Learning More ..................................................................................................................714

Chapter 35: Analyzing Data with Pivot Tables . . . . . . . . . . . . . . . . . . . . . 715

Working with Non-Numeric Data .....................................................................................715

Grouping Pivot Table Items ..............................................................................................717

A manual grouping example....................................................................................717

Automatic grouping examples .................................................................................719

Grouping by date ..........................................................................................719

Grouping by time ..........................................................................................722

Creating a Frequency Distribution ....................................................................................722

Creating a Calculated Field or Calculated Item .................................................................724

Creating a calculated field .......................................................................................726

Inserting a calculated item .......................................................................................728

Filtering Pivot Tables with Slicers .....................................................................................731

Referencing Cells within a Pivot Table ..............................................................................733

Creating Pivot Charts ........................................................................................................735

A pivot chart example .............................................................................................736

More about pivot charts ..........................................................................................738

Another Pivot Table Example ............................................................................................739

Producing a Report with a Pivot Table ..............................................................................742

02_474877-ftoc.indd xxxi02_474877-ftoc.indd xxxi 3/29/10 11:34 PM3/29/10 11:34 PM