Excel PivotTables and Charts
1st Edition
Published on 11. January 2006
Book
Paperback/Softback
288 pages
978-0-471-77240-8 (ISBN)
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
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
More details
Edition
1., Auflage
Language
English
Place of publication
New York
United States
Publishing group
John Wiley and Sons Ltd
Target group
Professional and scholarly
Illustrations
Illustrations
Dimensions
Height: 23.4 cm
Width: 18.8 cm
Thickness: 1.6 cm
Weight
438 gr
ISBN-13
978-0-471-77240-8 (9780471772408)
Schweitzer Classification
Person
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.
Visit his popular Spreadsheet Page at www.j-walk.com/ss.
Content
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.
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.