Learning Excel with a book

Question

I work at a company where all the TMs and assistant TMs use Excel for number management, we're not able to use anything else because the computers are locked down (for good reason though I'll be asking IT anyway). The company also has a buy-a-book scheme, can anybody recommend a good book for using Excel and Macros in it?

Answer 1

Professional Excel Development is an excellent book which goes through creating user interfaces with Excel, and writing good code. There's a lot of stuff about best practices, and general tips.

I've just noticed this might be a rewrite of the above book.

Another great book with general techniques for writing macros (by the same authors) is Excel 2007 VBA (they also have a similar book Excel 2000, and other Excel version, although I haven't read the other versions).