Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:00,700 --> 00:00:02,533
now before we move on with more functions
2
00:00:02,533 --> 00:00:04,333
and more calculations in Excel
3
00:00:04,333 --> 00:00:07,099
let's take a moment to pause and make sure we really
4
00:00:07,100 --> 00:00:08,666
understand what's going on with functions
5
00:00:08,666 --> 00:00:10,766
because the whole point here is
6
00:00:10,766 --> 00:00:13,966
I want you to be able to move on and try new functions
7
00:00:13,966 --> 00:00:15,133
and be able to figure out
8
00:00:15,133 --> 00:00:16,699
how to use those in the future
9
00:00:16,700 --> 00:00:19,200
so let's talk about functions in general
10
00:00:19,533 --> 00:00:22,166
now here is what we just did in Excel
11
00:00:22,166 --> 00:00:24,866
I'm going to be showing you in the formula bar
12
00:00:24,933 --> 00:00:25,666
what we've done
13
00:00:25,666 --> 00:00:26,966
and then we'll recreate some of this
14
00:00:26,966 --> 00:00:28,599
and we'll talk about a little bit differently
15
00:00:28,800 --> 00:00:29,500
in this case
16
00:00:29,500 --> 00:00:31,833
when I talk about the function some
17
00:00:32,100 --> 00:00:33,700
this word right here
18
00:00:33,700 --> 00:00:35,900
that is the name of the function
19
00:00:36,100 --> 00:00:37,366
and you can see
20
00:00:37,800 --> 00:00:40,500
Excel is giving us some information here
21
00:00:40,500 --> 00:00:42,900
it's telling us what it's expecting to see
22
00:00:42,900 --> 00:00:44,366
in the parentheses
23
00:00:44,366 --> 00:00:46,366
these are called arguments
24
00:00:46,366 --> 00:00:48,833
and so we have the function at the beginning
25
00:00:48,900 --> 00:00:49,966
after the equal sign
26
00:00:49,966 --> 00:00:52,033
remember we always need the equal sign
27
00:00:52,100 --> 00:00:53,600
then we have the function
28
00:00:53,800 --> 00:00:55,666
and then we have parentheses
29
00:00:55,800 --> 00:00:58,666
in which we need to put information
30
00:00:58,666 --> 00:01:00,366
those are the arguments
31
00:01:00,366 --> 00:01:02,666
and so for a sum function
32
00:01:02,666 --> 00:01:04,399
the arguments is a
33
00:01:04,400 --> 00:01:05,966
are a series of numbers
34
00:01:05,966 --> 00:01:08,833
that were asking Excel to add up for us
35
00:01:09,066 --> 00:01:09,666
and as you saw
36
00:01:09,666 --> 00:01:12,066
we can provide those numbers as a range
37
00:01:12,066 --> 00:01:13,733
or we can just type them in manual
38
00:01:13,733 --> 00:01:14,899
or we can just write in a whole
39
00:01:14,900 --> 00:01:16,333
long sequence of numbers
40
00:01:16,333 --> 00:01:18,433
and as long as it's between those parentheses
41
00:01:18,666 --> 00:01:20,266
Excel will sum those up for us
42
00:01:21,366 --> 00:01:23,999
I'm gonna start over here and retype this in
43
00:01:24,000 --> 00:01:25,100
because I want you to pay
44
00:01:25,100 --> 00:01:26,900
attention to what Excel is doing here
45
00:01:26,900 --> 00:01:29,133
Excel is starting to autofill
46
00:01:29,133 --> 00:01:30,466
once we hit the equal sign
47
00:01:30,466 --> 00:01:31,866
it's guessing
48
00:01:31,900 --> 00:01:34,666
starting to predict what function we might want
49
00:01:35,166 --> 00:01:36,866
when we get that function
50
00:01:36,866 --> 00:01:37,866
in this case some
51
00:01:37,866 --> 00:01:40,166
you can see it gives us some really nice information
52
00:01:40,166 --> 00:01:43,333
adds all the numbers in a range of cells
53
00:01:43,333 --> 00:01:45,233
great now we know what some does
54
00:01:45,500 --> 00:01:47,300
we start to enter the arguments
55
00:01:47,300 --> 00:01:49,500
we enter the open parenthesis sign
56
00:01:49,700 --> 00:01:52,500
and now it's telling us what we need to put into
57
00:01:52,500 --> 00:01:53,300
the parentheses
58
00:01:53,300 --> 00:01:54,700
what arguments it needs
59
00:01:54,700 --> 00:01:56,066
what information it needs
60
00:01:56,066 --> 00:01:57,733
to be able to complete this function
61
00:01:57,733 --> 00:01:58,666
and Excel is saying
62
00:01:58,666 --> 00:02:00,133
I need a series of numbers
63
00:02:00,133 --> 00:02:02,299
and so we've taken care of that already
64
00:02:04,333 --> 00:02:07,133
where this becomes really critical is when we figure
65
00:02:07,133 --> 00:02:09,966
out that there are hundreds of functions in Excel
66
00:02:09,966 --> 00:02:11,533
they're all slightly different
67
00:02:11,533 --> 00:02:12,566
and some have very
68
00:02:12,566 --> 00:02:14,766
very specific uses
69
00:02:14,766 --> 00:02:15,799
let's look at count
70
00:02:15,800 --> 00:02:16,300
for example
71
00:02:16,300 --> 00:02:17,333
I'm gonna clear this out
72
00:02:17,333 --> 00:02:18,666
and we'll do count again
73
00:02:18,766 --> 00:02:20,666
count counts
74
00:02:20,666 --> 00:02:25,599
the number of cells in a range that contain numbers
75
00:02:25,866 --> 00:02:28,299
what this is telling us is that count
76
00:02:28,300 --> 00:02:30,266
can only work on numbers
77
00:02:30,266 --> 00:02:33,166
it can only count up the number of observations
78
00:02:33,600 --> 00:02:36,066
if those observations are numbers
79
00:02:36,466 --> 00:02:39,399
if we try to do count on months
80
00:02:39,400 --> 00:02:40,666
I'm going to move over here
81
00:02:40,666 --> 00:02:42,299
and we'll do the same thing count
82
00:02:43,166 --> 00:02:46,899
and we try to count up how many months we have
83
00:02:47,333 --> 00:02:48,766
what do you think is gonna happen
84
00:02:50,566 --> 00:02:54,199
0 we don't have any counts there
85
00:02:54,200 --> 00:02:57,866
because count can only count numbers
86
00:02:54,200 --> 00:02:57,900
because count can only count numbers
87
00:02:58,666 --> 00:03:00,266
now that doesn't seem useful right
88
00:03:00,266 --> 00:03:01,133
because a lot of time
89
00:03:01,133 --> 00:03:02,999
we do wanna know how many months we have
90
00:03:03,000 --> 00:03:04,800
well this is that idea of specificity
91
00:03:04,800 --> 00:03:06,100
that I was just talking about
92
00:03:06,100 --> 00:03:07,566
so there's a different function here
93
00:03:07,566 --> 00:03:09,199
we'll go ahead and clear this out again
94
00:03:07,566 --> 00:03:09,233
we'll go ahead and clear this out again
95
00:03:09,366 --> 00:03:11,133
we're going to start a new function
96
00:03:11,133 --> 00:03:11,899
and look at this
97
00:03:11,900 --> 00:03:12,800
right below count
98
00:03:12,800 --> 00:03:14,100
there's a different function
99
00:03:14,166 --> 00:03:17,899
count a counts the number of cells in the range
100
00:03:17,900 --> 00:03:19,966
that are not empty
101
00:03:21,466 --> 00:03:22,966
numbers or text
102
00:03:24,066 --> 00:03:25,366
and boom that worked
103
00:03:25,366 --> 00:03:27,266
because as we see up here
104
00:03:27,266 --> 00:03:32,099
we used the count a function focusing on count
105
00:03:32,866 --> 00:03:34,366
look at how there are several others
106
00:03:34,366 --> 00:03:35,366
count if blank
107
00:03:35,366 --> 00:03:37,166
count if count ifs
108
00:03:37,166 --> 00:03:38,766
we're actually gonna use a few of these
109
00:03:38,766 --> 00:03:40,699
we're gonna use some of the if functions as well
110
00:03:40,700 --> 00:03:42,566
so that you can explore how those work
111
00:03:43,000 --> 00:03:45,500
but the key here is recognizing this pattern
112
00:03:45,500 --> 00:03:46,666
so to summarize
113
00:03:46,666 --> 00:03:48,833
we always start with an equal sign with a function
114
00:03:48,866 --> 00:03:50,666
then we put in the function name
115
00:03:50,666 --> 00:03:52,066
once we start typing that in
116
00:03:52,066 --> 00:03:54,633
Excel gives us information about that function
117
00:03:54,900 --> 00:03:56,866
then we start with the parentheses
118
00:03:56,866 --> 00:03:59,133
and that's when Excel gives us hints
119
00:03:59,133 --> 00:04:01,999
in terms of what kinds of information it's looking for
120
00:04:02,000 --> 00:04:03,900
in those arguments
121
00:04:04,133 --> 00:04:06,266
all functions require arguments
122
00:04:06,266 --> 00:04:08,133
and that's what goes in the parentheses
123
00:04:08,133 --> 00:04:09,733
so now that we have this more general
124
00:04:09,733 --> 00:04:11,866
understanding of how functions and Excel work
125
00:04:09,733 --> 00:04:11,899
understanding of how functions and Excel work
126
00:04:11,866 --> 00:04:13,033
we can move on
127
00:04:11,900 --> 00:04:13,033
we can move on
8993
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.