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