Pivot Table Data Crunching for Microsoft Office Excel 2007

by Bill Jelen, Michael Alexander

Furnishing a variety of practical, real-world scenarios to demonstrate the applications of Pivot Tables, a comprehensive review of their function in Excel 2007 offers a series of proven, innovative Pivot Table recipes that can be applied to a variety of business situations and includes helpful tips on how to avoid potential problems of everyday number crunching. Original. (Intermediate)

Genres: Reference

338 pages, Paperback

First published January 5, 2006

About the author

Bill Jelen is the host of MrExcel.com and the author of 50 books about Microsoft Excel including Pivot Table Data Crunching, Excel Gurus Gone Wild, and Guerrilla Data Analysis Using Microsoft Excel. He writes monthly Excel columns for Strategic Finance magazine.
He has been awarded the MVP in Excel for 10 years by Microsoft.
He has made over 60 guest appearances on TV’s Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show.
His has produced over 2000 episodes of his daily video podcast Learn Excel from MrExcel.
Before founding MrExcel.com in 1998, Jelen spent twelve years “in the trenches”, as a financial
analyst for the accounting, finance, marketing, and operations departments of a publicly held company. Since then, his company automates Excel reports for hundreds of clients around the world. The website answers over 30,000 questions a year – for free – for
readers all over the world.

Reviews

[Andrew Saul · Rating 5 out of 5]

I really didn't agree with the introduction of this book when I first read it. This guy was banging on about how great pivot tables were and I just didn't buy it given I had not thought much of them as a feature in the little experience I had had with them. By halfway through the book I had spun 180 degrees and was a convert to the pivot table cause.

In fact now I think maybe he played down a little how great pivot tables were in the introduction.