DescriptionThese 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 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.
Missing file added to Download.zip
The SalesData_MDD.mdb was originally missing from the Download.zip file. It has now been added to the file for download.