WEBVTT

0
00:03.680 --> 00:11.680
Okay...now we're going to get to what Excel does best: maths!
Now, Excel has a number of built in functions

1
00:11.720 --> 00:14.030
to speed up entering formulas.

2
00:14.030 --> 00:19.190
At the moment we're going to start at the very beginning, and do sums the old fashioned way.

3
00:19.430 --> 00:25.090
So, we going to come over to cell G5, and just left click to select it.

4
00:25.100 --> 00:30.410
Now, the first thing to remember whenever you enter a formula in Excel, is it it always begins with an

5
00:30.470 --> 00:31.920
equals sign (=).

6
00:32.030 --> 00:38.570
So, if you hit "=" on your keyboard, instantly Excel will know that what you're entering is a formula.

7
00:38.600 --> 00:42.810
And this is true for every single formula you will ever enter in Excel.

8
00:43.090 --> 00:43.670
Okay.

9
00:43.820 --> 00:49.000
At the moment what we want to do is add up our total sales of apples for the week.

10
00:49.040 --> 00:52.230
On Monday, Tuesday, Wednesday, Thursday, and Friday.

11
00:52.370 --> 00:58.910
So, what we can do is just simply left click the first entry...and you can see that it's been highlighted

12
00:58.910 --> 01:00.890
with the dancing ants. Hit...

13
01:00.900 --> 01:10.160
..."+"...we can move our mouse over, click Tuesday, hit "+", move our mouse over, Wednesday "+", Thursday "+",

14
01:11.090 --> 01:16.430
Friday, and hit "Enter" and you can see that it's cleverly totalled everything up.

15
01:16.640 --> 01:18.990
So that's how you do sums the old fashioned way.

16
01:19.010 --> 01:21.330
Now, one thing to notice with this...

17
01:21.910 --> 01:28.970
...if I hit F2 on my keyboard you can see that it shows us the formula rather than the result.

18
01:28.970 --> 01:33.990
Now one thing to pay particular attention to, I'll just move the mouse out of the way here, is...

19
01:34.000 --> 01:45.980
...you can see that each of the cell references...that is the B5, C5, D5, E5 and F5 are all highlighted

20
01:45.980 --> 01:53.350
in different colours, and they correspond to the colours that are highlighted in the cells themselves.

21
01:53.380 --> 01:59.600
This is very useful, because it makes it easy to spot which part of your formula is referring to

22
01:59.600 --> 02:00.790
which cell.

23
02:00.800 --> 02:08.680
So for example, if we wanted to change D5 we can instantly see that it's kind of a purple colour and

24
02:08.720 --> 02:10.940
we can see that this is a purply colour.

25
02:11.180 --> 02:18.410
Well if we have around mouse over, until our cursor changes to this pointed cross, we can left click and

26
02:18.410 --> 02:23.440
drag...and you can see that our formula is changing accordingly.

27
02:23.690 --> 02:28.110
So we could move it over to the left we can move it to the right we can move in anywhere.

28
02:28.190 --> 02:36.440
So if, for argument's sake, we accidentally clicked the wrong cell...let's just hit "EnterE and and hit

29
02:36.440 --> 02:42.530
F2 again, we can see instantly by this highlighting that we actually selected the wrong cell when we

30
02:42.590 --> 02:44.040
typed our formula in.

31
02:44.240 --> 02:49.740
So it's easier to correct, rather than having to retype the entire formula...just hover over the part that's

32
02:49.770 --> 02:54.170
incorrect. Because these should be adding up all of our Apple sales...

33
02:54.350 --> 02:58.790
Left click, drag up...and you can see that your formula is being corrected.

34
02:58.790 --> 03:00.410
Hit "EnterE and there you go.

35
03:00.410 --> 03:01.680
And that's how you do a sum...

36
03:01.690 --> 03:08.090
...the old fashioned way.
In the next lecture we will be covering how to use the autosum function.

37
03:08.330 --> 03:09.630
So you in the next lecture.