Excel Pivot Tables And Charts

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. · Understanding PivotTables and Charts · Understanding Data Sources for PivotTables · Using PivotTable Tools and Formatting · Working with PivotTable Components · More about PivotTable Components · Understanding and Using PivotCharts · Using PivotTables with Multidimensional Data · Getting Hard Data from a PivotTable · PivotTable Alternatives · Programming PivotTables with VBA