However, one and today you are going to discuss and new topic about Microsoft Excel.
We are going to discuss Phil Phil..
So the objectives are self-help and self-help types, vertical and horizontal self-help and knowing
how Phil?
Well, Phil, can be used for numbers, Dexters formulas and functions.
Also, Phil can be directed as vertically from top to down or bottom to up, also can be dragged horizontally
from right to left or left to right.
OK, also Phil can be directed as dragged or autofill.
OK, let's go practically to our Excel sheet so we can fill numbers by selecting this number and waiting
for the Black Cross sign and drag.
And you see that there is a serious here, one, two, three, four, five, six, seven, eight, nine
and so on.
If you continue dragging, the series will be complete as you stop, OK?
Also, you can't drag text if you want to drag this ticket, just select the these cells and drag the
thickest will be dragged as numbers.
Also, you can't drag formula if you have this formula and this formula is today, you can drag this
formula by, select the formula and drag it.
OK.
Also you can just click click on this Black Cross to complete the drag, whatever you want.
Also, if you have a function such as this cell reference, be seven multiplied by two and this function
and you want to drag this function.
You select the function and drag the function, and accordingly the function will be repeated to multiply
the next value.
OK, the next value.
The next value.
OK, and you can also stand here and click on the.
Black Cross to make automatically drag without dragging like that.
OK, so if you delete it and just stand on the cell and stand here to show the Black Cross and click
on this Black Cross like that, you will have to magically drag to this formula.
And any one of these are repeated formula from this reference multiplied by two.
Also, you can change this formula by adding, for example, plus one and drag it again to be changed
automatically.
OK.
Well, we have learned to drag numbers, drag teguest drag formula, drag function, also drag can be
horizontally if you have one and this the next still is three.
And you want to keep the serious, just select one and three, these two cells and rake.
You will find these value are increased in the same pattern of the first two cells, so five is increased
by two and increased by two and increased by two and so on.
Also another example, if you have this one and Nick, it still is 100 and you want to keep this pattern
on just to drag these two cells.
So the next will be increased by 99 and that fourth will be increased by also the same value line tonight
and so on.
Also.
Let's take more example, if you have this serious, OK, and you want to drag these two values, what
are the common serious will be increased by only one like that, three, four, five, six and so on.
Also, if you have only one value and you want to use felt to see the result of this value, just drop
it.
You can read this value, whatever you want, OK?
Also, if you have this value zero.
And the second value is, too, and we are selecting these two cells, what are the next series?
The next series will be increased by Coniston, incremental by two.
So this is the result.
Four, six, eight, incremental by two, then increased by two one increased by two 14 and so on.
Also if you have a tourists and you want to useful, you can keep the areas increasing by one.
So twenty eight become twenty nine.
So the next cell will be 30 and so on.
Let's try 30 and if you complete dragging you will find we have a next time and the next month here
we have a next year.
Drag this series to keep all dates you want to do.
OK, also for weekdays you can only use drag and felt to complete the week days like that.
OK, OK, according to film format, you can also repeat format by selecting the sell and drag down.
So you're beat two things.
The first thing is format.
The second thing is a series of number one, two, three, four, five and so on.
Also, you can control this option by clicking in this down arrow.
You can only copy.
You can only fill serious.
You can only fill formating only.
You can only fail without formatting.
You can only use flash felt.
OK, OK.
Also, if you want to use fell from tap from home, you will find Phil here to select down, right,
up, left, serious flush, Phil justify and so on.
So let's summarize this lecture.
You can use film to repeat numbers or text or formula or functions like that, you can only use film
to vertically top down or you can also use film to bottom up.
Also, you can't use film from right to left or from left to right.
Also, you can make serious by using film if you want to have serious one, four and so on and keep
this button.
Just drag this series.
OK.
Also you can't use fail to repeat and make continuous dating.
Also you can use to make continuous a time line by just drag that dates.
Also you can use fell by completing weekdays by dragging for the weekdays such as Sunday, Monday and
so on.
Also you can use a failed format to keep formatting and repeat formatting like that.
This is about Phil and Phil, if you have any question, just contact us.
Thank you.
And see you in the next lecture.