Skip to playerSkip to main content
  • 11 months ago
Microsoft Excel is a powerful spreadsheet application used for organizing, analyzing, and visualizing data. In this course, you will learn the essential skills you need to get started and become confident in using Excel.

In this video lesson, we will learn about Insert Function Option in Microsoft Excel

You can access the entire Microsoft Excel Course in the following playlist:
https://thao.funnymoment.net/playlist/xa9hyw

Category

📚
Learning
Transcript
00:00So if there are functions and you don't know how to go ahead and type those in, then you can actually
00:11go ahead and find them and insert them out. So let's say for example, I got these three numbers
00:17and I want to go ahead and find out an abras of these, but I don't know the function for it. In
00:23that case, I can go around over here. So let's say this is where I want the abras, then I can go
00:29around over here onto FX, click on it, and then you simply have the function sets right here.
00:34So if I were to go ahead and type in abras right here, right here, go, it goes ahead and gives me
00:41the abras. And then you get the description of the function as well. So let me just go ahead and
00:46choose abras. So let's say this is the one that I want, press OK, and then you get the function
00:52arguments. So over here, you can see that as I click right here, you can see that it says it
00:57returns the abras value right here. So you can go ahead and choose number one right here,
01:02and it even goes ahead and says what you need. So let's say I can go ahead and click on this one,
01:07I can go to number two, click on this one, click on this one, and then you can see that you actually
01:13have the formula written for you just like this. Press OK, then you get the abras just like that.
01:19You can also go ahead right here and then get out those function from the formulas tab right here,
01:25and you can go around over here on to insert function right here, just like this. And then
01:31you can see that this is the function that you have. So if there's any formula that you have right
01:36here, for example, if I were to go around and type in sum, and then you go around over here on to
01:41insert function, then you get the sum function right here. But if I were to click on an empty area,
01:46then you will be able to see that the many different function right here, just like that. For example,
01:52if I were to go around sets for if, then you get the if function right here, just like this. If I were
01:57to go around and type in mean, let's say for example, then you get the relevant function right
02:02here, just like this, as you can see. So that is how you can go ahead and utilize the insert function
02:08option inside of Microsoft Excel. So I hope you found this video useful. Be sure to hit the like
02:15button. Don't forget to share this out with your friends and family. And for more contents like these,
02:21do follow simple tutorials.

Recommended