This 158-page book includes step-by-step examples and case studies that teach you many power tricks for analyzing data in Excel. These are tips honed by MrExcel during his ten-year run as a financial analyst charged with taking mainframe data and turning it into useful information quickly. Topics include

• Perfectly Sort with 1 Click every time
• Matching Lists of Data
• Data Consolidation
• Data Subtotals
• 2 in-depth chapters on Pivot Tables
• The excellent uses of SUMIF & SUMIF with more than one criteria
• Secret Formulas that can replace 10,000 formulas
• Using Indirect & Offset Formulas to create Dynamic Ranges
• Powerful UNKNOWN filtering techniques
• A Remedial Reading chapter to cover all the tricks you should know but might not
• Lookup functions
• Avoiding #VALUE! Errors
• Quickly Creating Top 10 reports
• The inside scoop on dealing with dates and date calculations.
• Converting Formulas to Values
• A quick reference guide to every Excel function
• Much, much more

One Review: Bill Jelen uses his combined experience and analytical ingenuity to de-mystify the arduous task of dealing with data. He uses real-life examples of real-life management requests, and then walks you through the maze of Excel tools and formulas that not only cuts valuable time out of the process, but teaches you in plain English how to overcome the most common analytical obstacles.

Another satisfied customer writes:
I just finished reading your book from cover to cover. This is a book that I will read, chew, and digest many times. Your real-life examples and anecdotes were excellent.

Your exposition on pivot tables transcends any other writing I have read about them. I have about three or four thick books on Excel. Yours pivot table writing has the most clarity and usefullness.

Your book is superb and stellar. It transcends all that other stuff on the shelf at the bookstores.

Click here for sample pages