Excel 2007 PivotTables and PivotCharts
- 3h 2m
- Peter G. Aitken
- John Wiley & Sons (US)
- 2007
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
About the Author
Peter Aitken has been writing about computers and programming for over 15 years. He has more than 45 books to his credit with over 1.5 million copies in print, as well as hundreds of magazine and trade publication articles. His areas of special interest include Microsoft Office programs, digital imaging, and Visual Basic programming. Aitken is the proprietor of PGA Consulting, providing custom application development and technical writing services to business, academia, and government since 1994. For 18 years, Aitken was a member of the faculty at Duke University Medical Center. He left Duke in 2000 to devote full time to his writing and consulting.
In this Book
-
Excel 2007 PivotTables and PivotCharts
-
Introduction
-
Understanding PivotTables and Charts
-
Understanding Data Sources for PivotTables
-
Using PivotTable Tools and Formatting
-
Working with PivotTable Components
-
More About PivotTable Components
-
Understanding and Using PivotCharts
-
Using PivotTables with Multidimensional Data
-
Getting Hard Data from a PivotTable
-
PivotTable Alternatives
-
Programming PivotTables with VBA
