Original subtitles

In this video you will learn how to enter data in an efficient manner by you can start entering data

anywhere in the world cheat simply by clicking on the cell and typing.

You would need to be more organized when entering large data or if you want to analyze your data.

Think about what information you are going to store and how you are going to use it.

Let us insert a new worksheet in monthly sales data log book for a new city San Francisco

let us type.

Column header month.

One way to enter the month is to type from January to December.

But this is tedious work.

Instead we can use auto fill or bus will automatically face a series of sales with a series of data

you enter.

The first element in the cities for example January click and hold the most button down on the full

handle.

At the lower right corner of the cell and drag the full handle until the city's extends far enough to

accommodate your data.

In that case the rest of the month you can use another tool fill S.D. to enter two values in a cities

and use the full handle to complete the cities in your voce.

For example if you want to create a city's starting at 1 and increasing by 2 you put one in the first

cell and 3 in the second set.

Select both cells and then use the full handle to extend the cities to your desired end value.

You can also copy values for example if you type 1 in the for sale and 3 in the second sale.

Select both cells and then use fill handle.

Click the plus sign and select copy cells.

If you also hold down the control key while you drag the full header to fill the city's values Excel

will copy values instead of extending cities another feature of Excel is auto complete.

When you type the first few letters in a cell for example G A Excel suggests a value.

If a similar value exists in the same column.

Notice that it displaced and.

You can press and tell autarky to accepted if you want to enter the same value in a range of cells.

Then select the cell range type the data in the active cell for example 5 3 1 4 and press control plus

enter to copy the value to the entire range.