Overview

Excel
2007 PivotTables Recipes: A Problem-Solution Approach by Debra
Dalgleish, assumes that you know the basics of Excel and pivot
tables, and provides troubleshooting tips and techniques, and programming
examples.

This book is for anyone who uses pivot tables, and who only reads
the manual when all else fails. It's designed to help you understand
the advanced features and options that are available, as you need
them. Experiment with pivot tables, and if you get stuck, search for
the problem in this book. With luck, you'll find a solution, a workaround,
or, occasionally, confirmation that pivot tables can't do what you
want them to do.

Order the Book on Amazon.com

Chapter List

Creating a Pivot Table: Issues you should consider when
planning a pivot table and preparing the source data. Using data
from multiple worksheets. Creating an Excel Table from the source
data and understanding the new PivotTable Field List.

Calculations in a Pivot Table: Using the summary functions
and custom calculations, creating calculated items and calculated
fields to expand the built-in capabilities, modifying formulas,
listing all formulas, and adjusting the solve order.

Modifying a Pivot Table: Changing the PivotTable layout,
showing all items for a field, clearing old items from the field
drop-downs, hiding items with no data, and allowing drag-and-drop
in the worksheet layout.

Updating a Pivot Table: Refreshing the PivotTable, refreshing
automatically, reconnecting to the source data, locating and changing
the source data, and deferring a layout update.

Printing and Extracting Data: Printing headings on every
page, adjusting the print area, and starting each item on a new
page. Using the Show Details feature to extract underlying records,
using the GetPivotData worksheet function to extract PivotTable
data, turning off the GetPivotData feature, and using cell references
in GetPivotData formulas.

Pivot Charts: Planning and creating a pivot chart, creating
normal charts from PivotTable data, creating multiple series for
years, creating a combination chart, and locating the source PivotTable.