Learn Excel 2007 through Excel 2010 From MrExcel: Master Pivot Tables, Subtotals, Charts, VLOOKUP, IF, Data Analysis and Much More - 512 Excel Mysteries Solved

by Bill Jelen

Updating the previous edition's tips to make them compatible with Excel 2010, and featuring tips that are only available in Excel 2010, this new edition of Mr. Excel's popular software guide even incorporates suggestions sent in by readers. Each featured topic has a problem statement and description, followed by a broad strategy for solving the problem. Mr. Excel then walks readers through the specific steps to solve the issue. Alternate strategies are also provided, along with common “gotchas” that trip users up, leaving readers with not only answers to their specific dilemmas but also new and quicker ways to use formulas and spreadsheets.

827 pages, Paperback

First published January 1, 2011

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

[Claire Binkley · Rating 5 out of 5]

This massive compilation of pro-tips helped me figure out how on Earth to leverage Microsoft Excel to exceed expectations in mastering computational mysteries. I'd been telling people around me a couple quick cheats I picked up from here you'll have to open this book up for yourself to understand what exactly is going on.

I had to ask my friend who worked more closely with the specifics it enumerates you may master in the title what exactly it meant for clarification, but as far as I can tell, you might not need Excel 2011+ for all that I do. (I have Excel 2008 for Macintosh.)

I am pleased with all this book provided me. As it is an inter-library loan, it really must go back by next Wednesday though. Goodbye, I must say to it.