Excel PivotTables and PivotCharts

How to Use This Book v

1 Understanding Pivottables and Pivotcharts 2

Understanding Data Analysis 2

Introducing the PivotTable 4

Learn PivotTable Benefits 6

Learn When to Use PivotTables 8

Explore PivotTable Features 10

Introducing the PivotChart 12

2 Building a Pivottable 14

Prepare Your Worksheet Data 14

Create a Table for a PivotTable Report 16

Build a PivotTable from an Excel Table 18

Build a P...