Afrikaans
Akan
Albanian
Amharic
Arabic
Armenian
Azerbaijani
Basque
Belarusian
Bemba
Bengali
Bihari
Bosnian
Breton
Bulgarian
Cambodian
Catalan
Cebuano
Cherokee
Chichewa
Chinese (Simplified)
Chinese (Traditional)
Corsican
Croatian
Czech
Danish
Dutch
English
Esperanto
Estonian
Ewe
Faroese
Filipino
Finnish
Frisian
Ga
Galician
Georgian
German
Greek
Guarani
Gujarati
Haitian Creole
Hausa
Hawaiian
Hebrew
Hindi
Hmong
Hungarian
Icelandic
Igbo
Indonesian
Interlingua
Irish
Italian
Japanese
Javanese
Kannada
Kazakh
Kinyarwanda
Kirundi
Kongo
Korean
Krio (Sierra Leone)
Kurdish
Kurdish (Soranรฎ)
Kyrgyz
Laothian
Latin
Latvian
Lingala
Lithuanian
Lozi
Luganda
Luo
Luxembourgish
Macedonian
Malagasy
Malay
Malayalam
Maltese
Maori
Marathi
Mauritian Creole
Moldavian
Mongolian
Myanmar (Burmese)
Montenegrin
Nepali
Nigerian Pidgin
Northern Sotho
Norwegian
Norwegian (Nynorsk)
Occitan
Oriya
Oromo
Pashto
Persian
Polish
Portuguese (Brazil)
Portuguese (Portugal)
Punjabi
Quechua
Romanian
Romansh
Runyakitara
Russian
Samoan
Scots Gaelic
Serbian
Serbo-Croatian
Sesotho
Setswana
Seychellois Creole
Shona
Sindhi
Sinhalese
Slovak
Slovenian
Somali
Spanish
Spanish (Latin American)
Sundanese
Swahili
Swedish
Tajik
Tamil
Tatar
Telugu
Thai
Tigrinya
Tonga
Tshiluba
Tumbuka
Turkish
Turkmen
Twi
Uighur
Ukrainian
Urdu
Uzbek
Vietnamese
Welsh
Wolof
Xhosa
Yiddish
Yoruba
Zulu
congratulations
you finished
your second week worth of material in Excel
for the 99%
and as you know
you just got a lot of practice
making charts and plots in Excel
let's do a quick recap of some of our key
points that we Learned this week
this will help us as we move on
remembering the details
you can look those up
but remembering the key principles
of making charts in Excel
is what's really going to benefit you in the long run
first of all
you probably know at this point
I'm gonna tell you
that the most important thing
is to think carefully about what question
you want to answer with a chart
or what point you want to make
you are going to be the best judge of that
and so thinking deeply about that's going to be
really critical
do you wanna compare some variable of interest
across different categories
like we do in a bar column chart
do you wanna see how two variables
are related to each other
like in a scatter plot
or do you wanna understand
how different parts make up a hole
like a part of pie chart
or a stacked column chart
those kinds of questions are the things to ask yourself
before you start making graphs in Excel
and remember
Excel can give you recommendations
with the recommended charts feature
but those aren't always going to match your goal
so think about your goal
then look at the recommended charts
those two things together
can be really effective
at coming up with what you want
what you wanna be able to show other people
speaking of showing other people
remember another big point that we talked about
was making sure that someone else
who looks at your chart or graph
is going to be able to understand it
and so that means adding in a lot of detail
that Excel often doesn't put in itself
giving the chart a good title
if you wanna do that
labeling the axis
making sure the axis
have labels that make sense to somebody else
and include information
on the units of the measurement variable
including a legend
if you have a more complicated chart
like maybe a grouped bar chart
or a combo chart
all of these things are really effective
the key thing to remember
is that data visualizations
like charts
plots and graphs
are forms of communication
and you wanna make sure you're communicating clearly
you've got a lot of great practice with this
and I'm sure you can now make really great
and effective charts and excel
and next what we're going to be doing
is we're gonna figure out different ways
to get information out of our data
by doing summaries and calculations
this added in with your chart making expertise
is going to give you a very powerful set of tools
for working in Excel
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.