Advanced MS Excel Book

[Agent007]

I would consider myself a fairly advanced user of MS Excel (I built models in it all summer, and will be doing it full-time when I graduate), but I am looking to learn some more tips and tricks (i.e. keyboard shortcuts). As it is, I don't use the mouse at all, but I could definitely stand to learn some more of the shortcuts.

Can anyone recommend a book which I can read to continue to learn? Again, I'm looking for an Advanced level book.

Thanks.

 

[hollisdude]

google it

 

[schnarkle]

amazon.com and read the reviews/sample chapters

 

[Agent007]

Thanks, I found a few articles on google, but the books on amazon don't really seem to be quite right. Most of the ones i saw were just focues on explaining how to use excel, rather than how to use it more efficiently...

Surely soneone on HF has gone through this exercise before and knows of a specfic kickass book...if you do, let me know...

 

[politically correct horn]

Agent you should check out an add on program called fasttrack and they have a business add on as well. i think the company is called dealmaven.

 

[Agent007]

Funny you should mention that. The place where I worked this summer used DealMaven's software, so I've been through training on it all and enjoyed using it. Coincidentally, one of the guys who started (in charge of marketing) the company is actually a UT alum. (I think his name was Tom).

Regardless, the problem is that my new employer won't be using it, and so the DealMaven shortcuts with which I am familiar are exactly what I am trying to distance myself from....

 

[politically correct horn]

agent, the place I used to work at did not use it either so I just bought a copy for myself. After about a week, the CFO and comptroller had a copy as well. Excel by itself can not do this stuff unless you use VB to build in the functionality as another posted stated. For me, spending the $100 was well worth it and I ended up getting compensated for it.

 

[Agent007]

Well my future employer has about 20,000 people who all use Excel on a daily basis, so its not really do-able to turn the organization around, but I found a friend who has 8 pages of built-in Excel keyboard shortcuts which is exactly what I wanted.