by Gerald Knight

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.

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.


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).  Most people who want to learn are going to try to work through the application from the ground up.

Secondly, having an editor do just that would have helped immensely.  I started on the first application (analyzing call center call volume), and couldn’t figure out how the predicted values were arrived at.  They weren’t spreadsheet functions, just numbers next to the raw data.  This pretty much stymied me right there, although I did go on to complete the application, skipping that part.  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.

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

Finally, perhaps because of the above-mentioned problems, I found it hard to generalize from the applications presented.  They seemed just a little too specific to the data.

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