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 cover the basics of functions. We will show you how to find the function that you need, how to identify what it does and how to use it. We will also demonstrate a simple function in this section.

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 start to look at Functions and we’re going to spend quite a bit of time looking at functions and they’re very much going to be the basis of many of the other things that we cover later in the course.

Functions have been one of the main strengths of Excel very much since it started really. And in Excel 2016 the number of available Functions has passed the 400 mark and I can assure you that we’re not going through all of those on this course, but we are going to look at quite a few of them. And really the sheer number of Functions is one of the problems with using them in that even if you’ve got an idea of the function you need you may not know what it’s called and you may have trouble finding it.

So in this first section I’m going to cover a few of the basics of Functions which I’m sure you’ll be familiar with but I’m going to try to extend those into areas that you may not have seen or used before. And I’m also going to talk a little bit about how to find the function that you need and how to identify not only what it does but how to use it.

Now the first thing I’m going to point out is that there is a pretty good Help topic on Functions in Excel 2016 and this is a good reference point to find out about Functions.
Here is that Help topic, Excel Functions by Category. Many of the categories agree with those that I use in this section of the course. Let’s go into a particular category. Let’s say go into Logical Functions. Within the list of Logical Functions some of the Functions have a little year number under them. That actually corresponds to a version of Excel and it shows you when that particular function was introduced, which implies that the function was not available in any versions of Excel prior to the one that is listed. So for example, the IFS function, the IFS function was introduced in Excel 2016.

If you drill down into a function you get a lot of useful information. There is usually a brief description of what the function does. There will then be some technical details that usually include information about the arguments, which ones are required and optional, information about data types and so on. And then generally one or more examples of the use of the function. Depending on the complexity and importance of the function you may have more examples, more explanations and so on. You also get questions such as common problems that you might get with this function and typical sort of errors that you get, and explanations of how those errors might have occurred.

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