I'm always looking to improve my Excel skills, and this book intrigued me because of the way it is organized.
The Hawleys have done a good job providing insights into common Excel tasks, especially list management and creative use of graphs. They wring some clever results from infrequently used Excel functions, such as OFFSET, and from conditional formatting. As other readers have pointed out in these reviews, the hack on dynamic ranges (hack 42, for example) may justify the price of the book.
This definitely isn't for the novice, though. The authors don't do much hand-holding, and if all you do is copy in their code and use it, you'll be missing out on the message: stretch, massage and manipulate these techniques, and others hidden within Excel, to expand Excel's usefulness and your own capabilities. You definitely need to be comfortable with the VBA editor - they give you the code, but with no explanations or analyses.
Incidentally, there are really only 99 hacks. Hack #10 and hack #25 are the same. But it's still well worth the money.
Willyboy
|