Pivot Table Data Crunching for Microsoft Office Excel 2007
Read an excerpt:
Chapter 4: Controlling the Way You View Your Pivot Data
Reprinted with permission from Que Publishing. Copyright © Pearson Education, Que Publishing. Written permission from the publisher is required for any use of this material.
|
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: - Administering Windows Vista Security: The Big Surprises; Mark Minasi, et al, $24.50, 39% Off!
- Microsoft Office 2007 Library: Excel 2007, Access 2007, PowerPoint 2007, Word 2007 Bibles; John Walkenbach, et al, $86.95, 40% Off!
- Microsoft Office Excel 2007 Inside Out; Mark Dodge, et al, $26.95, 40% Off!
- Microsoft Office Outlook 2007 Inside Out; Jim Boyce, et al, $26.95, 40% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
This book consolidates all the best functionality of pivot
tables into one guide
that provides you with a meaningful tutorial, offering
practical solutions to
day-to-day problems.
Within just the first 2 chapters, you will be creating
basic pivot tables, increasing
productivity, and producing reports in minutes instead
of hours.
Within the first 6 chapters, you will learn how to use pivot tables to quickly
highlight your top 10 customers or bottom 5 products in profitability; quickly
create analysis comparing sales this period to last period by product or region
or both; easily summarize daily transactional data by month or quarter or year
in a few mouse clicks -- all without knowing any formulas!
By the end of the book, you will truly be a pivot table
guru, automating pivot
tables using VBA, creating pivot tables with external
data in OLAP cubes, and
even creating dynamic reporting systems so that your managers
can answer their
own queries with a few mouse clicks.
• Take advantage of the numerous pivot table recipes
• Create powerful summary reports in seconds
• Build ad-hoc query tools with ease
• Enhance your Executive Reporting
• Filter reports to top 10 customers or products
• Add dynamic charts to reports
• Quickly summarize daily data by month, quarter, or year
Table of Contents
Introduction . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . 1
1 Pivot Table Fundamentals . . . . . . . . . . . . . . .
. . . . . . . . . . . . .11
2
Creating a Basic Pivot Table . . . . . . . . . . . . . . . . . . . . . .
. . . .21
3
Customizing a Pivot Table . . . . . . . . . . . . . . . . . . . . . . .
. . . . .45
4
Controlling the Way You View Your Pivot Data . . . . . . . . . . . .83
5
Performing Calculations Within Your Pivot Tables . . . . . . . . 117
6
Using Pivot Charts and Other Visualizations . . . . . . . . . . . . .141
7
Analyzing Disparate Data Sources with Pivot Tables . . . . . . 167
8
Sharing Pivot Tables with Others . . . . . . . . . . . . . . . . . . . .
. .189
9
Working with and Analyzing OLAP Data . . . . . . . . . . . . . . . . 201
10
Enhancing Your Pivot Table Reports with Macros . . . . . . . . .215
11
Using VBA to Create Pivot Tables . . . . . . . . . . . . . . . . . . . .
. 231
12
Common Pivot Table Issues and Questions . . . . . . . . . . . . . .291
A Finding Pivot Table Commands on the Ribbon . . . . . .
. . . . . .315
About the Authors
Bill Jelen is an accomplished Excel author and the principal behind the leading
Excel website, MrExcel.com. As an Excel consultant, he has written Excel VBA
solutions for over 300 clients around the English-speaking world. His website
hosts over 10 million page views annually. Prior to founding MrExcel.com, Jelen
spent twelve years in the trenches, - working as a financial analyst for finance,
marketing, accounting and operations departments of a $500 million public company.
Michael Alexander is currently Managing Editor at Datamation andwrites and
publishes the SmartSecurity electronic newsletter. He is alsoThe Boston Globe's
"Home Tech" columnist and was formerly theEditor-in-Chief of InfoSecurity
News and Senior Editor for AdvancedTechnology at Computerworld.
|
