I am SO aggravated! Trying to use the more advanced functions and formulas in Excel is completely maddening.
Can anyone recommend a downloadable book or manual, even if it costs, that doesn’t assume I’m already ultra cozy with all the possibilities of Excel, but also isn’t designed for someone with no clue? I need DETAILED guidance on using functions and building formulas.
Thanks!
There is a tool in excel that is very helpful. Right above the worksheet there is a little fx button. If you click on that it will ask you for a description of what you want to do. Once you give a little information, it will suggest functions to help you and give you a description of what they do. If you double click on one of the functions, it will give you very good information and help you use the function. It is much more helpful than any manual I have heard of. If the function doesn’t seem to be working quite right, click on the “help on this function link”. Sometimes data has to be sorted a certain way or such.
I hope this is helpful.
Any particular formulas bugging you at moment? I’ve had good help from this board in the past.
I have also found the Office Watch Excel stuff useful, though it’s unconnected articles rather than a coherent manual.
Good luck.
Yeah, vlookup - there’s a few important details missing from the online help files and formula builders.
What are you trying to do with vlookup?
See my other excel thread…