Excel is by far the most widely used spreadsheet program with an installed base of hundreds of millions. PivotTables and the related pivot charts are a powerful tool within Excel for analyzing, summarizing, and organizing data to reveal meanings that would not otherwise be visible. The use of these tools is not simple or intuitive, however, and the vast majority of Excel users have never tapped their power. This book addresses this need by providing complete coverage of Excel PivotTables and pivot charts starting with the simplest and most basic uses and working up to complex and sophisticated scenarios. The book combines both the reference and tutorial approaches. There will be sidebars for material that is related to but does not fit in the chapter. Many chapters include a case study called a Walkthrough. These will be available to the reader for experimentation through downloads online. The book includes the following chapters: Chapter 1 The What and Why of PivotTables and Charts Chapter 2 Data Sources for PivotTables Chapter 3 Using Excel's Special PivotTable Tools Chapter 4 Working With PivotTable Components Chapter 5 More About PivotTable Components Chapter 6 Understanding and Using Pivot Charts Chapter 7 Using PivotTables with Multi-dimensional Data Chapter 8 Getting Hard Data From a PivotTable Chapter 9 Programmatic Control of PivotTables Appendix PivotTable Differences between Excel 2000, 2002, and 2003.