Excel 2007 PivotTables and PivotCharts
Published on 10. April 2007
Book
Paperback/Softback
312 pages
978-0-470-10487-3 (ISBN)
Description
Take full advantage of Excel's interpretive power
Why do you need another book on Excel? Because this one is devoted to PivotTables and PivotCharts, Excel's powerful tools that enable you to pull meaningful information from masses of seemingly meaningless data--information you can actually use.
If you're new to PivotTables, this book is for you. Loaded with illustrations and real-world examples, it takes you step by step through creating a PivotTable; formatting, filtering, and grouping data; creating PivotCharts from those data; and more. You'll learn to work with multidimensional data and even how to create and manipulate PivotTables using VBA.
Most important, you'll discover what these tools can do for you. Are you ready?
Peter Aitken's Chart Toppers
* Topper # 1 Understanding and Creating PivotTables
*
Topper # 2 Using Excel 2007's PivotTable Tools
*
Topper # 3 Working with PivotCharts
*
Topper # 4 Using External and Multidimensional Data
*
Topper # 5 Programming PivotTables with VBA
Why do you need another book on Excel? Because this one is devoted to PivotTables and PivotCharts, Excel's powerful tools that enable you to pull meaningful information from masses of seemingly meaningless data--information you can actually use.
If you're new to PivotTables, this book is for you. Loaded with illustrations and real-world examples, it takes you step by step through creating a PivotTable; formatting, filtering, and grouping data; creating PivotCharts from those data; and more. You'll learn to work with multidimensional data and even how to create and manipulate PivotTables using VBA.
Most important, you'll discover what these tools can do for you. Are you ready?
Peter Aitken's Chart Toppers
* Topper # 1 Understanding and Creating PivotTables
*
Topper # 2 Using Excel 2007's PivotTable Tools
*
Topper # 3 Working with PivotCharts
*
Topper # 4 Using External and Multidimensional Data
*
Topper # 5 Programming PivotTables with VBA
More details
Series
Edition
1. Auflage
Language
English
Place of publication
Chichester
United Kingdom
Publishing group
John Wiley and Sons Ltd
Target group
Professional and scholarly
Illustrations
Illustrations
Dimensions
Height: 23.3 cm
Width: 18.7 cm
Thickness: 1.6 cm
Weight
435 gr
ISBN-13
978-0-470-10487-3 (9780470104873)
Schweitzer Classification
Other editions
Additional editions
Peter G. Aitken
Excel 2007 PivotTables and PivotCharts
E-Book
09/2007
Wiley
€23.99
Available for download
Person
Peter G. Aitken has written some 45 books and hundreds of articles on computer topics. His consulting firm, PGA Consulting, focuses on services involving Excel, including programming, custom templates, and troubleshooting. Peter is the coauthor of Excel 2007 Formulas and Functions For Dummies (Wiley).
John Walkenbach, Series Editor, has written more than 30 Excel books, including Excel 2007 VBA Programming For Dummies and Excel 2007 Bible, also from Wiley. Visit his popular Spreadsheet Page at www.j-walk.com/ss.
John Walkenbach, Series Editor, has written more than 30 Excel books, including Excel 2007 VBA Programming For Dummies and Excel 2007 Bible, also from Wiley. Visit his popular Spreadsheet Page at www.j-walk.com/ss.
Content
Introduction.
Part I: PivotTable Fundamentals.
Chapter 1: Understanding PivotTables and Charts.
Chapter 2: Understanding Data Sources for PivotTables.
Chapter 3: Using PivotTable Tools and Formatting.
Part II: PivotTables and Charts: Going Beyond the Basics.
Chapter 4: Working with PivotTable Components.
Chapter 5: More About PivotTable Components.
Chapter 6: Understanding and Using PivotCharts.
Part III: Getting the Most out of PivotTables and Charts.
Chapter 7: Using PivotTables with Multidimensional Data.
Chapter 8: Getting Hard Data from a PivotTable.
Chapter 9: PivotTable Alternatives.
Chapter 10: Programming PivotTables with VBA.
Appendix A: Troubleshooting PivotTables and PivotCharts.
Appendix B: Excel Version Differences for PivotTables.
Appendix C: An Excel Chart Primer.
Index.
Part I: PivotTable Fundamentals.
Chapter 1: Understanding PivotTables and Charts.
Chapter 2: Understanding Data Sources for PivotTables.
Chapter 3: Using PivotTable Tools and Formatting.
Part II: PivotTables and Charts: Going Beyond the Basics.
Chapter 4: Working with PivotTable Components.
Chapter 5: More About PivotTable Components.
Chapter 6: Understanding and Using PivotCharts.
Part III: Getting the Most out of PivotTables and Charts.
Chapter 7: Using PivotTables with Multidimensional Data.
Chapter 8: Getting Hard Data from a PivotTable.
Chapter 9: PivotTable Alternatives.
Chapter 10: Programming PivotTables with VBA.
Appendix A: Troubleshooting PivotTables and PivotCharts.
Appendix B: Excel Version Differences for PivotTables.
Appendix C: An Excel Chart Primer.
Index.