WEBVTT

0
00:02.170 --> 00:02.780
Right.

1
00:02.800 --> 00:08.530
So, we now know how to do sums the old fashioned way! 
At the moment we've only looked at addition which

2
00:08.530 --> 00:13.210
was the B5 plus C5 plus D5 plus E5...

3
00:13.400 --> 00:18.760
But now we're going to use one of Excel's built in functions to make doing addition a little bit quicker.

4
00:18.910 --> 00:26.150
But...just before we get to that, let me show you another useful tool that Excel has if we quickly want

5
00:26.150 --> 00:28.030
to add up a line numbers...

6
00:28.150 --> 00:33.940
...or a group of numbers, they can be a column, or it can be a row, or it can be any combination of the two.

7
00:34.300 --> 00:38.840
Let's imagine that we find out what the sum of all the values in column D are.

8
00:39.070 --> 00:44.960
If we select our first number, by left clicking, and drag down until they're all highlighted...

9
00:44.960 --> 00:51.220
...now if we look down here at the bottom of Excel, we can see we have a couple of things instantly reported.

10
00:51.310 --> 00:54.040
We can see that we have a count of 9,

11
00:54.070 --> 01:00.580
...and if we have a look we have 1 2 3 4 5 6 7 8 9 cells highlighted...quite correct!

12
01:00.710 --> 01:04.270
And we can instantly see that the sum is 59.

13
01:04.510 --> 01:07.810
Now, we have a few more options in here which are easy to get to.

14
01:07.820 --> 01:14.590
If you just hover your mouse over this little bar at the bottom, right click, this box will appear.

15
01:14.770 --> 01:21.490
Now, in this area just here, are all the things that we can instantly get a feedback on.

16
01:21.520 --> 01:22.950
These are just toggle on and off.

17
01:22.950 --> 01:26.560
So if it's ticked, and you don't want it, left click and it unticks it...

18
01:26.950 --> 01:33.750
...and so if we wanted to see average, we could click "Average". 
We may want to see minimum and we may see maximum.

19
01:33.760 --> 01:39.700
So, I've just selected those...click off, and now you can see instantly Excel will tell us the average of this

20
01:39.700 --> 01:45.880
range that you've highlighted just the here, is 6.55 lots of fives and 6! The lowest

21
01:45.880 --> 01:48.110
value, the "Min" is 2.

22
01:48.160 --> 01:51.420
And if we have a quick look down we can see, yes, absolutely.

23
01:51.460 --> 01:54.810
That's 2. The maximum value is 9.

24
01:54.850 --> 01:58.190
And we have a couple...two...three...9's in there.

25
01:58.200 --> 01:59.320
That is the highest value.

26
01:59.320 --> 02:00.100
So quite correct.

27
02:00.130 --> 02:01.910
And the sum is 59.

28
02:02.020 --> 02:07.900
So that works in the vertical plane.
You can also come across and do it in the horizontal plane, or you

29
02:07.900 --> 02:09.940
can highlight a range of numbers.

30
02:09.940 --> 02:16.330
So, if we we selected all of our data just here, we can see that the lowest value is zero...which it probably

31
02:16.330 --> 02:16.540
is.

32
02:16.540 --> 02:18.210
We've definitely got zero there.

33
02:18.250 --> 02:23.540
The highest value is 15, which is there...which is quite correct.

34
02:23.590 --> 02:25.860
We have an average of 7.4...

35
02:25.900 --> 02:28.410
I can't work that out in my head, but I'm sure it's right.

36
02:28.630 --> 02:35.060
And the total sum all of our sales for all of our items for every day is 333.

37
02:35.350 --> 02:40.660
So there you go, a very useful function for quickly finding out the sums or the lowest values are the highest

38
02:40.660 --> 02:44.920
values...have a play around with it, and I'm sure you'll find that very useful.

39
02:45.850 --> 02:54.300
Okay, let's look at autosums.
"Autosum" is a function that's built into Excel that speeds up

40
02:54.370 --> 02:56.170
basic addition.

41
02:56.170 --> 03:01.690
Now you'll recall from a previous lecture, that when we did our addition we hit "=", then we clicked

42
03:01.700 --> 03:07.930
cell B5, then "+", then clicked cell C5, then "+", then D5, then "+"...and on and on and on, hit "Enter"...

43
03:07.930 --> 03:10.170
and eventually we got to our answer.

44
03:10.300 --> 03:12.570
So it works...but it's not quick.

45
03:12.640 --> 03:15.460
So the autoum seeks to address that problem.

46
03:15.460 --> 03:19.610
Now, the thing to remember about autosum is it only sums columns.

47
03:19.690 --> 03:24.370
So we couldn't use and also some to add to this range of values here.

48
03:24.650 --> 03:27.880
But don't worry, we'll come to that in just a few seconds.

49
03:27.880 --> 03:31.550
But what it can do is automatically add a column.

50
03:31.570 --> 03:37.150
So, what you'll do to use an autosum is left click the column where you want the result to appear, which

51
03:37.150 --> 03:42.370
will normally be the first blank cell below the list of numbers that you want to add up.

52
03:42.400 --> 03:44.470
We have two ways to get to autosum;

53
03:44.560 --> 03:52.050
We can see here, in the home ribbon, just there.
Or, we're actually going to go in to one of our other ribbons...

54
03:52.060 --> 03:54.500
...now, that's the "Formula's ribbon", just up here.

55
03:54.790 --> 04:00.040
So I'm going to hover over it, left click, and now we can see that our formula ribbon has been displayed...

56
04:00.520 --> 04:03.160
and the second option is autosum.

57
04:03.250 --> 04:08.740
So, if we hover over it with our mouse, we can see we get our little tool tip that tells what it does...

58
04:08.860 --> 04:11.090
it automatically adds stuff up.

59
04:11.170 --> 04:12.390
So, let's go right ahead.

60
04:12.400 --> 04:17.290
Left click and we can see there that Excel has already written the formula for us.

61
04:17.290 --> 04:18.450
It's included the "="...

62
04:18.460 --> 04:20.230
...to tell it it's a formula.

63
04:20.290 --> 04:27.530
It includes the function, SUM, it's included the parentheses or the brackets, which enclose the arguments.

64
04:27.760 --> 04:31.790
The arguments are just the range of data that the function is going to act upon.

65
04:31.810 --> 04:37.090
Don't worry about that too much now, it will become second nature very soon...and it's also highlighted the

66
04:37.090 --> 04:39.890
range of the arguments, and we can see here...

67
04:40.000 --> 04:47.800
...we have cells B5 through B13 highlighted, and if we look at how that's expressed between the brackets

68
04:48.130 --> 04:52.740
we can see that we have B5...you can probably see a little clearer in the formula bar...

69
04:52.780 --> 05:03.850
...we have B5, colon, B13...and all that means is from B5 (colon), which means "through to" cell B13. Hit "Enter"...

70
05:04.060 --> 05:04.690
and there you go!

71
05:04.690 --> 05:07.900
We have our first autosum! There you go.

72
05:07.900 --> 05:12.210
That's how you do an autism...very simple, just click at the bottom of your data,

73
05:12.430 --> 05:15.510
Hit the "Autosum" button, press "Enter" and there you go.

74
05:15.520 --> 05:21.080
That's how you do an autosum. Much quicker than selecting each cell then hitting "+" repeatedly...

75
05:21.090 --> 05:22.800
...until you get to the right answer.

76
05:23.030 --> 05:25.880
Okay, next we're going to have a look at how we can copy our formulas...

77
05:26.050 --> 05:29.560
...so we don't have to keep rewriting them every time we want to use them.

78
05:29.750 --> 05:31.270
Okay! See you in the next lecture.