1 00:00:14,150 --> 00:00:20,610 However, one and today you are going to discuss and new topic about Microsoft Excel. 2 00:00:21,170 --> 00:00:24,470 We are going to discuss Phil Phil.. 3 00:00:25,070 --> 00:00:34,760 So the objectives are self-help and self-help types, vertical and horizontal self-help and knowing 4 00:00:34,770 --> 00:00:35,720 how Phil? 5 00:00:37,220 --> 00:00:43,850 Well, Phil, can be used for numbers, Dexters formulas and functions. 6 00:00:44,300 --> 00:00:56,900 Also, Phil can be directed as vertically from top to down or bottom to up, also can be dragged horizontally 7 00:00:57,980 --> 00:01:00,990 from right to left or left to right. 8 00:01:01,010 --> 00:01:05,300 OK, also Phil can be directed as dragged or autofill. 9 00:01:05,660 --> 00:01:18,590 OK, let's go practically to our Excel sheet so we can fill numbers by selecting this number and waiting 10 00:01:18,590 --> 00:01:22,280 for the Black Cross sign and drag. 11 00:01:27,400 --> 00:01:35,050 And you see that there is a serious here, one, two, three, four, five, six, seven, eight, nine 12 00:01:35,920 --> 00:01:36,790 and so on. 13 00:01:36,970 --> 00:01:43,130 If you continue dragging, the series will be complete as you stop, OK? 14 00:01:43,900 --> 00:01:53,740 Also, you can't drag text if you want to drag this ticket, just select the these cells and drag the 15 00:01:53,740 --> 00:01:57,640 thickest will be dragged as numbers. 16 00:01:57,670 --> 00:02:05,950 Also, you can't drag formula if you have this formula and this formula is today, you can drag this 17 00:02:05,950 --> 00:02:08,990 formula by, select the formula and drag it. 18 00:02:10,180 --> 00:02:10,540 OK. 19 00:02:11,090 --> 00:02:21,550 Also you can just click click on this Black Cross to complete the drag, whatever you want. 20 00:02:23,200 --> 00:02:31,240 Also, if you have a function such as this cell reference, be seven multiplied by two and this function 21 00:02:31,240 --> 00:02:34,330 and you want to drag this function. 22 00:02:39,020 --> 00:02:48,320 You select the function and drag the function, and accordingly the function will be repeated to multiply 23 00:02:48,320 --> 00:02:49,380 the next value. 24 00:02:49,490 --> 00:02:51,080 OK, the next value. 25 00:02:51,260 --> 00:02:52,430 The next value. 26 00:02:52,610 --> 00:02:57,920 OK, and you can also stand here and click on the. 27 00:02:59,810 --> 00:03:06,830 Black Cross to make automatically drag without dragging like that. 28 00:03:07,010 --> 00:03:20,240 OK, so if you delete it and just stand on the cell and stand here to show the Black Cross and click 29 00:03:20,240 --> 00:03:28,640 on this Black Cross like that, you will have to magically drag to this formula. 30 00:03:29,210 --> 00:03:37,040 And any one of these are repeated formula from this reference multiplied by two. 31 00:03:37,680 --> 00:03:47,260 Also, you can change this formula by adding, for example, plus one and drag it again to be changed 32 00:03:47,270 --> 00:03:47,990 automatically. 33 00:03:48,440 --> 00:03:48,920 OK. 34 00:03:50,690 --> 00:03:59,390 Well, we have learned to drag numbers, drag teguest drag formula, drag function, also drag can be 35 00:03:59,870 --> 00:04:05,420 horizontally if you have one and this the next still is three. 36 00:04:05,750 --> 00:04:12,710 And you want to keep the serious, just select one and three, these two cells and rake. 37 00:04:14,920 --> 00:04:25,120 You will find these value are increased in the same pattern of the first two cells, so five is increased 38 00:04:25,120 --> 00:04:29,290 by two and increased by two and increased by two and so on. 39 00:04:30,310 --> 00:04:38,480 Also another example, if you have this one and Nick, it still is 100 and you want to keep this pattern 40 00:04:38,500 --> 00:04:41,560 on just to drag these two cells. 41 00:04:43,580 --> 00:04:54,500 So the next will be increased by 99 and that fourth will be increased by also the same value line tonight 42 00:04:54,500 --> 00:04:55,130 and so on. 43 00:04:55,460 --> 00:04:56,030 Also. 44 00:04:58,060 --> 00:05:09,490 Let's take more example, if you have this serious, OK, and you want to drag these two values, what 45 00:05:09,490 --> 00:05:18,970 are the common serious will be increased by only one like that, three, four, five, six and so on. 46 00:05:19,990 --> 00:05:30,220 Also, if you have only one value and you want to use felt to see the result of this value, just drop 47 00:05:30,400 --> 00:05:30,620 it. 48 00:05:32,050 --> 00:05:35,690 You can read this value, whatever you want, OK? 49 00:05:36,370 --> 00:05:39,310 Also, if you have this value zero. 50 00:05:39,310 --> 00:05:46,720 And the second value is, too, and we are selecting these two cells, what are the next series? 51 00:05:46,930 --> 00:05:52,070 The next series will be increased by Coniston, incremental by two. 52 00:05:52,510 --> 00:05:54,760 So this is the result. 53 00:05:55,180 --> 00:06:04,120 Four, six, eight, incremental by two, then increased by two one increased by two 14 and so on. 54 00:06:04,960 --> 00:06:11,890 Also if you have a tourists and you want to useful, you can keep the areas increasing by one. 55 00:06:12,610 --> 00:06:16,010 So twenty eight become twenty nine. 56 00:06:16,120 --> 00:06:19,230 So the next cell will be 30 and so on. 57 00:06:20,020 --> 00:06:29,560 Let's try 30 and if you complete dragging you will find we have a next time and the next month here 58 00:06:29,890 --> 00:06:31,300 we have a next year. 59 00:06:32,050 --> 00:06:38,770 Drag this series to keep all dates you want to do. 60 00:06:38,920 --> 00:06:51,480 OK, also for weekdays you can only use drag and felt to complete the week days like that. 61 00:06:53,550 --> 00:07:05,010 OK, OK, according to film format, you can also repeat format by selecting the sell and drag down. 62 00:07:05,970 --> 00:07:07,780 So you're beat two things. 63 00:07:07,920 --> 00:07:10,190 The first thing is format. 64 00:07:10,470 --> 00:07:16,410 The second thing is a series of number one, two, three, four, five and so on. 65 00:07:18,420 --> 00:07:24,440 Also, you can control this option by clicking in this down arrow. 66 00:07:25,080 --> 00:07:26,160 You can only copy. 67 00:07:29,200 --> 00:07:31,480 You can only fill serious. 68 00:07:34,170 --> 00:07:37,890 You can only fill formating only. 69 00:07:40,400 --> 00:07:43,310 You can only fail without formatting. 70 00:07:46,460 --> 00:07:49,070 You can only use flash felt. 71 00:07:51,560 --> 00:07:52,940 OK, OK. 72 00:07:54,340 --> 00:08:04,660 Also, if you want to use fell from tap from home, you will find Phil here to select down, right, 73 00:08:04,660 --> 00:08:09,400 up, left, serious flush, Phil justify and so on. 74 00:08:10,540 --> 00:08:12,730 So let's summarize this lecture. 75 00:08:13,680 --> 00:08:25,170 You can use film to repeat numbers or text or formula or functions like that, you can only use film 76 00:08:25,230 --> 00:08:34,530 to vertically top down or you can also use film to bottom up. 77 00:08:35,490 --> 00:08:44,260 Also, you can't use film from right to left or from left to right. 78 00:08:44,850 --> 00:08:53,880 Also, you can make serious by using film if you want to have serious one, four and so on and keep 79 00:08:53,880 --> 00:08:54,630 this button. 80 00:08:54,750 --> 00:08:57,360 Just drag this series. 81 00:08:57,990 --> 00:08:58,380 OK. 82 00:08:59,100 --> 00:09:06,070 Also you can't use fail to repeat and make continuous dating. 83 00:09:08,440 --> 00:09:17,230 Also you can use to make continuous a time line by just drag that dates. 84 00:09:18,380 --> 00:09:30,390 Also you can use fell by completing weekdays by dragging for the weekdays such as Sunday, Monday and 85 00:09:30,390 --> 00:09:30,810 so on. 86 00:09:31,380 --> 00:09:39,030 Also you can use a failed format to keep formatting and repeat formatting like that. 87 00:09:40,820 --> 00:09:46,820 This is about Phil and Phil, if you have any question, just contact us. 88 00:09:47,210 --> 00:09:47,940 Thank you. 89 00:09:47,960 --> 00:09:49,940 And see you in the next lecture.