Excel 2007 PivotTables and PivotCharts

Front Cover
John Wiley & Sons, Apr 16, 2007 - Computers - 312 pages
0 Reviews
Devoted entirely to PivotTables and PivotCharts, this book shows you how to take full advantage of these powerful tools, which enable you to pull meaningful information from masses of seemingly meaningless data. 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, how to create and manipulate PivotTables using VBA, and—most importantly—you’ll discover what these tools can do for you.
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Understanding Data Sources for PivotTables
21
Using PivotTable Tools and Formatting
53
PivotTables and Charts Going Beyond the Basics
87
PivotTables and Charts Going Beyond the Basics
88
More About PivotTable Components
137
Understanding and Using PivotCharts
165
Getting the Most out of PivotTables and Charts
191
Getting the Most out of PivotTables and Charts
192
Getting Hard Data from a PivotTable
211
PivotTable Alternatives
225
Programming PivotTables with VBA
241
Troubleshooting PivotTables and PivotCharts
267
An Excel Chart Primer
273
Index
289
Copyright

Other editions - View all

Common terms and phrases

About the author (2007)

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.

Bibliographic information