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
Auflage
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Illustrationen
Maße
Höhe: 23.4 cm
Breite: 18.8 cm
Dicke: 1.6 cm
Gewicht
ISBN-13
978-0-471-77240-8 (9780471772408)
Schweitzer Klassifikation
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.
Foreword.
Preface.
Acknowledgements.
Author Bios.
Introduction.
1. Understanding PivotTables and Charts.
2. Understanding DataSources for PivotTables.
3. Using PivotTable Tools and Formatting.
4. Working with PivotTable Components.
5. More About PivotTable Components.
6. Understanding and Using Pivot Charts.
7. Using PivotTable with Multidimensional Data.
8. Getting Hard Data from a PivotTable.
9. PivotTable Alternatives.
10. Programming PivotTables with VBA.
Appendix A: PivotTable Differences for PivotTables.
Appendix B: Excel Version Differences for PivotTables.
Appendix C: An Excel Chart Primer.
Notes Pages.
Coupons.
License Agreements.
Installation Instructions.
