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.