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:01,600
congratulations
2
00:00:01,600 --> 00:00:02,066
you finished
3
00:00:02,066 --> 00:00:03,999
your second week worth of material in Excel
4
00:00:04,000 --> 00:00:05,066
for the 99%
5
00:00:05,066 --> 00:00:05,799
and as you know
6
00:00:05,800 --> 00:00:07,800
you just got a lot of practice
7
00:00:07,800 --> 00:00:09,966
making charts and plots in Excel
8
00:00:10,300 --> 00:00:12,333
let's do a quick recap of some of our key
9
00:00:12,333 --> 00:00:14,266
points that we Learned this week
10
00:00:14,400 --> 00:00:16,066
this will help us as we move on
11
00:00:16,066 --> 00:00:17,399
remembering the details
12
00:00:17,400 --> 00:00:18,466
you can look those up
13
00:00:18,466 --> 00:00:20,733
but remembering the key principles
14
00:00:20,733 --> 00:00:22,666
of making charts in Excel
15
00:00:22,666 --> 00:00:25,433
is what's really going to benefit you in the long run
16
00:00:25,800 --> 00:00:26,866
first of all
17
00:00:26,933 --> 00:00:28,133
you probably know at this point
18
00:00:28,133 --> 00:00:28,699
I'm gonna tell you
19
00:00:28,700 --> 00:00:30,000
that the most important thing
20
00:00:30,000 --> 00:00:32,600
is to think carefully about what question
21
00:00:32,600 --> 00:00:34,866
you want to answer with a chart
22
00:00:34,933 --> 00:00:37,599
or what point you want to make
23
00:00:37,966 --> 00:00:40,299
you are going to be the best judge of that
24
00:00:40,300 --> 00:00:42,600
and so thinking deeply about that's going to be
25
00:00:42,600 --> 00:00:43,300
really critical
26
00:00:43,300 --> 00:00:45,900
do you wanna compare some variable of interest
27
00:00:45,900 --> 00:00:47,166
across different categories
28
00:00:47,166 --> 00:00:49,233
like we do in a bar column chart
29
00:00:49,700 --> 00:00:51,133
do you wanna see how two variables
30
00:00:51,133 --> 00:00:52,099
are related to each other
31
00:00:52,100 --> 00:00:53,433
like in a scatter plot
32
00:00:53,566 --> 00:00:54,933
or do you wanna understand
33
00:00:54,933 --> 00:00:57,199
how different parts make up a hole
34
00:00:57,266 --> 00:00:59,266
like a part of pie chart
35
00:00:59,266 --> 00:01:00,999
or a stacked column chart
36
00:01:01,000 --> 00:01:03,733
those kinds of questions are the things to ask yourself
37
00:01:03,733 --> 00:01:06,299
before you start making graphs in Excel
38
00:01:06,566 --> 00:01:07,199
and remember
39
00:01:07,200 --> 00:01:09,366
Excel can give you recommendations
40
00:01:09,366 --> 00:01:11,366
with the recommended charts feature
41
00:01:11,400 --> 00:01:13,800
but those aren't always going to match your goal
42
00:01:13,800 --> 00:01:15,600
so think about your goal
43
00:01:15,666 --> 00:01:17,666
then look at the recommended charts
44
00:01:17,666 --> 00:01:18,933
those two things together
45
00:01:18,933 --> 00:01:20,266
can be really effective
46
00:01:20,266 --> 00:01:22,366
at coming up with what you want
47
00:01:22,466 --> 00:01:24,633
what you wanna be able to show other people
48
00:01:25,266 --> 00:01:26,899
speaking of showing other people
49
00:01:26,900 --> 00:01:29,133
remember another big point that we talked about
50
00:01:29,133 --> 00:01:30,866
was making sure that someone else
51
00:01:30,866 --> 00:01:32,833
who looks at your chart or graph
52
00:01:32,866 --> 00:01:34,666
is going to be able to understand it
53
00:01:34,666 --> 00:01:36,799
and so that means adding in a lot of detail
54
00:01:36,800 --> 00:01:39,366
that Excel often doesn't put in itself
55
00:01:39,533 --> 00:01:41,466
giving the chart a good title
56
00:01:41,466 --> 00:01:42,699
if you wanna do that
57
00:01:42,900 --> 00:01:44,066
labeling the axis
58
00:01:44,066 --> 00:01:45,066
making sure the axis
59
00:01:45,066 --> 00:01:47,766
have labels that make sense to somebody else
60
00:01:47,933 --> 00:01:49,266
and include information
61
00:01:49,266 --> 00:01:51,999
on the units of the measurement variable
62
00:01:52,200 --> 00:01:53,333
including a legend
63
00:01:53,333 --> 00:01:55,066
if you have a more complicated chart
64
00:01:55,066 --> 00:01:57,466
like maybe a grouped bar chart
65
00:01:57,466 --> 00:01:59,166
or a combo chart
66
00:01:59,266 --> 00:02:01,266
all of these things are really effective
67
00:02:01,300 --> 00:02:02,666
the key thing to remember
68
00:02:02,666 --> 00:02:04,666
is that data visualizations
69
00:02:04,666 --> 00:02:05,399
like charts
70
00:02:05,400 --> 00:02:06,766
plots and graphs
71
00:02:06,966 --> 00:02:08,699
are forms of communication
72
00:02:08,700 --> 00:02:10,966
and you wanna make sure you're communicating clearly
73
00:02:11,133 --> 00:02:13,466
you've got a lot of great practice with this
74
00:02:13,466 --> 00:02:15,533
and I'm sure you can now make really great
75
00:02:15,533 --> 00:02:17,366
and effective charts and excel
76
00:02:17,700 --> 00:02:19,400
and next what we're going to be doing
77
00:02:19,400 --> 00:02:21,133
is we're gonna figure out different ways
78
00:02:21,133 --> 00:02:23,066
to get information out of our data
79
00:02:23,100 --> 00:02:25,433
by doing summaries and calculations
80
00:02:25,500 --> 00:02:28,633
this added in with your chart making expertise
81
00:02:28,700 --> 00:02:30,933
is going to give you a very powerful set of tools
82
00:02:30,933 --> 00:02:32,166
for working in Excel
5730
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.
Afrikaans
Albanian
Amharic
Arabic
Armenian
Azerbaijani
Basque
Belarusian
Bengali
Bosnian
Bulgarian
Catalan
Cebuano
Chichewa
Chinese (Simplified)
Chinese (Traditional)
Corsican
Croatian
Czech
Danish
Dutch
English
Esperanto
Estonian
Finnish
Frisian
Galician
Georgian
German
Greek
Gujarati
Haitian Creole
Hawaiian
Hungarian
Icelandic
Indonesian
Irish
Italian
Japanese
Kazakh
Khmer
Korean
Kurdish (Kurmanji)
Kyrgyz
Lao
Latvian
Lithuanian
Luxembourgish
Macedonian
Malagasy
Malay
Maltese
Maori
Mongolian
Myanmar (Burmese)
Nepali
Norwegian
Pashto
Polish
Portuguese
Romanian
Russian
Samoan
Serbian
Sesotho
Shona
Sinhala
Slovak
Slovenian
Somali
Spanish
Swahili
Swedish
Tajik
Thai
Turkish
Ukrainian
Urdu
Uzbek
Vietnamese
