Learn Excel from Mr. Excel: 277 Excel Mysteries Solved

Features

• Cover Type: Paperback with 836 pages
• Published by: Holy Macro! Books September 28, 2005
• Written in: English
• ISBN 10 Number: 1932802126
• ISBN 13 Number: 978-1932802122
• Book Dimensions: 10 x 7 x 2 inches
• Weighs: 3.5 pounds

Product Description
Containing 277 business case studies that illustrate nearly every aspect of Excel, this book presents real-life business problems and works them through to their solutions. In addition to exemplary solutions, each case analysis considers alternate approaches and gotchas, and includes a summary of the necessary commands and functions. Excel files that can be downloaded and worked through step-by-step are included for each case.


About The Author
Bill Jelen the principal of MrExcel.com and the author of Mr. Excel on Excel and Guerilla Data Analysis Using Microsoft Excel. He lives in Uniontown, Ohio.


Reader Reviews
This is one of those books that don't really contain anything new. What they do instead is present things in a way that as you read it you tend to say 'Of course, that's the way I can do that.' For instance, suppose you want to sort a spreadsheet on only the first three digits of an account number. You turn to page 147. It says, 'Create a new column. Use the LEFT function to populate that column. Sort on the new column.' It actually show you more instruction on how to do this, but that's the idea. 'Of course, you say, how obvious.' Then why didn't you think of it first? To make it easier to find what you're looking for, the book is broken into four sections: The Excel Environment, Calculating with Excel, Wrangling Data, Making Things Look Good. Each section then has a bunch of these 'hints & tips' I guess I'd call them. Alternatively there's a fairly complete index that is organizated alphabetically rather than functionally. I rank this an an excellent intermediate level book. If you don't know what a spreadsheet does, you need a lower level book. If you want to learn about Macros and VBA, you want a higher level. But regardless of your level, you'll find at least a few 'Of course's.' Comment | | (Report this)