So in the last video,

we saw how we could use the SUM function to add up values,

but it's quite possible we will all want to perform other operations.

Shawn has decided he can add real value by including an average for each sales manager,

as well as their highest and lowest quarter.

Only small problem is,

Shawn isn't sure how to calculate an average.

Fortunately, Excel can help us with this.

Start by clicking on the cell where you want the answer to go.

Then, come up to formula bar,

and keep going left until you get to the small effects,

which is called Insert function.

Click on the "FX" and it brings up the Insert function dialogue,

which asks you, "What type of operation you want to perform? "

Now, we want to get an average,

so type it in and click "Go."

Excel has returned all the functions that it feels might help you,

and right at the top is Average,

which is perfect, so click "Okay."

Just like the SUM,

Excel's tried to get an average of all the values to the left,

which is not correct.

We don't want to include our total.

So we're going to replace that selection with our four quarters by just selecting them.

You will notice, we could also add additional sets of values,

and we even get a preview of what the answer's going to be.

We're happy, we click "Okay."

So, that was calculating an average using the Insert function.

Now, we'd also like to get Aanya's best quarter.

So, we're going to once again click in the cell where we want the answer to go.

This time, we know the function we want to use is the Max function.

So, we're not going to use the Insert function,

but we're going to come up to our AutoSum.

Just to the right, there's a drop-down,

and if you click on that,

wow, so you can use AutoSum to also get Average,

Count, Max, and Min.

Brilliant. Let's click "Max",

and again, it's selected all the value to the left.

But we know the drill now,

we're going to go and select the values we actually want and

then press "Tab," and there is Aanya's highest.

No prizes for guessing then.

Now, to get the lowest value,

we use the Min function.

This time though, we're going to try typing it in,

which is actually the quickest.

So, I'm going to type =m,

and Excel brings up all the functions that begin with

the letter M. Min is quite far down the list.

So, if I type in i, that will bring it up higher.

Now, to select the Min,

I can either double-click,

or if you want to use your keyboard,

down arrow and Tab.

On a PC, remember you must press "Tab" not "Enter".

Then, again, select the values I want and "Enter".

So, that was how we could use Average, Max, and Min.

We don't need to type those all again,

we can use our fill handle.

So, I'm going to select all three calculations,

come to my fill handle,

and drag all the way down to the bottom row.

All copied down, except for one small problem.

You will notice we've lost the formatting in our total row,

and that's because when we use the fill handle,

it copies both the calculation and the formatting.

Not a problem, come to fill options,

click the drop-down and choose "Fill Without Formatting."

Total row restored to glory.

So, let's recap.

We have looked at four functions so far.

The Sum function, which allows us to get a total of large ranges.

The Average, which will return us the average of a range.

The Max, which gets us the largest value in the dataset,

and the Min, which returns the smallest value.

Make sure you get a chance to practice with all four of these.