Get 20+ Excel courses at Simon Sez IT, including training for Excel 365, 2021, 2019, 2016, 2013, and more ️ https://www.simonsezit.com/course-category/excel/ Get a FREE 2.4 hour Excel 2019 Beginners course here ►
https://simonsezit.lpages.co/excel-2019-beginner-course-ssit/
In this video, learn how to search the specific function you may need while using Microsoft Excel 2013.

Get the full course on Excel 2013 course here: http://www.simonsezit.com/courses/microsoft/learn-microsoft-excel-2013-advanced-training-tutorials/

Watch the Excel 2013 playlist: https://www.youtube.comhttp://www.youtube.com/playlist?list=PLzj7TwUeMQ3jVfCjoptJb_mimawnVezqh

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

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 2013 Advanced. In this section we’re going to look at some of the more advanced aspects of functions in Excel 2013. You should already be familiar with the Formulas tab so we’re going to start with that.
Now when you’re using the Formulas tab to insert a function, one of the problems you’ve probably come across in the past is finding the function that you want. Even if you know the name of the function, you won’t necessarily know which category it’s in. There are various things that can help you with this and one of the things we’re going to look at in a moment is the very first button on the left here, the Insert function button.

But let’s look at the function library first and we have all these categories. I’m sure you’ve used many of these in the past. The last option, More functions, gives you access to additional categories: statistical, engineering, cube, and so on. Now whichever category you’re interested in and indeed whichever function you’re interested in, if you hover over the function name you get a description of what that function does as well as a syntactical definition including a list of the arguments of the function. So that’s one thing that can help you to find the function that you want. With each of these categories, with all of the buttons here right at the bottom, you have Insert function which gives you access to the Insert Function dialog and, as I said just now, that’s the one I want to look at in detail first.

Now one useful thing when you’re using the Insert Function dialog is that you effectively have two lots of Help. The question mark denoting the conventional Help in the Office 2013 applications, if you click on that, the Help that you get relates to how to use this dialogue. In fact, slightly more generally how to create a formula that uses or includes a function. So that’s the general Help on working with formulas and functions. Whereas at the bottom left of the dialog given a selected function, let’s suppose I select this one Cube set, Help on this function gives me access to the Help specifically on the selected function. So if you’re not sure about a particular function, what it does and how to use it, you’ve got direct access to the relevant Help there.

Now in terms of finding a specific function, if you know the name and you don’t really want to go around the function library on the Formulas tab, you can select the category here and look for that particular function within any one of the categories. If you choose a particular category and you want to know what a particular function does, click on the function, you get a brief description here, and as I mentioned just now you also have access through to the Help on that function. So that’s one way of quickly going through the lists of available functions and finding the one that you want.

If you’re quite a bit unsure about the name of the function that you want or if you don’t even know whether such a function exists, you can use the Search facility within the Insert Function dialog. This is a fairly intelligent search facility. It uses a certain amount of what might loosely be called fuzzy logic. So if I say wanted to find the median of some numbers, I could click in this box, type in the word Median, and then hit the Go button and it will find the median function for me. Now that is the only specific median function in Excel 2013 but a median is a statistical average and there are various other statistical averages such as mean and mode.

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