Module 2 - End of Module Project 1 #part1

1 00:00:00,060 --> 00:00:04,020 all right so this is the module 2 of the

2 00:00:02,340 --> 00:00:06,839 project one and in this video we will

3 00:00:04,020 --> 00:00:09,420 cover in steps from one through five so

4 00:00:06,839 --> 00:00:12,120 firstly it is saying that it is a loan

5 00:00:09,420 --> 00:00:14,880 officer of the is adding formatting

6 00:00:12,120 --> 00:00:16,920 unless he used the tracking registered

7 00:00:14,880 --> 00:00:19,500 change the theme of the workbook to

8 00:00:16,920 --> 00:00:21,960 office so let's change the theme of the

9 00:00:19,500 --> 00:00:24,779 workbook so for this we should go to the

10 00:00:21,960 --> 00:00:26,340 page layout tab in these themes and we

11 00:00:24,779 --> 00:00:28,920 should click on the drop down and drop

12 00:00:26,340 --> 00:00:32,099 down menu here is the different themes

13 00:00:28,920 --> 00:00:33,500 so we are told to select office theme

14 00:00:32,099 --> 00:00:36,239 so

15 00:00:33,500 --> 00:00:38,100 number one is done so let's go to the

16 00:00:36,239 --> 00:00:39,840 step two switch to the mortgage

17 00:00:38,100 --> 00:00:43,140 worksheet okay

18 00:00:39,840 --> 00:00:46,140 we switched and then format The Heading

19 00:00:43,140 --> 00:00:50,700 merge and center the range A1 through D1

20 00:00:46,140 --> 00:00:54,000 so A1 I hold the shift shift key and

21 00:00:50,700 --> 00:00:55,860 then click Mouse at D1 so it will select

22 00:00:54,000 --> 00:00:59,160 all or you can just click here and drag

23 00:00:55,860 --> 00:01:01,860 your mouse through D1 uh apply FM

24 00:00:59,160 --> 00:01:04,440 heading cell style to the most cell so

25 00:01:01,860 --> 00:01:07,080 it is saying Mars and Center

26 00:01:04,440 --> 00:01:09,299 so let's go to the Home tab and there is

27 00:01:07,080 --> 00:01:12,180 a merge and center option and it is

28 00:01:09,299 --> 00:01:16,860 saying who is heading

29 00:01:12,180 --> 00:01:20,280 uh EFM FM heading cell Style

30 00:01:16,860 --> 00:01:23,700 so we can find our Styles here and it is

31 00:01:20,280 --> 00:01:26,299 saying FM heading cell Styles Outlet so

32 00:01:23,700 --> 00:01:26,299 this is done

33 00:01:28,020 --> 00:01:34,259 now margins enter the range A2 through

34 00:01:30,780 --> 00:01:37,640 D2 so A2

35 00:01:34,259 --> 00:01:37,640 through D2

36 00:01:42,439 --> 00:01:50,360 and then apply the saw baiting styles

37 00:01:46,140 --> 00:01:50,360 so this is the solving

38 00:01:50,399 --> 00:01:55,439 uh so let's go to the step 4 format the

39 00:01:52,799 --> 00:01:59,939 effective date information for range A4

40 00:01:55,439 --> 00:02:02,040 through B4 so A4

41 00:01:59,939 --> 00:02:05,219 through B4

42 00:02:02,040 --> 00:02:07,020 apply the node cell Style

43 00:02:05,219 --> 00:02:08,700 let's see it must be somewhere around

44 00:02:07,020 --> 00:02:10,700 here

45 00:02:08,700 --> 00:02:10,700 um

46 00:02:11,640 --> 00:02:15,959 oh here is the node cell star

47 00:02:14,340 --> 00:02:18,599 all right

48 00:02:15,959 --> 00:02:20,760 and then it is saying for the cell A4

49 00:02:18,599 --> 00:02:23,760 apply italic to the text and online

50 00:02:20,760 --> 00:02:27,540 right so A4

51 00:02:23,760 --> 00:02:28,620 apply the italic Style

52 00:02:27,540 --> 00:02:31,080 um

53 00:02:28,620 --> 00:02:34,739 and then align to the right so we should

54 00:02:31,080 --> 00:02:35,879 just click click here or online right

55 00:02:34,739 --> 00:02:38,340 here

56 00:02:35,879 --> 00:02:40,620 I did here this this will convertation

57 00:02:38,340 --> 00:02:42,959 to the italics and then here it will

58 00:02:40,620 --> 00:02:45,019 take to the right

59 00:02:42,959 --> 00:02:49,620 and

60 00:02:45,019 --> 00:02:53,220 then it is saying for the cell B4

61 00:02:49,620 --> 00:02:56,040 okay change the change the date format

62 00:02:53,220 --> 00:02:59,040 to day dash month Dash here so for this

63 00:02:56,040 --> 00:03:01,080 uh we can see here normal group just

64 00:02:59,040 --> 00:03:05,160 click in this

65 00:03:01,080 --> 00:03:08,340 next one icon and then drag down drag

66 00:03:05,160 --> 00:03:10,920 down and here is our required format

67 00:03:08,340 --> 00:03:13,200 so just hit OK and it is done already

68 00:03:10,920 --> 00:03:15,120 towards the end of the video so these

69 00:03:13,200 --> 00:03:17,819 are finalists format the mortgage rate

70 00:03:15,120 --> 00:03:21,120 table for the heading in A6 through D6

71 00:03:17,819 --> 00:03:26,099 Center and bold the text so firstly

72 00:03:21,120 --> 00:03:28,800 let's do that A6 through D6

73 00:03:26,099 --> 00:03:29,640 Premiere we can Center the text and hold

74 00:03:28,800 --> 00:03:32,300 it

75 00:03:29,640 --> 00:03:35,819 after that it is saying

76 00:03:32,300 --> 00:03:40,319 then change the font color to blue gray

77 00:03:35,819 --> 00:03:44,840 text to Fourth column of first row so

78 00:03:40,319 --> 00:03:44,840 fourth column of first row

79 00:03:45,360 --> 00:03:53,659 so this is one two three four fourth

80 00:03:50,159 --> 00:03:53,659 column of first row

81 00:03:53,819 --> 00:04:01,319 okay this this will be good this will be

82 00:03:57,780 --> 00:04:04,440 our recorder fourth column first stroke

83 00:04:01,319 --> 00:04:06,299 and more than Center the range is 7

84 00:04:04,440 --> 00:04:09,739 through A9

85 00:04:06,299 --> 00:04:09,739 so A7

86 00:04:10,980 --> 00:04:14,900 through a nine

87 00:04:18,900 --> 00:04:21,859 margin Center

88 00:04:24,540 --> 00:04:28,440 so yeah that's it that's it for this

89 00:04:26,699 --> 00:04:33,740 step 5 we will continue from the next

90 00:04:28,440 --> 00:04:33,740 step in another video so yeah thank you