All language subtitles for 1Week 3 Introduction Week 3 Manipulating & Summarizing Data U

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

so here we are in week three of Excel for the 99%

and as you know

you've already mastered a number of

very valuable tools in Excel

you understand spreadsheets and data in spreadsheets

and now you know how to convert those data

into visualizations to help communicate information

either answering a question for yourself

showing something to someone else

some kind of visual summary

that's fantastic

you're gonna be able to do a lot just with these skills

but there are times when we need

additional things from our data

sometimes a picture won't do

sometimes we need actual numbers

we need to know what the average value of something is

we need to know how many people match certain criteria

we need to know the minimum or maximum value

for this really long range of data

and we don't just wanna go scrolling through that

of course there are ways to do this

really quickly and effectively in Excel

and that's what we're working on this week

a lot of this

I consider manipulating data

manipulating data

meaning that we need to change it

or reshape it in some way to meet our needs sometimes

it might just be changing the order of our data

sorting it sometimes it may be filtering out data

looking for data

that match particular things we're looking for

and then doing calculations

using equations as we know

and using functions built in

functions in Excel

which is something we're going to be doing

for the first time this week

these tools I think

are some of the most valuable tools that Excel offers

UPS and that's what we're going to be focusing on

in this week

it's going to be a really nice compliment to

your plotting and charting skills

you're soon going to have skills for summarizing

and manipulating large amounts of data

very quickly

very effectively

and almost guaranteeing that you're not going to make

simple little errors

that's what spreadsheet programs are for

and that's what we're going to be doing this week

Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.