Excel Pivot Tables & Charts – Peter G.Aitken

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

Table of Contents

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.

Index.

 

Author Information

Peter Aitken has been writing about computers and software for 20 years and has some 45 books as well as hundreds of magazine and web articles to his credit. He specializes in Excel, Visual Basic programming, and XML, but he has also ventured into such varied topics as personal finance, digital imaging, and camera phones. Peter also does technical writing in the medical and pharmaceutical fields and is a part-time faculty member at Duke University Medical Center.
Visit his popular Spreadsheet Page at www.j-walk.com/ss.