Skip to main content

Excel PivotTables and Charts

Excel PivotTables and Charts

Peter G. Aitken

ISBN: 978-0-471-77240-8

Jan 2006

288 pages

Select type: Paperback

Product not available for purchase


These are powerful, flexible, and complex tools, and most Excel users never tap their full potential. But you can, with Peter Aitken's step-by-step tutorials, understandable instructions, and detailed explanations. You'll learn to create and use PivotTables and charts from the simplest to the most complex.

This book will help you get more from Excel than ever before.

  • Chart Topper # 1 Creating a PivotTable Report
  • Chart Topper # 3 Using Special PivotTable(r) Tools
  • Chart Topper # 6 Understanding and Using PivotCharts
  • Chart Topper # 7 Working with Multidimensional Data
  • Chart Topper # 10 Programming PivotTables with VBA
Part I: Understanding PivotTables and Charts.

Part II: Understanding Data Sources 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.

Appendix A: Troubleshooting PivotTables and PivotCharts.

Appendix B: Excel Version Differences for PivotTables.

Appendix C: An Excel Chart Primer.


Downloadable Material
This content is stored in a ZIP format archive. If you are unable to open ZIP files, you can download a free version of Winzip.

Missing file added to

The SalesData_MDD.mdb was originally missing from the file. It has now been added to the file for download.