by Debra Dalgleish
Publication Date: December 10, 2007
Excel
2007 PivotTables Recipes: A Problem-Solution Approach 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.
Chapter List
- Creating a Pivot Table
- Sorting and Filtering Pivot Table Data
- Calculations in a Pivot Table
- Formatting a Pivot Table
- Grouping and Totaling Pivot Table Data
- Modifying a Pivot Table
- Updating a Pivot Table
- Pivot Table Security, Limits and Performance
- Printing and Extracting Pivot Table Data
- Pivot Charts
- Programming a Pivot Table
Download the Source Code
- Go to the Source Code Download page:
http://www.apress.com/book/downloadfile/3780
and right-click on the Download Now link.
- Click on Save Link As, then select a folder in which to
save the source code file.
