Excel 2010 book that's good on formulas and functions

[TreadOnTheCracks]

Things like find and replace, =average and so on.

I have Excel 2010 for dummies and I love the easy to use format, it just doesn't seem to cover the bits I need.

Any ideas?

TIA

I don't know about books (I get bored with them too quickly), most of my Excel learning has come from Google - sites like Ozgrid, PeltierTech, TechOnTheNet, ExcelFox, MrExcel, ExcelForum (have probably used this one the most for asking questions) have really helped.

I will check those out.

I have to do a competency test and need to learn quick!

Try something like Home and Learn, the tutorials take you through step by step.

Thank you I will take a look at those too.

MrExcel.com is by far the best Excel forum online. MrExcel himself, Bill Jelen has written several books on Excel which are excellently written. I'd recommend 'Excel 2010 in Depth' for your needs.

MrExcel.com is by far the best Excel forum online.

I'm going to have to stick up for ExcelForum then, because I contribute there

Thank you all, I will have a good look at those, on line hadn't even occurred to me so I'm glad I asked.

Top 100 Simplified Tips and Tricks by Denise Etheridge.

Mine is for 2007 though but they may have one for 2010. Two pages per tip with screen capture pictures and clear no waffle instructions.

I need to provide management reports and the above book gives me all the info I need. There are obviously books that covers each 'tip' in depth but I merely need to have a working knowledge of the main Excel functions.