Pivot
Table
Data
Crunching
Bill Jelen (Mr.
Excel)
and
Mike
Alexander
(DataPig)
bring
you
the
most
comprehensive
book
on
Pivot
Tables
to
date.
Covering
everything
from
preparing
your
data
for
pivot
table
reporting
to
creating
pivot
tables
with
VBA,
this
book
will
make
you
the
office
expert
on
Excel
pivot
tables.
Easy
to
follow
instructions
and
real-world
examples
ensure
that
you
don't
miss
a
beat
in
this
"soup
to
nuts"
approach
to
everything
you
will
ever
need
to
know
about
pivot
tables.
-
Chapter 1: Pivot Table Fundamentals and Ground Rules
-
Chapter 2: Creating your First Pivot Table
-
Chapter 3: Customizing your Pivot Table Fields
-
Chapter 4: Formatting your Pivot Table
-
Chapter 5: Controlling the Way You View Your Pivot Data
-
Chapter 6: Performing Calculations within your Pivot Tables
-
Chapter 7: Creating and Using Pivot Charts
-
Chapter 8: Using Disparate Data Sources for your Pivot Table
-
Chapter 9: Using External Data Sources for your Pivot Table
-
Chapter 10: Leveraging the Power of OLAP Cubes
-
Chapter 11: Enhancing Pivot Reports with Macros
-
Chapter 12: Using VBA to Create Pivot Tables
-
Appendix A: Common Questions and Issues with Pivot Tables
