1
00:00:00,05 --> 00:00:02,08
- [Instructor] Excel has a feature called AutoSum,

2
00:00:02,08 --> 00:00:05,04
and it's so useful, it's on the Home ribbon tab

3
00:00:05,04 --> 00:00:07,02
right here on the right hand side.

4
00:00:07,02 --> 00:00:09,06
We spend so much time doing data entry.

5
00:00:09,06 --> 00:00:12,04
Of course, we'd want to see the value of that data

6
00:00:12,04 --> 00:00:14,08
that we're putting in, and we can do that easily

7
00:00:14,08 --> 00:00:16,05
with AutoSum.

8
00:00:16,05 --> 00:00:17,06
Let's take this.

9
00:00:17,06 --> 00:00:19,09
During January, these are all the units sold

10
00:00:19,09 --> 00:00:21,03
for my products.

11
00:00:21,03 --> 00:00:23,04
If I want to find out the total amount of products

12
00:00:23,04 --> 00:00:25,00
that were sold during January,

13
00:00:25,00 --> 00:00:27,02
I can place the cursor here at the bottom

14
00:00:27,02 --> 00:00:30,02
of all my data and click the AutoSum button

15
00:00:30,02 --> 00:00:32,09
on the top right hand side of the Home ribbon tab.

16
00:00:32,09 --> 00:00:34,05
It's going to put in the formula.

17
00:00:34,05 --> 00:00:38,06
In fact, here I can see that it's just done my work for me.

18
00:00:38,06 --> 00:00:40,00
It's put in the sum function,

19
00:00:40,00 --> 00:00:43,02
and it's summing cell B2 through B6.

20
00:00:43,02 --> 00:00:46,07
All I have to do now is hit the enter key,

21
00:00:46,07 --> 00:00:48,06
and there's my total.

22
00:00:48,06 --> 00:00:50,01
A nice thing about AutoSum,

23
00:00:50,01 --> 00:00:52,00
and I'll delete this,

24
00:00:52,00 --> 00:00:55,02
is that I can sum everything all at once.

25
00:00:55,02 --> 00:00:56,07
I'm going to click and drag with my mouse

26
00:00:56,07 --> 00:00:59,05
to select all of these cells.

27
00:00:59,05 --> 00:01:01,07
If I click the AutoSum button again,

28
00:01:01,07 --> 00:01:05,02
it's going to instantly populate with those totals.

29
00:01:05,02 --> 00:01:07,09
In fact, if I click inside each cell,

30
00:01:07,09 --> 00:01:09,05
I can look in the formula bar

31
00:01:09,05 --> 00:01:11,03
and see what it's calculating.

32
00:01:11,03 --> 00:01:14,02
For example, here in March, I can see

33
00:01:14,02 --> 00:01:16,02
that it's summing column D.

34
00:01:16,02 --> 00:01:20,06
In February, it's summing column C, and so on.

35
00:01:20,06 --> 00:01:22,07
The really neat thing about AutoSum

36
00:01:22,07 --> 00:01:27,06
is that it's not just for summing.

37
00:01:27,06 --> 00:01:29,09
If I click the down arrow next to AutoSum,

38
00:01:29,09 --> 00:01:31,04
I can find the average,

39
00:01:31,04 --> 00:01:32,09
I can count all the numbers,

40
00:01:32,09 --> 00:01:34,07
find the max and min,

41
00:01:34,07 --> 00:01:37,04
and get even more functions that I can do.

42
00:01:37,04 --> 00:01:41,01
For example, let's find out the highest units sold

43
00:01:41,01 --> 00:01:45,04
during January.

44
00:01:45,04 --> 00:01:48,03
AutoSum also works going vertically.

45
00:01:48,03 --> 00:01:49,06
Let's come here to the end

46
00:01:49,06 --> 00:01:51,03
and do a different tally.

47
00:01:51,03 --> 00:01:54,03
This time, I want to see the total amount of units sold

48
00:01:54,03 --> 00:01:58,00
per product, so I'll select the cells this way

49
00:01:58,00 --> 00:02:00,06
and click AutoSum again.

50
00:02:00,06 --> 00:02:03,07
This time, we get a completely new set of sums

51
00:02:03,07 --> 00:02:05,08
because it's summing across,

52
00:02:05,08 --> 00:02:08,07
and again, I can easily do the same thing.

53
00:02:08,07 --> 00:02:11,01
I can find the averages, the highest values,

54
00:02:11,01 --> 00:02:15,01
or the lowest value.

55
00:02:15,01 --> 00:02:17,05
I can also copy my own formulas

56
00:02:17,05 --> 00:02:19,06
if I've worked hard to create one myself,

57
00:02:19,06 --> 00:02:21,04
and it doesn't have to be a sum.

58
00:02:21,04 --> 00:02:23,01
It can be anything.

59
00:02:23,01 --> 00:02:25,00
This time, though, just to make things easy,

60
00:02:25,00 --> 00:02:27,07
I'll type in my sum formula manually,

61
00:02:27,07 --> 00:02:29,06
equals sum,

62
00:02:29,06 --> 00:02:31,08
and I'll click and drag to select these cells

63
00:02:31,08 --> 00:02:34,09
and close the parentheses.

64
00:02:34,09 --> 00:02:36,04
Here's my value.

65
00:02:36,04 --> 00:02:38,03
But remember AutoFill?

66
00:02:38,03 --> 00:02:40,08
When we hover the mouse over the bottom right hand side

67
00:02:40,08 --> 00:02:43,06
of a cell, it's going to change to a plus sign,

68
00:02:43,06 --> 00:02:46,05
that cross hair icon, and when that happens,

69
00:02:46,05 --> 00:02:49,06
I can click and drag all the way across.

70
00:02:49,06 --> 00:02:52,05
What that's going to do is copy the formula

71
00:02:52,05 --> 00:02:54,07
all the way across.

72
00:02:54,07 --> 00:02:57,04
Now, as you can see, if I click on each cell,

73
00:02:57,04 --> 00:03:00,01
I can see the different sums.

74
00:03:00,01 --> 00:03:03,03
As a matter of fact, I can double click inside a cell,

75
00:03:03,03 --> 00:03:06,02
and it's going to show me the exact same formula.

76
00:03:06,02 --> 00:03:08,09
So we can either look at it in the formula bar up here,

77
00:03:08,09 --> 00:03:11,00
or I can double click on the cell.