I can’t tell you how much I wanted to like this book. I’ve admired O’Reilly’s technical books for years, and now that I’ve branched out into business applications, I was delighted to see that they had, too.<\/p>\n

When I finished business school last year, one of the classes I had to take was in financial modeling, and it had a heavy Excel emphasis. We did a little bit with Macros and VBA, but the most complex model we did was nothing compared to what this book aimed for. Finally, I was going to get a chance to really gun the program up into 6th gear. Clearly, this was a book that wouldn’t talk down to me.<\/p>\n

Sigh.<\/p>\n

First, even finding the spreadsheets online was a little bit of a task. The URL was only mentioned in the preface. A more prominent location would have saved me a lot of time. In fact, the data spreadsheets should be available without the code at all, just the data (in addition to the completed applications).\u00a0 Most people who want to learn are going to try to work through the application from the ground up.<\/p>\n

Secondly, having an editor do just that would have helped immensely.\u00a0 I started on the first application (analyzing call center call volume), and couldn’t figure out how the predicted values were arrived at.\u00a0 They weren’t spreadsheet functions, just numbers next to the raw data.\u00a0 This pretty much stymied me right there, although I did go on to complete the application, skipping that part.\u00a0 Still, in a book as dense as this one is, where every piece represents a potentially useful application, leaving that much work as an exercise to the reader is unnecessary and confusing.<\/p>\n

A minor detail: when\u00a0using a workbook like this, I find it’s much harder to do so if\u00a0a screenshot isn’t on the same page as its description.\u00a0 Flipping back and forth, again, in a book where every sentence matters, really slows down the process.<\/p>\n

Finally, perhaps because of the above-mentioned problems, I found it hard to generalize from the applications presented.\u00a0 They seemed just a little too specific<\/i> to the data.<\/p>\n

I don’t want to be too hard on O’Reilly.\u00a0 It’s best-known for programming tutorials, and that’s essentially what this book is trying to be, so\u00a0the company clearly has the in-house talent to make this work.\u00a0 The book frankly has a lot of potential.\u00a0 About twice the exposition and forcing an editor to work through all the examples would make it incredibly useful.\u00a0 My guess is that it’s about 80% of the way there.\u00a0 The problem is that the 20% that’s missing makes all the difference.
\n