Pivot Table Data Crunching

by Bill Jelen, Michael Alexander

Provides instructions on using and creating pivot tables with Microsoft Excel.

274 pages, Paperback

First published June 20, 2001

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

[Dan · Rating 5 out of 5]

A friend of mine who is an Excel consultant said, "The answer is a pivot table; now what is the question?" I was acquainted with the primitive capability of pivot tables in early versions of Excel, but I did not realize how powerful they have become. I am now finding many uses for them. Jelen has written an excellent learning tool and resource book. He has most of the examples in the book available in completed Excel workbooks that can be downloaded from a web site for free. The reader can concentrate on learning the principles without having to spend a lot of time entering data. If you analyze data and have to present it in table of chart form, you owe it to yourself to learn the power of pivot tables. Jelen's book is a great way to start. If you know a bit about pivot tables and want to learn more, Jelen's book can help there too.

[Jon · Rating 4 out of 5]

Great introductory book for pivot tables/charts for beginners. Also, some gems for intermediate users.

The book was put together very well and was easy to read.

My only disappointment was that it wasn't as advanced as I was hoping.

[Bill Jelen]

Pivot tables are Excel's most powerful feature. This book shows you how to create a pivot table to summarize 50,000 rows of Excel data.

[Tatiana · Rating 5 out of 5]

Very good book for everyone who is starting with pivot tables. Easy, comprehensible and with hands-on approach.