WEBVTT

0
00:01.350 --> 00:01.740
Okay.

1
00:01.740 --> 00:04.340
We're covering a lot of ground very quickly.

2
00:04.340 --> 00:09.360
We have learned how to do addition the long hand way, the old fashioned way. We've learned how to do

3
00:09.360 --> 00:11.900
addition using the autosum function.

4
00:12.090 --> 00:14.680
And we've also learned how to do subtraction.

5
00:14.700 --> 00:16.910
Next we're going to cover a multiplication.

6
00:17.100 --> 00:23.430
And to do this, we're going to add another column to our table, and this time, we're going to call it "Monthly".

7
00:23.430 --> 00:26.360
...Sales". Okay.

8
00:26.490 --> 00:32.610
And we're going to do this very simply.
I'm just going to resize that there...now, because we already know

9
00:32.610 --> 00:39.090
how many of each item we sell a week, because we used our SUM function over here in column G...

10
00:39.120 --> 00:42.980
...we're going to utilize that again, just to do a simple multiplication.

11
00:43.200 --> 00:47.780
For simplicity sake, we'll just imagine there are four weeks in each month.

12
00:47.790 --> 00:49.600
I know that's not strictly correct.

13
00:49.620 --> 00:52.160
But let's just do that for simplicity sake.

14
00:52.170 --> 00:57.120
So, again type "=", which tells Excel that we're about to enter a formula...

15
00:57.120 --> 01:03.390
...we're going to click "total", because we already know the total of our weekly sales, we can hit "*"

16
01:04.130 --> 01:12.270
"4", and hit "Enter", and there you go...we can see that if if a month had four weeks then our monthly sales of

17
01:12.300 --> 01:14.810
apples would be 168.

18
01:15.000 --> 01:20.550
And we're going to hover over there, and just double click to fill down...so we can instantly see that our

19
01:20.550 --> 01:24.480
monthly sales of each of our items would be...there you go.

20
01:24.540 --> 01:26.400
And that's how you do multiplication.

21
01:26.400 --> 01:27.810
Very simple indeed.

22
01:28.080 --> 01:30.530
Onto the next lecture, where we'll cover division.