subtitlecat.com

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

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

French Download

Frisian

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

Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated: 1 00:00:00,266 --> 00:00:02,999 so here we are in week three of Excel for the 99% 2 00:00:03,000 --> 00:00:03,566 and as you know 3 00:00:03,566 --> 00:00:05,066 you've already mastered a number of 4 00:00:05,066 --> 00:00:06,866 very valuable tools in Excel 5 00:00:06,866 --> 00:00:09,733 you understand spreadsheets and data in spreadsheets 6 00:00:09,733 --> 00:00:11,933 and now you know how to convert those data 7 00:00:11,933 --> 00:00:15,399 into visualizations to help communicate information 8 00:00:15,466 --> 00:00:17,433 either answering a question for yourself 9 00:00:17,500 --> 00:00:19,366 showing something to someone else 10 00:00:19,366 --> 00:00:21,299 some kind of visual summary 11 00:00:21,500 --> 00:00:22,666 that's fantastic 12 00:00:22,666 --> 00:00:25,266 you're gonna be able to do a lot just with these skills 13 00:00:25,566 --> 00:00:27,533 but there are times when we need 14 00:00:27,533 --> 00:00:29,099 additional things from our data 15 00:00:29,100 --> 00:00:30,733 sometimes a picture won't do 16 00:00:30,733 --> 00:00:33,499 sometimes we need actual numbers 17 00:00:33,500 --> 00:00:36,600 we need to know what the average value of something is 18 00:00:36,600 --> 00:00:41,666 we need to know how many people match certain criteria 19 00:00:42,133 --> 00:00:44,733 we need to know the minimum or maximum value 20 00:00:44,733 --> 00:00:46,699 for this really long range of data 21 00:00:46,700 --> 00:00:48,966 and we don't just wanna go scrolling through that 22 00:00:49,066 --> 00:00:50,799 of course there are ways to do this 23 00:00:50,800 --> 00:00:53,300 really quickly and effectively in Excel 24 00:00:53,300 --> 00:00:55,433 and that's what we're working on this week 25 00:00:55,500 --> 00:00:56,133 a lot of this 26 00:00:56,133 --> 00:00:58,599 I consider manipulating data 27 00:00:58,766 --> 00:00:59,933 manipulating data 28 00:00:59,933 --> 00:01:01,499 meaning that we need to change it 29 00:01:01,500 --> 00:01:04,800 or reshape it in some way to meet our needs sometimes 30 00:01:04,800 --> 00:01:07,133 it might just be changing the order of our data 31 00:01:07,133 --> 00:01:10,699 sorting it sometimes it may be filtering out data 32 00:01:10,700 --> 00:01:11,966 looking for data 33 00:01:11,966 --> 00:01:14,966 that match particular things we're looking for 34 00:01:15,100 --> 00:01:16,966 and then doing calculations 35 00:01:16,966 --> 00:01:19,299 using equations as we know 36 00:01:19,300 --> 00:01:21,333 and using functions built in 37 00:01:21,333 --> 00:01:22,266 functions in Excel 38 00:01:22,266 --> 00:01:23,666 which is something we're going to be doing 39 00:01:23,666 --> 00:01:25,466 for the first time this week 40 00:01:25,733 --> 00:01:27,199 these tools I think 41 00:01:27,200 --> 00:01:29,900 are some of the most valuable tools that Excel offers 42 00:01:29,900 --> 00:01:32,333 UPS and that's what we're going to be focusing on 43 00:01:32,333 --> 00:01:33,166 in this week 44 00:01:33,166 --> 00:01:35,499 it's going to be a really nice compliment to 45 00:01:35,500 --> 00:01:37,266 your plotting and charting skills 46 00:01:37,533 --> 00:01:39,933 you're soon going to have skills for summarizing 47 00:01:39,933 --> 00:01:42,366 and manipulating large amounts of data 48 00:01:42,500 --> 00:01:43,600 very quickly 49 00:01:43,600 --> 00:01:44,900 very effectively 50 00:01:45,066 --> 00:01:47,766 and almost guaranteeing that you're not going to make 51 00:01:47,766 --> 00:01:49,133 simple little errors 52 00:01:49,133 --> 00:01:51,399 that's what spreadsheet programs are for 53 00:01:51,400 --> 00:01:53,500 and that's what we're going to be doing this week 3932