00:00:00:00 - 00:00:34:23 How To Use Basic Excel Functions and Inserting Graphs Hello. So this is going to be a video about how to use basic Excel functions and inserting graphs. For my example, in my video, I just have some random data here with just random numbers. So the first step of creating and using a function is selecting the cell that you want your final answer to be in. And how you start a function is with an equal sign. 00:00:34:23 - 00:00:54:17 So we'll start by typing in equal sign. And then the next step you can simply just start also typing in the function you want to use and you'll see a list near the cell that you're working in pop up. So you can choose that the function that you were looking for. And so you just double click on the function you want to use. 00:00:54:23 - 00:01:18:02 And then the next step is to import the data into the function that you would like to use. And so simply, you can just click and drag and highlight all the data that you want to include in the function. And then the last step is to press enter to get your answer. And these steps are also repeated for other functions like median and mode. 00:01:18:04 - 00:01:52:18 And so I'll show you those examples here too. We start with an equal sign, and then we start typing in our function. We'll do median first and then we're selecting our input data and pressing enter. Then for mode, we press an equal sign type in mode, select your data and press enter. Now there is also a bunch of other ways to input data as well. 00:01:52:20 - 00:02:22:21 I will just use the basic average function to show you different ways to input data into your function. So first we start with an equal sign and type in our function, and then we can click on singular cells like this to include in our function. And then you can add a comma after the first cell you selected to include other singular cells like that. 00:02:22:23 - 00:02:53:10 And if you want to use a bunch of cells in between one another, kind of like how you click and drag, you use the hyphen symbol. So if I wanted two through ten, I would click the two cells and then it would select all of those cells in between those numbers. So we'll do individual ones here, we'll do those two and press enter. 00:02:53:12 - 00:03:14:06 And then you get your answer. Now for importing charts and graphs, the first thing you want to do is go to the insert tab at the top of your screen, and this is where you're going to see all of your options for charts and graphs. The next step you want to do is select the data that you want to include in the graph. 00:03:14:08 - 00:03:48:24 I'll just select my first row of data here and then you can come up here and click on all of these graph buttons and view a bunch of different types of charts and graphs. There's pie graphs, bar graphs, line graphs, all to display your data in different kinds of ways. And then all you have to do when you find a chart that you like is just click on it and it will automatically import it into your Excel sheet. 00:03:49:00 - 00:04:28:00 So that's what one of those looks like. If we use a bunch of different columns, let's see how that looks. We use a different graph, see all the different kinds of data there, go back to insert and then we can show a pie graph. There's also like different 3D options and 2D options for different kinds of views of your data. 00:04:28:02 - 00:04:41:02 Thank you so much for watching. I hope this video helps you understand Excel functions and inserting graphs more.