Hi, my name is Shir and I'm the founder and CEO of shirconsulting.com where we focus on converting the existing data from your business into massive savings and extraordinary profits. Today we're going to learn the basics of Excel. Let's get started.
So now let's talk about some common Functions that EXCEL has for us. They are SUM, AVERAGE, MEDIAN, MAX and MIN. Let's go through each one.
SUM is simply the total of all of these numbers put together. Notice the "=" sign in the beginning, the name of the Function (SUM), the open parentheses - "(" and the closed parentheses - ")" and then the actual CELLS that are being referenced. I'm going to hit ENTER. And there it is. This is the total of all of those. I can simply COPY and PASTE that Formula across here and widen the COLUMNS so that I can see everything. And the same Formula is going on over here and over here but with the right data.
Let's do the AVERAGE function. "=" AVERAGE, open parentheses "(" - I want to take the AVERAGE of all of these. And notice the colon - ":" - in between these two CELLS to show in between, to show selecting all of these, closed parentheses - ")" - hit ENTER. This is now the exact AVERAGE. I'm going to COPY this over and PASTE this over here as well. Notice that if I change any number, it automatically updates. That's the beauty of using Functions.
Let's go to MEDIAN. "=" the MEDIAN or the number that's in the midpoint of all the numbers in the data set. And here we go. So out of this whole range the most middle point is 101,126. And with these sets of data over here.
Let's do the MAXimum number which is out of all the numbers, out of all the CELLS that I'm choosing what is the highest valued CELL and it is this one right here. Same concept. Let's apply it over here. We can do the same exact thing. "=" MIN and it gives us the lowest valued CELL and returns that. And again it will also automatically update. And there you have it - total or SUM, AVERAGE, MEDIAN, MAX and MIN functions.