MBA's Guide to Microsoft Excel 2002

Rating:
Summary: Disappointed in what is missing.
Review: I was looking for a book that would explain linear programming (optimization modeling) and pivot tables - the book did an excellent job for those two tasks, so I bought it. My mistake was in assuming that the MBA moniker meant that it would cover most of the features for which MBA's use Excel. I was first disappointed when VLOOKUP (vertical lookup) and HLOOKUP (horizontal lookup) were not covered. Next, I was surprised that macros are not covered. The last straw was when I read that the only way to fix a circular reference in Excel is to remove it - FALSE. I'm no Excel guru but even I can use help and find out how to step through iterations manually to solve when a circular reference is necessary (e.g. pay out 10% of gross profits as long as net profits are greater than $1,000). Don't be fooled by the title.