All language subtitles for Topic 5 Recap and Practice Week 2 Making Charts Excel for Beginners

af Afrikaans
ak Akan
sq Albanian
am Amharic
ar Arabic
hy Armenian
az Azerbaijani
eu Basque
be Belarusian
bem Bemba
bn Bengali
bh Bihari
bs Bosnian
br Breton
bg Bulgarian
km Cambodian
ca Catalan
ceb Cebuano
chr Cherokee
ny Chichewa
zh-CN Chinese (Simplified)
zh-TW Chinese (Traditional)
co Corsican
hr Croatian
cs Czech
da Danish
nl Dutch
en English
eo Esperanto
et Estonian
ee Ewe
fo Faroese
tl Filipino
fi Finnish
fy Frisian
gaa Ga
gl Galician
ka Georgian
de German
el Greek
gn Guarani
gu Gujarati
ht Haitian Creole
ha Hausa
haw Hawaiian
iw Hebrew
hi Hindi
hmn Hmong
hu Hungarian
is Icelandic
ig Igbo
id Indonesian
ia Interlingua
ga Irish
it Italian
ja Japanese
jw Javanese
kn Kannada
kk Kazakh
rw Kinyarwanda
rn Kirundi
kg Kongo
ko Korean
kri Krio (Sierra Leone)
ku Kurdish
ckb Kurdish (Soranรฎ)
ky Kyrgyz
lo Laothian
la Latin
lv Latvian
ln Lingala
lt Lithuanian
loz Lozi
lg Luganda
ach Luo
lb Luxembourgish
mk Macedonian
mg Malagasy
ms Malay
ml Malayalam
mt Maltese
mi Maori
mr Marathi
mfe Mauritian Creole
mo Moldavian
mn Mongolian
my Myanmar (Burmese)
sr-ME Montenegrin
ne Nepali
pcm Nigerian Pidgin
nso Northern Sotho
no Norwegian
nn Norwegian (Nynorsk)
oc Occitan
or Oriya
om Oromo
ps Pashto
fa Persian
pl Polish
pt-BR Portuguese (Brazil)
pt Portuguese (Portugal)
pa Punjabi
qu Quechua
ro Romanian
rm Romansh
nyn Runyakitara
ru Russian
sm Samoan
gd Scots Gaelic
sr Serbian
sh Serbo-Croatian
st Sesotho
tn Setswana
crs Seychellois Creole
sn Shona
sd Sindhi
si Sinhalese
sk Slovak
sl Slovenian
so Somali
es Spanish
es-419 Spanish (Latin American)
su Sundanese
sw Swahili
sv Swedish
tg Tajik
ta Tamil
tt Tatar
te Telugu
th Thai
ti Tigrinya
to Tonga
lua Tshiluba
tum Tumbuka
tr Turkish
tk Turkmen
tw Twi
ug Uighur
uk Ukrainian
ur Urdu
uz Uzbek
vi Vietnamese
cy Welsh
wo Wolof
xh Xhosa
yi Yiddish
yo Yoruba
zu Zulu

Original subtitles

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.