Hi fellow Excel Addict,
I do appreciate you joining me each week for these tips and I really do love getting emails from Excel users sharing their Excel experiences.
I think it's so awesome how people all around the world with such varied backgrounds and experiences can share so much in common.
Yes, Excel Addicts really are universal.
Take care and keep on Excelling,
Francis Hayes (The Excel Addict)
If you missed my last newsletter, you can click here to view it online.
If you have a favourite quote, send it to me and I may post it in my newsletter.
Working with Worksheet Functions Made Easier
Functions are precoded formulas that are built right into Excel, such as AVERAGE, SUM and VLOOKUP. They require only the values needed for the calculation and therefore save you the work of creating a more complex formula.
Excel has hundreds of functions available. If you know (or have an idea) which worksheet function you want to use, but you're not exactly sure how to use it, here are a couple of tricks that will make working with them easier.
You start a function by typing an equal sign (=). Then, when you type the first letter or two, a list of matching functions will be shown. [Optionally, at this point, you can select the desired function form the list with your mouse or the arrow keys]. As you continue typing the function name, the list will be narrowed down to one. When there is only one match displayed, rather than finish typing the remainder of the function name, you can press the Tab key on your keyboard and Excel will to AutoComplete the name and show you each of the arguments (i.e. required parts) of the function.
Formula Dialog and Help
Once you have typed the function name, you can press CTRL+A to bring up the Function Arguments dialog box which will help you complete the function and give you explanations for each argument.
You can also click the 'Help on this function' link at the bottom left corner of the Function Arguments dialog for additional help on the function.
As you are entering a function, the screentip tool often gets in the way and covers one or more cells that you either want to view or want to select for one of the arguments of the function. A little known trick is that you can actually move this screentip just by pointing to it and dragging it out of the way. Almost everytime I show this to someone, they inevitibly say "Wow! This has been annoying me forever."
I hope that these few tips will help make it easier for you to take full advantage of the hundreds of amazing functions that Excel provides.
|"Spreadsheets Tips From An
Excel Addict" is a weekly publication of TheExcelAddict.com.
Copyright Francis J. Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630