WEBVTT

0
00:03.380 --> 00:06.230
Okay guys we've covered a lot of ground so far.

1
00:06.230 --> 00:12.920
We've covered basic addition, we've covered basic subtraction, basic multiplication and basic division

2
00:12.980 --> 00:14.600
in our earlier lectures.

3
00:14.630 --> 00:20.450
We've also had a quick look at our first Excel built in function of "Autosum" and we're about to come

4
00:20.450 --> 00:24.410
to our second built in function in Excel, which is "Average".

5
00:24.410 --> 00:26.870
So, just so you don't forget what it is that we're going to be doing.

6
00:26.870 --> 00:32.260
I'm just going to type the title "Average" in our list there, so now we will know what this is when we're looking

7
00:32.270 --> 00:33.020
at it.

8
00:33.320 --> 00:33.960
Okay.

9
00:34.190 --> 00:40.940
Now, when we click autosum, you'll recall from the earlier lecture, Excel automatically writes our complete

10
00:40.940 --> 00:43.580
formula using the autosum.

11
00:43.580 --> 00:46.050
Now SUM is the operative word there.

12
00:46.130 --> 00:50.820
If you've noticed there is actually a little down arrow below the autosum...

13
00:50.850 --> 00:57.030
icon, and if you left click with your mouse, you can see that we have other options available to us.

14
00:57.230 --> 01:02.360
And what we're going to do is we're going to hover over "Average", left click, and we can see there that

15
01:02.360 --> 01:06.590
Excel has automatically written the complete formula for us.

16
01:06.590 --> 01:13.620
Now at the moment, the formula is incorrect, because we have not only our sales for apples, oranges, or other

17
01:13.670 --> 01:19.470
fruits and veggies, at the bottom we also have a total which is going to skew the result.

18
01:19.520 --> 01:24.750
So for now let's just hit enter and we can see that the average is 12.

19
01:25.050 --> 01:31.790
Now what we need to do is edit the formula so it ignores the total, and the way to do that is to hit

20
01:31.880 --> 01:39.000
F2 on your keyboard, and you can see that you now have access to the formula to be able to edit it.

21
01:39.020 --> 01:46.550
Now, we can see that range B5 to B14 has been selected, which is reflected in the highlighted area on

22
01:46.550 --> 01:52.150
the worksheet...and what we're going to do is we're just going to come up to the formula bar up here...

23
01:52.220 --> 01:57.050
...we're going to left click just between the 4 and close brackets...

24
01:57.110 --> 02:00.390
...we're going to delete the 4 and were going to type 5.

25
02:00.520 --> 02:02.380
No we can delete the 4.

26
02:02.390 --> 02:03.980
We we're going to type 3.

27
02:04.130 --> 02:10.460
So there we can see that the highlighted area is actually now only for fruits and veggies.

28
02:10.490 --> 02:15.820
So now we're happy that our formulas been successfully edited, hit "Enter", and there you go.

29
02:15.820 --> 02:22.400
We now have our average sales of 6.666 lots of sixes and a 7 and again what we're going

30
02:22.400 --> 02:26.000
to do is copy that across for all of our days of the week.

31
02:26.000 --> 02:27.480
By left clicking...

32
02:27.810 --> 02:30.530
...drag it over with our mouse button pressed.

33
02:30.560 --> 02:32.700
Let go of the mouse button, and there you go.

34
02:32.720 --> 02:38.230
Now we have our averages, and how you use the autosum "Average" function. Okay.

35
02:38.360 --> 02:39.710
See you in the next lecture.