Questing Vole Press
Excel 2007 Pivot Tables

Excel 2007 Pivot Tables
by Tim Hill

Download this book’s companion files.

Description

The jargon associated with Microsoft Excel’s pivot tables (“n-dimensional cross tabulations”) makes them look complex, but they’re really no more than an easy way to build concise, flexible summaries of long lists of raw values. If you’re working with hundreds (or hundreds of thousands) of rows, then pivot tables are the best way to look at the same information in different ways, summarize data on the fly, and spot trends and relationships. This handy guide teaches you how to use Excel’s most powerful feature to crunch large amounts of data, without having to write new formulas, copy and paste cells, or reorganize rows and columns. You can download the sample workbook to follow along with the author’s examples.

Contents

1. Pivot Table Basics
2. Nesting Fields
3. Grouping Items
4. Calculations and Custom Formulas
5. Filtering Data
6. Charting Pivot Tables
7. Tricks with Pivot Tables

Excerpt

Amazon preview.

Download

orders07.zip (sample workbook).

Prices and formats

Paperback
   Amazon paperback (US, UK, FR, DE, ES, IT)

Ebook
   Amazon Kindle (US, CA, UK, AU, FR, DE, NL, ES, IT, JP, BR, IN, MX)
   Apple iBooks (US, CA, MX, AU, NZ, UK, IE, DE, IT, SE, NL, DK, JP)
   Barnes & Noble Nook