Module 1 - End of Module Project 1 #Part2

1 00:00:00,000 --> 00:00:05,220 all right continuing from the step 6

2 00:00:02,220 --> 00:00:06,899 this is the first project module one so

3 00:00:05,220 --> 00:00:08,820 it is saying it's a switch to the

4 00:00:06,899 --> 00:00:11,160 scheduling Mark 6 so we are in the same

5 00:00:08,820 --> 00:00:13,920 worksheet in the cell A3 in the cell

6 00:00:11,160 --> 00:00:15,000 content of these instead of this all

7 00:00:13,920 --> 00:00:18,480 right

8 00:00:15,000 --> 00:00:21,960 let's copy it Ctrl C or you can just

9 00:00:18,480 --> 00:00:25,140 right click and select copy and select

10 00:00:21,960 --> 00:00:27,359 this cell and if we do paste Ctrl V or

11 00:00:25,140 --> 00:00:29,119 right click and select paste it will

12 00:00:27,359 --> 00:00:32,700 mess up the styling so instead of that

13 00:00:29,119 --> 00:00:35,100 I'll do Ctrl G so instead of that just

14 00:00:32,700 --> 00:00:37,020 click on the cell and then go in this

15 00:00:35,100 --> 00:00:40,079 bar and then paste here so it will

16 00:00:37,020 --> 00:00:41,820 preserve our styling uh so what happened

17 00:00:40,079 --> 00:00:43,520 to this

18 00:00:41,820 --> 00:00:47,219 wow

19 00:00:43,520 --> 00:00:49,800 we need more text all right it is fixed

20 00:00:47,219 --> 00:00:53,820 so let's call the content and formatting

21 00:00:49,800 --> 00:00:56,300 of the range D15 through E18 so D15

22 00:00:53,820 --> 00:01:00,059 through

23 00:00:56,300 --> 00:01:02,520 D15 through E18 so I just hold my mouse

24 00:01:00,059 --> 00:01:04,860 and I am dragging this or instead you

25 00:01:02,520 --> 00:01:07,979 can also select here and then

26 00:01:04,860 --> 00:01:09,840 um hold shift and then click here so it

27 00:01:07,979 --> 00:01:11,700 will sell it all so it is saying called

28 00:01:09,840 --> 00:01:14,700 the content so you can right click and

29 00:01:11,700 --> 00:01:17,220 select code or you can do Ctrl X and

30 00:01:14,700 --> 00:01:22,820 formatting alert so paste them into the

31 00:01:17,220 --> 00:01:26,040 range a13 through B16 so a13

32 00:01:22,820 --> 00:01:28,259 through B16

33 00:01:26,040 --> 00:01:31,380 so that's the Ctrl VR you can right

34 00:01:28,259 --> 00:01:36,920 click and select paste so this is done

35 00:01:31,380 --> 00:01:39,479 and now in cell B13 okay B13

36 00:01:36,920 --> 00:01:41,520 create a formula using the count

37 00:01:39,479 --> 00:01:44,340 function to determine the number of

38 00:01:41,520 --> 00:01:47,280 projects that have improved vegetarian

39 00:01:44,340 --> 00:01:50,640 by counting the value in the range C 16

40 00:01:47,280 --> 00:01:52,079 through C11 so count is the function so

41 00:01:50,640 --> 00:01:55,680 to write the function which will always

42 00:01:52,079 --> 00:01:58,979 start with equals to sign so let's type

43 00:01:55,680 --> 00:02:00,780 count c o u empty so it should not be in

44 00:01:58,979 --> 00:02:04,200 capital as mentioned in the description

45 00:02:00,780 --> 00:02:05,880 it is a case insensitive so just do

46 00:02:04,200 --> 00:02:08,580 count in the function always take the

47 00:02:05,880 --> 00:02:12,060 parameter and the we should pass the

48 00:02:08,580 --> 00:02:14,400 parameter in this small brackets so it

49 00:02:12,060 --> 00:02:17,580 is saying value 1.

50 00:02:14,400 --> 00:02:19,800 and other values are optional so for the

51 00:02:17,580 --> 00:02:23,220 value one we are giving the range from

52 00:02:19,800 --> 00:02:26,220 C6 through C11 as given in the

53 00:02:23,220 --> 00:02:30,060 instructions so let's just close this

54 00:02:26,220 --> 00:02:31,800 and then click enter and it fill the

55 00:02:30,060 --> 00:02:34,319 value by Counting

56 00:02:31,800 --> 00:02:38,819 so adjust the zoom level of the excuse

57 00:02:34,319 --> 00:02:41,640 me scheduling work six to 120 So

58 00:02:38,819 --> 00:02:46,040 currently it is in 100 so let's click

59 00:02:41,640 --> 00:02:48,720 click so this is in 120 all right

60 00:02:46,040 --> 00:02:52,860 change the page orientation of the

61 00:02:48,720 --> 00:02:55,319 excuse link worksheet to Port it so now

62 00:02:52,860 --> 00:02:57,780 let's maximize this recent imported so

63 00:02:55,319 --> 00:02:59,700 the orientation are in this space layout

64 00:02:57,780 --> 00:03:02,840 tab so click here and then here is the

65 00:02:59,700 --> 00:03:06,360 orientation and then it is in portrait

66 00:03:02,840 --> 00:03:10,440 So currently it is imported

67 00:03:06,360 --> 00:03:11,519 so to put it uh some weeks you you may

68 00:03:10,440 --> 00:03:13,080 need to track the facilitator

69 00:03:11,519 --> 00:03:15,060 information but that is not necessary

70 00:03:13,080 --> 00:03:17,459 this week move the facility worksheet

71 00:03:15,060 --> 00:03:19,980 between the project and scheduling

72 00:03:17,459 --> 00:03:23,700 worksheet so worksheet I'll always swing

73 00:03:19,980 --> 00:03:26,700 in the bottom so it is saying uh move

74 00:03:23,700 --> 00:03:29,879 the facility worksheet between projects

75 00:03:26,700 --> 00:03:33,239 and excuse the language itself so just

76 00:03:29,879 --> 00:03:35,700 hold it hold it and drag it hold this

77 00:03:33,239 --> 00:03:38,760 facility Works in and drag it here

78 00:03:35,700 --> 00:03:41,280 so it will move so it is saying between

79 00:03:38,760 --> 00:03:43,440 project and schedule model then hide the

80 00:03:41,280 --> 00:03:45,840 facilities also so to hide it just click

81 00:03:43,440 --> 00:03:47,640 here and then to right click and it will

82 00:03:45,840 --> 00:03:49,980 hide options on the screen here and it

83 00:03:47,640 --> 00:03:51,959 is hidden when you end up your worksheet

84 00:03:49,980 --> 00:03:53,940 to the facilities team another colleague

85 00:03:51,959 --> 00:03:55,560 will add information about contractors

86 00:03:53,940 --> 00:03:57,659 working on the side to create a

87 00:03:55,560 --> 00:04:00,480 placeholder worksheet for this data

88 00:03:57,659 --> 00:04:02,640 insert a new worksheet in the workbook

89 00:04:00,480 --> 00:04:05,400 rename the worksheet contractors so

90 00:04:02,640 --> 00:04:07,080 let's copy this and if necessary move

91 00:04:05,400 --> 00:04:08,459 the new Wall Street after this usually

92 00:04:07,080 --> 00:04:11,580 records it so

93 00:04:08,459 --> 00:04:13,680 we need to insert a new new worksheet so

94 00:04:11,580 --> 00:04:15,480 just right click here and click insert

95 00:04:13,680 --> 00:04:18,359 or you can simply click on this button

96 00:04:15,480 --> 00:04:21,479 to create a new worksheet and to rename

97 00:04:18,359 --> 00:04:25,139 this just click on the rename and then

98 00:04:21,479 --> 00:04:26,820 heat contractors and hit enter so our

99 00:04:25,139 --> 00:04:28,680 new work CD is a

100 00:04:26,820 --> 00:04:30,419 made in it is saying if necessary move

101 00:04:28,680 --> 00:04:33,380 the new worksheet after this question so

102 00:04:30,419 --> 00:04:33,380 it is right on the position