Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:01,220 --> 00:00:08,540
In this video you will learn how to enter data in an efficient manner by you can start entering data
2
00:00:08,570 --> 00:00:13,820
anywhere in the world cheat simply by clicking on the cell and typing.
3
00:00:13,820 --> 00:00:21,420
You would need to be more organized when entering large data or if you want to analyze your data.
4
00:00:21,450 --> 00:00:26,340
Think about what information you are going to store and how you are going to use it.
5
00:00:27,450 --> 00:00:33,750
Let us insert a new worksheet in monthly sales data log book for a new city San Francisco
6
00:00:38,420 --> 00:00:39,140
let us type.
7
00:00:39,140 --> 00:00:42,320
Column header month.
8
00:00:42,430 --> 00:00:48,070
One way to enter the month is to type from January to December.
9
00:00:48,430 --> 00:00:50,720
But this is tedious work.
10
00:00:50,800 --> 00:00:59,350
Instead we can use auto fill or bus will automatically face a series of sales with a series of data
11
00:01:00,720 --> 00:01:01,200
you enter.
12
00:01:01,200 --> 00:01:09,830
The first element in the cities for example January click and hold the most button down on the full
13
00:01:09,830 --> 00:01:10,620
handle.
14
00:01:10,820 --> 00:01:18,800
At the lower right corner of the cell and drag the full handle until the city's extends far enough to
15
00:01:18,800 --> 00:01:21,440
accommodate your data.
16
00:01:21,460 --> 00:01:31,810
In that case the rest of the month you can use another tool fill S.D. to enter two values in a cities
17
00:01:32,110 --> 00:01:36,810
and use the full handle to complete the cities in your voce.
18
00:01:36,910 --> 00:01:45,610
For example if you want to create a city's starting at 1 and increasing by 2 you put one in the first
19
00:01:45,610 --> 00:01:48,220
cell and 3 in the second set.
20
00:01:48,700 --> 00:01:58,060
Select both cells and then use the full handle to extend the cities to your desired end value.
21
00:01:59,700 --> 00:02:07,510
You can also copy values for example if you type 1 in the for sale and 3 in the second sale.
22
00:02:07,650 --> 00:02:11,560
Select both cells and then use fill handle.
23
00:02:11,790 --> 00:02:15,300
Click the plus sign and select copy cells.
24
00:02:16,200 --> 00:02:23,350
If you also hold down the control key while you drag the full header to fill the city's values Excel
25
00:02:23,350 --> 00:02:31,180
will copy values instead of extending cities another feature of Excel is auto complete.
26
00:02:32,730 --> 00:02:40,050
When you type the first few letters in a cell for example G A Excel suggests a value.
27
00:02:40,050 --> 00:02:44,070
If a similar value exists in the same column.
28
00:02:44,070 --> 00:02:46,470
Notice that it displaced and.
29
00:02:46,560 --> 00:02:54,770
You can press and tell autarky to accepted if you want to enter the same value in a range of cells.
30
00:02:54,870 --> 00:03:05,490
Then select the cell range type the data in the active cell for example 5 3 1 4 and press control plus
31
00:03:05,550 --> 00:03:08,760
enter to copy the value to the entire range.
3249
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.