Get 20-hours of Excel 2016 training here ► https://www.simonsezit.com/course-category/excel/

During this Microsoft Excel 2016 advanced training tutorial video, we will look at tools to help you find the functional functions that you need. We will also show you the use of the function argument dialog, as well as the formula autocomplete feature.

Check out some of our other training on YouTube:

Excel 2016 advanced training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hzyKexLt4YW-AaIUPeiCen

Excel 2016 beginner training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hFUdlWMkTLZL-Fr3oRGN35

VBA for Excel tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ

Project 2016 beginner training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3g_ABHdUU7RoGJJm-YFr4_Y

Visio 2013 for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jpAwkTGD6hGNxF8ML_FfsF

SharePoint 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jloGuvewOe0Iv1EE2POKge

Stay in touch:
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Facebook: https://www.facebook.com/SimonSezIT/

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)

Hello again and welcome back to our course on Excel 2016 Advanced.
In this section we’re going to continue looking at Functions in general and I want to look first at tools to help you find the function or functions that you need.

Now let’s take a particular example, let’s suppose that I’m working on this new worksheet here and I know that I need a standard deviation function. That’s a statistical function. Well if you look at the Formulas tab you will see the Function Library group there and some of the most commonly used categories of function. So you have Financial, Logical, Text, etcetera. Note also a category there of Recently Used.

And if you do tend to use a fairly restricted set of functions that’s a really good feature because it makes it more likely that the function you want you’ve used recently and you can merely locate it here.
If you look at the other end of the group there is a More Functions button and this gives you access to the other categories, one of which is Statistical. And the fly out list there lists all of the available statistical functions. Now note that with each one if I just hover over it I’ll get a screen tip with a description for that function. And underneath the screen tip there is a link to Help. Now unfortunately this link to Help is not quite as good as it used to be because it basically only takes you to a general Excel Functions Help area. And what you would need to do for the particular function that you were looking at just now is to type in the name of the function and then you would indeed get the help on that function. But it isn’t contextual as I believe it used to be.

So what you might do knowing that you need a statistical function is to scroll down there and try and find the standard deviation or function that you need. But if you didn’t find it and that will often be because you don’t know its name and you don’t particularly want to look at the screen tip for every one of those functions there is another option and that is to click on Insert Function and that brings up the Insert Function dialog.

Now, note that the Insert Function dialog here has this particular field which is the category field preselected at Statistical because I was looking at the statistical functions when I invoked this. Let me just Cancel it again.

There are a couple of other ways of invoking this dialog. One of them is that it’s the left most command on the Formulas tab. And another way you can invoke it is with this little FX button here on the Formula bar.

Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.