Pivot Table Data Crunching

by Bill Jelen

This is the eBook version of the printed book. Become a savvy Microsoft Excel user. Pivot tables are a great feature in Excel that help you organize and analyze data, but not many Excel users know how to use pivot tables. Pivot Table Data Crunching offers a comprehensive review of all the functionalities of Pivot Tables from author Bill Jelen , otherwise known as Mr. Excel from www.mrexcel.com, and Michael Alexander , a Microsoft Certified Application Developer. The authors' practical scenarios and real-world advice demonstrate the benefits of Pivot Tables and how to avoid the common pitfalls of every day data crunching. Each solution presented in the book can be accomplished with resources available in the Excel interface, making Pivot Table Data Crunching a beneficial resource for all levels of Excel users.

291 pages, Kindle Edition

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.