WEBVTT

0
00:02.740 --> 00:03.060
Right.

1
00:03.060 --> 00:05.710
We're moving along at a great pace now.

2
00:05.920 --> 00:11.000
Now the next formula we're going to look at is subtraction and it's very simple to do.

3
00:11.290 --> 00:14.520
What we're going to do is add two more columns to our data.

4
00:14.800 --> 00:18.960
We're going to add an opening stock...

5
00:19.490 --> 00:25.520
And we're then going to add our closing stock...

6
00:25.670 --> 00:27.610
Okay let's just resize those.

7
00:27.610 --> 00:31.620
We've done this before, just highlight the columns, double click in between.

8
00:31.690 --> 00:34.360
And I wish I could type.

9
00:34.510 --> 00:35.990
Closing stock there you go.

10
00:36.490 --> 00:41.140
Okay now I'm just going to randomly make up some numbers here, so let's imagine that we started the week

11
00:41.140 --> 00:48.580
with 75 of everything so I'm just going to hit 75, and enter...reselect the cell, double-click, which we

12
00:48.580 --> 00:49.410
know fills down.

13
00:49.420 --> 00:50.360
So there you go.

14
00:50.410 --> 00:52.460
Now we know what our opening stock was.

15
00:52.480 --> 00:55.490
And now it's time to do our subtraction formula.

16
00:55.550 --> 00:59.570
We could do this in one of two ways, what we could say is "=", 

17
00:59.620 --> 01:10.330
...it's a formula...that, less that, less that, less that, less that, less that, and "Enter" to find out that we

18
01:10.330 --> 01:12.920
would have 35 left as our closing stock.

19
01:12.950 --> 01:17.270
We can do it in a much quicker way by utilizing something that we've already done.

20
01:17.620 --> 01:22.920
So, what we're going to do is we type "=", opening stock...

21
01:23.080 --> 01:29.530
...and as we've already worked to what the total of all of these are in this formula just here, we're just

22
01:29.530 --> 01:39.370
going to say "opening stock" minus our "total sales", hit "Enter", and there you go...35.
And again, to copy that formula

23
01:39.370 --> 01:44.860
down we're just going to double click, when our cursor changes to the black cross, to fill down and there you

24
01:44.860 --> 01:53.620
go. We can see that we started with 75 of each of our items and we ended with 35 apples, 40 oranges, and

25
01:53.620 --> 01:56.180
so on and so forth all the way down.

26
01:56.230 --> 02:00.970
So just in case it wasn't obvious to you, Excel will automatically recalculate.

27
02:00.960 --> 02:07.840
So if we look at oranges, we can see that our opening stock was 75, and once we subtract all of our cells

28
02:07.840 --> 02:09.270
we have 40 left.

29
02:09.310 --> 02:15.670
If we change that to 15, hit "Enter", you can see that this result has also changed.

30
02:15.670 --> 02:21.160
So Excel automatically recalculates...you don't have to do anything again, it automatically works it

31
02:21.160 --> 02:22.800
all out for you.

32
02:22.800 --> 02:26.020
And there you go, nice and simple, onto the next lecture.