WEBVTT

0
00:02.200 --> 00:06.120
Okay guys let's have a look at a simple division formula.

1
00:06.280 --> 00:11.140
Now, again we're going to add another column over here at the end and we're going to work out this time

2
00:11.140 --> 00:13.680
when our average daily sales are.

3
00:13.720 --> 00:15.010
So I'm just going to type...

4
00:15.040 --> 00:18.280
"Average daily sales".

5
00:18.750 --> 00:20.140
And there you go.

6
00:20.230 --> 00:26.500
I'm just going to re size that, again we're going to come in to our first empty cell and we're going

7
00:26.500 --> 00:30.420
to hit "=" to tell Excel that we are about to do a formula.

8
00:30.640 --> 00:34.620
Next we're going to utilize our SUM again from Column G.

9
00:34.620 --> 00:39.640
So we're just going to left click there, and we can see that that's automatically been highlighted.

10
00:39.640 --> 00:44.100
We're going to hit "/", and we're going to count up how many we need to divide by.

11
00:44.110 --> 00:47.270
So we have Monday, Tuesday, Wednesday, Thursday, Friday...

12
00:47.680 --> 00:48.810
That's five.

13
00:48.820 --> 00:55.780
So we just hit 5 on our keyboard, hit "Enter", and there you  go...we can see that our average daily sales for apples

14
00:56.140 --> 00:57.150
is 8.

15
00:57.280 --> 01:03.580
And again just click that cell, double click when our cursor changes, and there you go...we can see our average

16
01:03.580 --> 01:06.030
daily sales for each of our items.

17
01:06.040 --> 01:08.950
Now, that's how you do a simple division.

18
01:09.130 --> 01:14.910
Now obviously because we're working out an average, we may also want to use the average function and

19
01:14.920 --> 01:17.290
we're going to cover that in the very next lecture.

20
01:17.290 --> 01:18.970
See you in a few seconds.