FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week

The Excel Addict - Help with Excel 2013, 2010, 2007, 2003
December 10, 2015
Greetings from The Excel Addict
Hi fellow Excel Addict,

Francis Hayes (TheExcelAddict.com)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)
Email: 
fhayes[AT]TheExcelAddict.com





If you missed my last newsletter, you can click here to view it online.

The Excel Addict Quote of the Week
"There are two primary choices in life;
to accept conditions as they exist,
or to accept the responsibility of changing them."
-- Denis Waitly --


If you have a favourite quote, send it to me and I may post it in my newsletter.


Today's Microsoft Excel Tip

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.

Function AutoComplete
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.

Shortcut To Enter Function Name in Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

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 f
or additional help on the function.

Keyboard Shortcut To Get Help With Functions in Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

Move it
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."

Move Function Help Tooltip Out Of The Way in Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365
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.


FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week

Thanks for supporting this newsletter and website


Subscription Information: Spreadsheet Tips From An Excel Addict is available only to subscribers of my newsletter. If this newsletter was forwarded to you and you would like to get your own copy, please visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com

 If you would like to share this newsletter with others...
1) Share a link to this page
2) Ask your friend/colleague to visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com
3)  Post a link to TheExcelAddict.com in a company newsletter or website.

Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
"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