All language subtitles for 3Topic 1-2 Excel Orientation and Spreadsheet Basics Week 1 Gett-1

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
fr French Download
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
Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated: 1 00:00:01,866 --> 00:00:02,666 now that we're comfortable 2 00:00:02,666 --> 00:00:04,266 the general layout of Excel 3 00:00:04,300 --> 00:00:07,700 understanding cells and how we refer to cells 4 00:00:07,700 --> 00:00:08,733 cell referencing 5 00:00:08,733 --> 00:00:09,966 or sell addresses 6 00:00:09,966 --> 00:00:11,699 is relatively straightforward 7 00:00:12,333 --> 00:00:14,166 it helps to think of a spreadsheet 8 00:00:14,166 --> 00:00:17,466 as a series of intersecting columns and rows 9 00:00:17,500 --> 00:00:20,500 which we can see here by different labeling 10 00:00:20,533 --> 00:00:22,966 we have columns that are labeled with letters 11 00:00:22,966 --> 00:00:25,033 like this column B right here 12 00:00:25,300 --> 00:00:27,566 we have rows that are labeled with numbers 13 00:00:27,566 --> 00:00:31,833 like row 2 right here together 14 00:00:32,066 --> 00:00:36,233 these two pieces of information make up a coordinate 15 00:00:36,333 --> 00:00:38,633 which tells us a cell's address 16 00:00:38,733 --> 00:00:42,299 which is also called the cell reference for that cell 17 00:00:42,533 --> 00:00:43,799 so here you can see 18 00:00:43,800 --> 00:00:46,066 I've clicked on cell B2 19 00:00:46,333 --> 00:00:47,999 we can come up with that by ourselves 20 00:00:48,000 --> 00:00:51,066 just by looking at the column and looking at the row 21 00:00:51,133 --> 00:00:52,833 and seeing that we're in B2 22 00:00:52,866 --> 00:00:56,633 but we can also refer to the name box here 23 00:00:56,766 --> 00:00:59,066 to see any particular cells 24 00:00:59,066 --> 00:01:00,899 address that we've clicked on 25 00:01:03,966 --> 00:01:05,499 by clicking and dragging 26 00:01:05,500 --> 00:01:08,466 we can also highlight a range of cells 27 00:01:09,400 --> 00:01:11,600 a group of consecutive cells like this 28 00:01:11,600 --> 00:01:12,966 is called a range 29 00:01:13,466 --> 00:01:15,399 we refer to a range of cells 30 00:01:15,400 --> 00:01:17,500 by the beginning cell and end cell 31 00:01:17,500 --> 00:01:20,400 and so we would say that this range within column B 32 00:01:20,966 --> 00:01:24,266 is B2 to B eight 33 00:01:24,266 --> 00:01:26,699 and usually we would include a colon in there 34 00:01:26,700 --> 00:01:28,566 and so would be B2 colon 35 00:01:28,566 --> 00:01:32,466 B8 colon for a single column range like this 36 00:01:32,933 --> 00:01:34,866 we can also have a two dimensional range 37 00:01:34,866 --> 00:01:39,266 where we have more than one row or column in which case 38 00:01:39,266 --> 00:01:44,199 we refer to that range by the upper left cell B2 39 00:01:44,866 --> 00:01:47,499 and the lower right cell C8 40 00:01:47,500 --> 00:01:50,266 so we would say that this collection of cells 41 00:01:50,333 --> 00:01:54,099 is cell range B2 to C8 42 00:01:54,100 --> 00:01:55,500 again with a colon 43 00:01:56,133 --> 00:01:57,399 you'll notice in the name box 44 00:01:57,400 --> 00:02:00,100 that we still only have one cell reference here 45 00:02:00,100 --> 00:02:01,333 one cell address 46 00:02:01,333 --> 00:02:03,899 that's always gonna show us the cell that's highlighted 47 00:02:03,900 --> 00:02:06,533 the cell the cell that was originally clicked on 48 00:02:06,533 --> 00:02:09,766 even though we dragged through and created this range 49 00:02:11,333 --> 00:02:14,899 again this information is important because later on 50 00:02:14,900 --> 00:02:18,066 we need to refer to other cells when we're making plots 51 00:02:18,066 --> 00:02:19,766 we need to refer to other cells 52 00:02:19,766 --> 00:02:22,699 when we're making calculations and data summaries 53 00:02:23,566 --> 00:02:25,999 and so when we move into more advanced topics 54 00:02:26,000 --> 00:02:29,000 we'll revisit this topic of cell referencing 55 00:02:29,000 --> 00:02:30,566 to learn some more detail 56 00:02:30,666 --> 00:02:31,566 but for right now 57 00:02:31,566 --> 00:02:34,266 this is all we need to know to get started with Excel 4266

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