Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:01,990 --> 00:00:08,550
One of the key strengths of Excel is the ability to manage lists of data effectively by organizing it
2
00:00:08,550 --> 00:00:10,250
into tables.
3
00:00:10,300 --> 00:00:20,210
Let us organize the data into an Excel table select say Avon on the Home tab in the styles group click
4
00:00:20,390 --> 00:00:29,290
format as table Excel displays a gallery of tables state any existing formatting remains applied to
5
00:00:29,290 --> 00:00:36,690
your data even when you create the Excel table if you want Excel to replace the existing formatting
6
00:00:37,020 --> 00:00:44,370
with the Excel stables formatting right click the table style you want to apply and then click apply
7
00:00:44,370 --> 00:00:55,110
and clear formatting let us select a table style Excel displays the format as table dialog box verify
8
00:00:55,140 --> 00:01:03,650
that the range is displayed in the vein is the data for your table feed make sure Daddy my table has
9
00:01:03,650 --> 00:01:07,680
headers checkbox is selected and then click OK.
10
00:01:09,100 --> 00:01:17,740
Excel creates an Excel table from your data and displays the design contextual tab to access more features
11
00:01:17,740 --> 00:01:26,460
for the table click the design contextual that you can remove duplicates from your table you can select
12
00:01:26,460 --> 00:01:36,000
the checkbox for banded columns and you can do many other things from this design contextual step to
13
00:01:36,000 --> 00:01:45,970
add a new row of data in your Excel table simplify the data and press that key let us type January press
14
00:01:45,980 --> 00:02:02,970
tab 5 5 6 5 0 and press tab 5 5 6 5 0 0 and then press enter you can see that the new raw data is included
15
00:02:02,970 --> 00:02:09,780
in the acceptable you can also select a cell in the row immediately below the last row in the table
16
00:02:10,470 --> 00:02:17,330
or a cell in the column immediately to the right of the table and then type of value into the cell
17
00:02:20,580 --> 00:02:28,170
the auto correct options action but we will appear as soon as you type the data if you do not want to
18
00:02:28,170 --> 00:02:37,310
include the data in the Excel table you can click on the table or expansion to exclude the cells from
19
00:02:37,310 --> 00:02:46,220
the Excel table if you never want Excel to include a decent data in an Excel table again click stop
20
00:02:46,280 --> 00:02:55,170
automatically expanding tables you can also add rows and columns to an Excel table or remove them from
21
00:02:55,170 --> 00:03:03,480
an Excel table by dragging the size handle at the Excel tables lower right corner you can increase the
22
00:03:03,480 --> 00:03:10,940
number of columns or decrease the number of columns you can increase the number of rows or decrease
23
00:03:10,940 --> 00:03:11,960
the number of rows.
2986
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.
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
Faroese
Finnish
Galician
Georgian
German
Greek
Guarani
Haitian Creole
Hausa
Hawaiian
Hebrew
Hmong
Hungarian
Icelandic
Indonesian
Irish
Italian
Japanese
Kazakh
Kinyarwanda
Kirundi
Kongo
Korean
Krio (Sierra Leone)
Kurdish
Kyrgyz
Laothian
Latin
Latvian
Lithuanian
Luganda
Luo
Luxembourgish
Macedonian
Malagasy
Malay
Maltese
Maori
Mauritian Creole
Moldavian
Mongolian
Myanmar (Burmese)
Montenegrin
Nepali
Norwegian
Pashto
Persian
Polish
Portuguese (Brazil)
Quechua
Romanian
Romansh
Russian
Samoan
Scots Gaelic
Serbian
Sesotho
Setswana
Seychellois Creole
Shona
Sindhi
Sinhalese
Slovak
Slovenian
Somali
Spanish
Swedish
Tajik
Thai
Tigrinya
Tonga
Turkish
Turkmen
Ukrainian
Uzbek
Vietnamese
Welsh
Wolof