What do you think?
Rate this book
Excel 2010 Pivot Tables (Tech 102) by Hill, Tim (2011) Paperback
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.+ Create pivot tables from spreadsheet or database tables.+ Rearrange pivot tables by dragging, swapping, and nesting fields.+ Customize pivot tables with styles, layouts, totals, and subtotals.+ Combine numbers, dates, times, or text values into custom groups.+ Calculate common statistics or create custom formulas.+ Filter data that you don't want to see.+ Create and customize pivot charts.+ Fully indexed and cross-referenced.
Paperback
First published September 1, 2011
4 people are currently reading
6 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 2 of 2 reviews
March 17, 2015
3.5 stars rounded up to 4.
Slim volume giving a crash course on Pivot Tables in Excel.
Easy to follow for the most part, although prior knowledge and experience of Excel is assumed. Not everything is detailed exactly step-by-step but if you know Excel you can figure it out - although I ended up totally lost for part of the last section.
The example spreadsheet (downloaded for free from a url given in the book) was about food orders and therefore was rather distracting (I kept thinking "that sounds nice" and Googling the different foodstuffs to see what they were/if they really existed), but that's just me!
I do feel more confident using Pivot Tables now and feel I have enough background knowledge now to work out myself what I want/need to do to get the most out of my own spreadsheets.
Slim volume giving a crash course on Pivot Tables in Excel.
Easy to follow for the most part, although prior knowledge and experience of Excel is assumed. Not everything is detailed exactly step-by-step but if you know Excel you can figure it out - although I ended up totally lost for part of the last section.
The example spreadsheet (downloaded for free from a url given in the book) was about food orders and therefore was rather distracting (I kept thinking "that sounds nice" and Googling the different foodstuffs to see what they were/if they really existed), but that's just me!
I do feel more confident using Pivot Tables now and feel I have enough background knowledge now to work out myself what I want/need to do to get the most out of my own spreadsheets.
July 5, 2012
A concise guide, very helpful and nicely done. Includes a sample workbook for download (http://www.questingvolepress.com/).
Displaying 1 - 2 of 2 reviews