Excel Pivot Tables and Charts

Description

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.