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.
Part I Understanding PivotTables and charts
Part II Understanding data source for PivotTables
Part III Using PivotTable tools and formatting
Part IV Working with PivotTable components
Part V More about PivotTable components
Part VI Understanding and using PivotCharts
Part VII Using PivotTables with multidimensional data
Part VIII Getting hard data from a PivotTable
Part IX PivotTable alternatives
Part X Programming PivotTables with VBA