Module 12: SAM Project 1a

1 00:00:00,000 --> 00:00:05,580 all right what's going on everyone so

2 00:00:02,220 --> 00:00:07,319 this is module 12 Sam project 1A so

3 00:00:05,580 --> 00:00:09,540 right of the bat make sure you follow

4 00:00:07,319 --> 00:00:11,880 this step and then only open the

5 00:00:09,540 --> 00:00:14,219 spreadsheet file so basically this is

6 00:00:11,880 --> 00:00:16,680 for macros because of Microsoft policy

7 00:00:14,219 --> 00:00:19,140 it does not allow macros to run directly

8 00:00:16,680 --> 00:00:21,480 if we download file from other source so

9 00:00:19,140 --> 00:00:23,220 if you are using window follow this step

10 00:00:21,480 --> 00:00:25,619 if you are using Mac follow this step

11 00:00:23,220 --> 00:00:28,380 and then only open the Excel file so

12 00:00:25,619 --> 00:00:30,599 basically macros means a feature of

13 00:00:28,380 --> 00:00:33,180 Excel and it helps us to automate the

14 00:00:30,599 --> 00:00:35,460 task so and also make sure you follow

15 00:00:33,180 --> 00:00:37,739 this step and then to bring the

16 00:00:35,460 --> 00:00:40,320 developer tab just hover on any existing

17 00:00:37,739 --> 00:00:42,360 tabs and then right click and then click

18 00:00:40,320 --> 00:00:44,340 on customize the ribbon and then make

19 00:00:42,360 --> 00:00:46,079 sure you select this developer option

20 00:00:44,340 --> 00:00:48,960 and then hit OK and develop a Time must

21 00:00:46,079 --> 00:00:51,780 appear all right so let's start so step

22 00:00:48,960 --> 00:00:53,940 one it is saying Lewis palumba is in

23 00:00:51,780 --> 00:00:56,219 charge of community relations for

24 00:00:53,940 --> 00:00:58,680 printer insurance so we don't need this

25 00:00:56,219 --> 00:01:00,660 information you can skip to here here is

26 00:00:58,680 --> 00:01:03,300 the important information it is in go to

27 00:01:00,660 --> 00:01:05,700 the tutor summary worksheet and then on

28 00:01:03,300 --> 00:01:07,920 protect it so you can edit the contents

29 00:01:05,700 --> 00:01:09,420 so let's jump to the Twitter summary

30 00:01:07,920 --> 00:01:11,400 worksheet

31 00:01:09,420 --> 00:01:14,280 and then it is saying on protect this

32 00:01:11,400 --> 00:01:16,140 worksheet So currently if we don't we

33 00:01:14,280 --> 00:01:18,799 cannot edit it because it is protected

34 00:01:16,140 --> 00:01:21,960 so to unprotect it we need to go to

35 00:01:18,799 --> 00:01:24,180 let's see review Tab and then click on

36 00:01:21,960 --> 00:01:27,240 unprotect sheet all right

37 00:01:24,180 --> 00:01:29,100 so step two it is saying Luis wants to

38 00:01:27,240 --> 00:01:31,439 include an eye-catching title on the

39 00:01:29,100 --> 00:01:34,259 worksheet which he shares with other at

40 00:01:31,439 --> 00:01:37,259 Penta Insurance insert and format odat

41 00:01:34,259 --> 00:01:39,720 as follows insert odat using the field

42 00:01:37,259 --> 00:01:42,720 dark red accent color one Shadow style

43 00:01:39,720 --> 00:01:43,979 so where to insert a word art so it is

44 00:01:42,720 --> 00:01:46,799 saying fill

45 00:01:43,979 --> 00:01:48,960 dark red and accent color 1 with Shadow

46 00:01:46,799 --> 00:01:51,360 so to insert a holder you need to go to

47 00:01:48,960 --> 00:01:53,520 insert Tab and then you need to click on

48 00:01:51,360 --> 00:01:56,640 text drop down and then here is old art

49 00:01:53,520 --> 00:01:59,399 so it was saying dark red action color

50 00:01:56,640 --> 00:02:01,740 one Shadow so just speak here and then

51 00:01:59,399 --> 00:02:03,659 ODOT will appear so rest let's read

52 00:02:01,740 --> 00:02:05,640 other instruction

53 00:02:03,659 --> 00:02:08,640 so it is saying change the text feel of

54 00:02:05,640 --> 00:02:11,280 the order to Green before that it is

55 00:02:08,640 --> 00:02:13,800 saying type winter tutoring program so

56 00:02:11,280 --> 00:02:16,800 let's just copy it

57 00:02:13,800 --> 00:02:18,780 and then

58 00:02:16,800 --> 00:02:20,760 paste it oops

59 00:02:18,780 --> 00:02:23,459 we need to paste without formatting just

60 00:02:20,760 --> 00:02:26,160 keep text only like this so just right

61 00:02:23,459 --> 00:02:27,720 click so just mix let me do it and so

62 00:02:26,160 --> 00:02:29,580 just make sure you select all the text

63 00:02:27,720 --> 00:02:31,260 and then right click and then choose

64 00:02:29,580 --> 00:02:34,400 this keep text only

65 00:02:31,260 --> 00:02:37,500 and then it will freeze up the stylings

66 00:02:34,400 --> 00:02:39,840 so step sheet is saying change the text

67 00:02:37,500 --> 00:02:43,860 field to the old text field of the order

68 00:02:39,840 --> 00:02:47,940 to green accent 6 darker 50 so text fill

69 00:02:43,860 --> 00:02:50,640 green accent 6 darker 50 percent so make

70 00:02:47,940 --> 00:02:54,180 sure you select all the tasks text so

71 00:02:50,640 --> 00:02:58,319 green and then let's see green accent 6

72 00:02:54,180 --> 00:03:01,800 and then it was saying darker 50 percent

73 00:02:58,319 --> 00:03:04,379 yeah let's confirm so green accent 6

74 00:03:01,800 --> 00:03:06,840 Target 50 and then it is saying move the

75 00:03:04,379 --> 00:03:08,819 order to row one so that it fits with

76 00:03:06,840 --> 00:03:12,480 column A through h

77 00:03:08,819 --> 00:03:16,440 so let's move into Row one and then

78 00:03:12,480 --> 00:03:17,879 it is saying a through S all right

79 00:03:16,440 --> 00:03:19,739 oops

80 00:03:17,879 --> 00:03:22,200 so just drag it

81 00:03:19,739 --> 00:03:25,140 to here and then leave your mouse

82 00:03:22,200 --> 00:03:26,879 okay so let's read the other step and it

83 00:03:25,140 --> 00:03:29,700 is saying Lewis created a macro to

84 00:03:26,879 --> 00:03:32,040 insert a plane worksheet title and then

85 00:03:29,700 --> 00:03:34,800 attach the macro to the insert Title

86 00:03:32,040 --> 00:03:37,080 button here no longer needs the button

87 00:03:34,800 --> 00:03:40,680 delete the insert Title button in the

88 00:03:37,080 --> 00:03:43,560 range as five three and six so as 5 3 as

89 00:03:40,680 --> 00:03:47,040 6 so this is the button so just right

90 00:03:43,560 --> 00:03:49,920 click in it and then here is not any

91 00:03:47,040 --> 00:03:52,080 delete option either you can cut or just

92 00:03:49,920 --> 00:03:53,879 eight Escape key and then again Escape

93 00:03:52,080 --> 00:03:55,799 key and then you can delete

94 00:03:53,879 --> 00:03:58,920 you can do like this also or you can

95 00:03:55,799 --> 00:04:01,200 just right click and then click cut oops

96 00:03:58,920 --> 00:04:03,540 now again hit Escape just make sure you

97 00:04:01,200 --> 00:04:04,920 right click here and then right click

98 00:04:03,540 --> 00:04:07,680 and then cut

99 00:04:04,920 --> 00:04:10,260 this way also you can delete the button

100 00:04:07,680 --> 00:04:12,659 all right so step four it is saying

101 00:04:10,260 --> 00:04:14,819 Lewis play plans to print the Twitter

102 00:04:12,659 --> 00:04:17,820 summary worksheet before he visits

103 00:04:14,819 --> 00:04:19,320 Twitter in the school he want to use the

104 00:04:17,820 --> 00:04:21,540 print setup button to prepare the

105 00:04:19,320 --> 00:04:24,000 worksheet for printing record a macro

106 00:04:21,540 --> 00:04:25,320 that sets off the worksheet for printing

107 00:04:24,000 --> 00:04:28,080 as follows

108 00:04:25,320 --> 00:04:30,300 okay so it is saying we got a macro name

109 00:04:28,080 --> 00:04:35,400 print setup is stored in the current

110 00:04:30,300 --> 00:04:38,460 work so let's copy this name print setup

111 00:04:35,400 --> 00:04:40,199 okay and with the macro recording click

112 00:04:38,460 --> 00:04:43,020 the file tab on the ribbon and then

113 00:04:40,199 --> 00:04:45,180 click print and then it is saying change

114 00:04:43,020 --> 00:04:48,180 the page orientation to landscape

115 00:04:45,180 --> 00:04:50,699 orientation since the scaling fitting to

116 00:04:48,180 --> 00:04:52,620 feed sheet on one phase and then return

117 00:04:50,699 --> 00:04:55,020 to the Twitter summary worksheet and

118 00:04:52,620 --> 00:04:58,380 then speed and then stop the recording

119 00:04:55,020 --> 00:05:01,080 all right so let's go here and then

120 00:04:58,380 --> 00:05:03,780 macro is we can access the macro from

121 00:05:01,080 --> 00:05:06,660 developer option developer tab or also

122 00:05:03,780 --> 00:05:08,639 from view Tab and then here is macro and

123 00:05:06,660 --> 00:05:10,740 then just click on record macro and then

124 00:05:08,639 --> 00:05:12,240 the name of the macro will be print

125 00:05:10,740 --> 00:05:15,780 setup

126 00:05:12,240 --> 00:05:19,740 and then hit OK so now macro is recorded

127 00:05:15,780 --> 00:05:22,860 and it was saying click on the file tab

128 00:05:19,740 --> 00:05:24,900 and then click on where is the print

129 00:05:22,860 --> 00:05:26,820 click on print

130 00:05:24,900 --> 00:05:28,680 and then after that it was saying change

131 00:05:26,820 --> 00:05:31,320 the page orientation to landscape

132 00:05:28,680 --> 00:05:33,060 orientation so here is the portrait

133 00:05:31,320 --> 00:05:35,820 orientation now we need to change it to

134 00:05:33,060 --> 00:05:39,660 landscape orientation and then it was

135 00:05:35,820 --> 00:05:43,139 also the same change the scale scaling

136 00:05:39,660 --> 00:05:46,500 setting to fit seat on one page so no

137 00:05:43,139 --> 00:05:47,699 scaling now we need to feed sheet on one

138 00:05:46,500 --> 00:05:50,220 page

139 00:05:47,699 --> 00:05:52,740 okay so after that it was saying return

140 00:05:50,220 --> 00:05:55,680 to the tutor summary worksheet and then

141 00:05:52,740 --> 00:05:58,560 stop the recording of macro so now you

142 00:05:55,680 --> 00:06:01,320 can stop recording all right

143 00:05:58,560 --> 00:06:03,539 so let's view other instruction

144 00:06:01,320 --> 00:06:06,479 now it is saying Lewis created the print

145 00:06:03,539 --> 00:06:08,880 setup button using a rounded rectangle

146 00:06:06,479 --> 00:06:10,380 shape you want to be able to click the

147 00:06:08,880 --> 00:06:13,020 save button

148 00:06:10,380 --> 00:06:15,000 to click the save to run the print setup

149 00:06:13,020 --> 00:06:18,740 macro assign The Print set of macro to

150 00:06:15,000 --> 00:06:21,720 print the face setup uh paste setup okay

151 00:06:18,740 --> 00:06:24,539 so just right click here and then click

152 00:06:21,720 --> 00:06:26,580 on assign macro and then click on print

153 00:06:24,539 --> 00:06:27,960 setup and then hit OK

154 00:06:26,580 --> 00:06:29,340 all right

155 00:06:27,960 --> 00:06:33,479 so

156 00:06:29,340 --> 00:06:36,180 step 5 is also done now step six go to

157 00:06:33,479 --> 00:06:38,400 the tutor records worksheet which tracks

158 00:06:36,180 --> 00:06:40,259 total assignment here and his staff

159 00:06:38,400 --> 00:06:42,840 usually enter the tutoring details

160 00:06:40,259 --> 00:06:44,520 directly on the worksheet he wants to

161 00:06:42,840 --> 00:06:46,919 make sure everyone interests the

162 00:06:44,520 --> 00:06:49,020 returning data correctly especially the

163 00:06:46,919 --> 00:06:52,139 dates in the two turning start date

164 00:06:49,020 --> 00:06:56,280 column the tutoring program begins on

165 00:06:52,139 --> 00:06:58,800 March 22 2021 and ends on May 14 2021

166 00:06:56,280 --> 00:07:02,520 create the data validation rule as

167 00:06:58,800 --> 00:07:04,919 follows in range C5 through c18 create a

168 00:07:02,520 --> 00:07:08,400 data validation rule that accepts only

169 00:07:04,919 --> 00:07:09,300 dates value between this okay so let's

170 00:07:08,400 --> 00:07:12,720 see

171 00:07:09,300 --> 00:07:16,740 on Twitter record worksheet C5 through

172 00:07:12,720 --> 00:07:19,800 c18 so total record worksheet C5 through

173 00:07:16,740 --> 00:07:21,660 c18 it is saying add a data validation

174 00:07:19,800 --> 00:07:24,300 that accepts only the date between

175 00:07:21,660 --> 00:07:26,160 something did so to add a data

176 00:07:24,300 --> 00:07:29,340 validation I'm going to go to data Tab

177 00:07:26,160 --> 00:07:31,199 and then here is the data validation and

178 00:07:29,340 --> 00:07:33,780 then it is saying allow any value but we

179 00:07:31,199 --> 00:07:36,560 need to allow only the date and then

180 00:07:33,780 --> 00:07:41,819 let's see all the instruction

181 00:07:36,560 --> 00:07:46,460 so it is saying date between 320 to 2021

182 00:07:41,819 --> 00:07:55,380 and 5 14 20 21 so between

183 00:07:46,460 --> 00:07:57,300 3 22 21 and then 5 14 and then 2021 and

184 00:07:55,380 --> 00:07:59,039 then hit okay

185 00:07:57,300 --> 00:08:01,440 so after that it is saying create an

186 00:07:59,039 --> 00:08:04,259 input message that uses two turning

187 00:08:01,440 --> 00:08:07,259 start date as a title and the following

188 00:08:04,259 --> 00:08:09,000 text as the input message so let's copy

189 00:08:07,259 --> 00:08:13,139 this title

190 00:08:09,000 --> 00:08:15,419 and then again go to via data Tab and

191 00:08:13,139 --> 00:08:17,819 then data validation and then in another

192 00:08:15,419 --> 00:08:19,139 tab here is input message and then paste

193 00:08:17,819 --> 00:08:22,319 the title

194 00:08:19,139 --> 00:08:25,139 and then for input message

195 00:08:22,319 --> 00:08:28,080 oops so for input message it is enter

196 00:08:25,139 --> 00:08:31,259 the following day to start tutoring so

197 00:08:28,080 --> 00:08:32,459 just copy this and then paste on input

198 00:08:31,259 --> 00:08:34,800 message

199 00:08:32,459 --> 00:08:37,560 now step C with the same Creator stop

200 00:08:34,800 --> 00:08:40,380 style error a lot that uses invalidate

201 00:08:37,560 --> 00:08:43,320 as a title and the following text as the

202 00:08:40,380 --> 00:08:45,540 error message so let's just copy this

203 00:08:43,320 --> 00:08:48,420 title and then go to another tab here is

204 00:08:45,540 --> 00:08:51,060 error alert so on the title it's all be

205 00:08:48,420 --> 00:08:54,060 in valid date

206 00:08:51,060 --> 00:08:55,440 and then in the error message it will be

207 00:08:54,060 --> 00:08:58,740 this text

208 00:08:55,440 --> 00:09:00,360 so let's go here and the message paste

209 00:08:58,740 --> 00:09:02,339 this text

210 00:09:00,360 --> 00:09:04,620 and then okay

211 00:09:02,339 --> 00:09:07,019 so step seven

212 00:09:04,620 --> 00:09:08,880 it is saying Lewis wants to make sure

213 00:09:07,019 --> 00:09:11,399 all of the dates entered in the two

214 00:09:08,880 --> 00:09:14,279 running State date column are valid

215 00:09:11,399 --> 00:09:17,339 identify and correct any invalid value

216 00:09:14,279 --> 00:09:20,339 as follows in the range C5 plus c18

217 00:09:17,339 --> 00:09:24,779 surgical in Valley invalid data so let's

218 00:09:20,339 --> 00:09:30,420 see so select C5 through Co

219 00:09:24,779 --> 00:09:32,339 Escape so C5 through c18 so go to data

220 00:09:30,420 --> 00:09:34,380 and then data validation and then Circle

221 00:09:32,339 --> 00:09:36,660 invalid data so these two data are

222 00:09:34,380 --> 00:09:39,000 invalid let's see as an instruction it

223 00:09:36,660 --> 00:09:47,160 is saying change the first invalidate to

224 00:09:39,000 --> 00:09:50,160 324 so it was yeah 324 2021 so it's 324

225 00:09:47,160 --> 00:09:50,160 2021

226 00:09:50,279 --> 00:09:59,339 oops not there so it's over here it's

227 00:09:54,740 --> 00:10:03,120 318.18 utt to 324 2021 and then for

228 00:09:59,339 --> 00:10:06,360 second either it is saying 326 21.

229 00:10:03,120 --> 00:10:09,959 so it's 5 where to change it to 3 and

230 00:10:06,360 --> 00:10:12,300 then 22 26 whether it enter

231 00:10:09,959 --> 00:10:14,459 so step eight it is saying go to the

232 00:10:12,300 --> 00:10:16,860 tutor registration worksheet during the

233 00:10:14,459 --> 00:10:18,839 volunteer fear Lewis and dizzy staff

234 00:10:16,860 --> 00:10:21,240 will enter tutorial information using

235 00:10:18,839 --> 00:10:23,040 the form on this worksheet Luis has

236 00:10:21,240 --> 00:10:25,440 created two macros to automate the

237 00:10:23,040 --> 00:10:27,360 automate this form but they are not

238 00:10:25,440 --> 00:10:29,640 working correctly View and edit the

239 00:10:27,360 --> 00:10:31,560 macros as follows so it is saying open

240 00:10:29,640 --> 00:10:33,360 the clear for macro in the Visual Basic

241 00:10:31,560 --> 00:10:36,240 editor the macro should delete the

242 00:10:33,360 --> 00:10:39,240 values in the range C4 through C8 but it

243 00:10:36,240 --> 00:10:40,320 specify the range C7 through C3 through

244 00:10:39,240 --> 00:10:43,380 C7

245 00:10:40,320 --> 00:10:45,360 so let's see the clear for macro so

246 00:10:43,380 --> 00:10:47,640 firstly let's go to tutor registration

247 00:10:45,360 --> 00:10:49,860 worksheet and then to view and read the

248 00:10:47,640 --> 00:10:52,140 macro you can go to developer tab and

249 00:10:49,860 --> 00:10:54,600 then click on Macros and then clear for

250 00:10:52,140 --> 00:10:57,120 macros and then edit so this will open

251 00:10:54,600 --> 00:10:58,920 the Visual Basic editor and then it was

252 00:10:57,120 --> 00:11:04,200 saying to

253 00:10:58,920 --> 00:11:06,060 change C3 through C7 to C4 through C8 I

254 00:11:04,200 --> 00:11:09,779 believe let's confirm

255 00:11:06,060 --> 00:11:12,300 so yes C4 through C8 and then stability

256 00:11:09,779 --> 00:11:14,279 in the clear for macro BBA code change

257 00:11:12,300 --> 00:11:16,740 the statement between the edit the code

258 00:11:14,279 --> 00:11:20,040 below and edit the code above comment to

259 00:11:16,740 --> 00:11:22,200 the following statement range C4 C8 so

260 00:11:20,040 --> 00:11:24,000 let's see yes here is the editor code

261 00:11:22,200 --> 00:11:26,640 below and hit the code however when this

262 00:11:24,000 --> 00:11:29,160 is the statement that is given here is

263 00:11:26,640 --> 00:11:31,260 same one and it is saying scroll down to

264 00:11:29,160 --> 00:11:33,000 display the code for the add total macro

265 00:11:31,260 --> 00:11:36,120 the second macro blue is created this

266 00:11:33,000 --> 00:11:38,519 macro runs calls or runs the clear form

267 00:11:36,120 --> 00:11:40,440 macro at the end of the code so it sold

268 00:11:38,519 --> 00:11:42,300 now work correctly

269 00:11:40,440 --> 00:11:46,140 save the code and then close the visual

270 00:11:42,300 --> 00:11:48,680 studio Visual Basic editor so let's see

271 00:11:46,140 --> 00:11:51,740 scroll down yes there is ADD Twitter

272 00:11:48,680 --> 00:11:55,440 macro so this will work correctly now

273 00:11:51,740 --> 00:11:57,420 save these and then close this editor

274 00:11:55,440 --> 00:11:59,279 and then it is saying assign the clear

275 00:11:57,420 --> 00:12:01,500 form macro to the clear form button so

276 00:11:59,279 --> 00:12:03,600 that Lewis and staff can use the button

277 00:12:01,500 --> 00:12:06,660 to clear the phone use the clear format

278 00:12:03,600 --> 00:12:09,180 button to clear the form and then and

279 00:12:06,660 --> 00:12:11,579 test and test the macro okay

280 00:12:09,180 --> 00:12:15,000 so let's assign

281 00:12:11,579 --> 00:12:16,500 click on assign and then clear form and

282 00:12:15,000 --> 00:12:18,720 then hit OK

283 00:12:16,500 --> 00:12:21,600 all right so let's click this button and

284 00:12:18,720 --> 00:12:24,180 then it should remove this information

285 00:12:21,600 --> 00:12:26,600 yep it removed the information so macros

286 00:12:24,180 --> 00:12:29,940 is working properly

287 00:12:26,600 --> 00:12:33,180 uh right now step nine it is saying add

288 00:12:29,940 --> 00:12:35,760 the add Twitter macro should copy the

289 00:12:33,180 --> 00:12:37,980 data in the range C4 through C8 on the

290 00:12:35,760 --> 00:12:39,779 tutor registration worksheet go to the

291 00:12:37,980 --> 00:12:42,600 tutor record worksheet find the next

292 00:12:39,779 --> 00:12:45,600 blank row and then paste the copy data

293 00:12:42,600 --> 00:12:47,940 transporting it to feet in a row instead

294 00:12:45,600 --> 00:12:49,500 of a column then the macro should return

295 00:12:47,940 --> 00:12:51,899 to the to the total registration

296 00:12:49,500 --> 00:12:54,899 worksheet and run the clear for macro

297 00:12:51,899 --> 00:12:57,779 which did delete the data in the range

298 00:12:54,899 --> 00:13:00,300 C4 through shared so it's it seems like

299 00:12:57,779 --> 00:13:02,940 a complex macro so let's see this thing

300 00:13:00,300 --> 00:13:04,980 Lewis wants to assign the add to the

301 00:13:02,940 --> 00:13:06,360 macro to a new button to make it easy to

302 00:13:04,980 --> 00:13:08,820 run the macro

303 00:13:06,360 --> 00:13:10,320 create the button as follows so it is

304 00:13:08,820 --> 00:13:12,360 saying insert a button form control

305 00:13:10,320 --> 00:13:14,639 button in the column C to the right of

306 00:13:12,360 --> 00:13:16,620 the clear home button so let's insert

307 00:13:14,639 --> 00:13:19,680 our form control button

308 00:13:16,620 --> 00:13:21,480 it is saying in column C so this is the

309 00:13:19,680 --> 00:13:23,700 column C so to insert a button you need

310 00:13:21,480 --> 00:13:25,440 to go to the developer tab and then here

311 00:13:23,700 --> 00:13:28,800 is insert drop down and then here is

312 00:13:25,440 --> 00:13:30,720 form control and then choose button and

313 00:13:28,800 --> 00:13:31,800 then just drag it randomly in this

314 00:13:30,720 --> 00:13:34,100 column

315 00:13:31,800 --> 00:13:37,560 and then let's see all the instruction

316 00:13:34,100 --> 00:13:40,920 so it is saying change the height to 0.3

317 00:13:37,560 --> 00:13:42,540 inch and the width to 1.8 inch online

318 00:13:40,920 --> 00:13:44,700 the top of the new button with the top

319 00:13:42,540 --> 00:13:47,940 of the clear form button it is the text

320 00:13:44,700 --> 00:13:50,040 to display add tutor okay let's copy

321 00:13:47,940 --> 00:13:53,060 this text

322 00:13:50,040 --> 00:13:55,980 and then format the button to use gel

323 00:13:53,060 --> 00:13:58,200 calibrary 11 Point text if necessary

324 00:13:55,980 --> 00:13:59,160 assign that Twitter macro to the new

325 00:13:58,200 --> 00:14:03,120 button

326 00:13:59,160 --> 00:14:06,660 okay so 0.3 height and then 1.8 width

327 00:14:03,120 --> 00:14:08,880 and then the macro will be at Twitter

328 00:14:06,660 --> 00:14:12,000 and then hit okay

329 00:14:08,880 --> 00:14:14,579 so let's go to the save format Tab and

330 00:14:12,000 --> 00:14:16,980 then it was saying 0.3 width and then

331 00:14:14,579 --> 00:14:19,019 1.8 height

332 00:14:16,980 --> 00:14:20,880 and then

333 00:14:19,019 --> 00:14:23,639 edit text

334 00:14:20,880 --> 00:14:26,700 so let's

335 00:14:23,639 --> 00:14:29,160 let's paste the copied text right click

336 00:14:26,700 --> 00:14:30,779 and then paste

337 00:14:29,160 --> 00:14:33,839 okay

338 00:14:30,779 --> 00:14:34,980 so let's see the font

339 00:14:33,839 --> 00:14:38,779 oops

340 00:14:34,980 --> 00:14:38,779 click on edit text

341 00:14:39,240 --> 00:14:45,120 someone

342 00:14:42,060 --> 00:14:46,980 size and properties Loops not there so

343 00:14:45,120 --> 00:14:48,779 just click on outside so currently it

344 00:14:46,980 --> 00:14:52,199 was selected both water

345 00:14:48,779 --> 00:14:55,199 so just click here and then edit textile

346 00:14:52,199 --> 00:14:58,500 okay so oops

347 00:14:55,199 --> 00:15:01,199 click outside and then write it right

348 00:14:58,500 --> 00:15:03,959 click and then edit text

349 00:15:01,199 --> 00:15:06,959 and then select all these text and then

350 00:15:03,959 --> 00:15:09,060 it was saying calibri

351 00:15:06,959 --> 00:15:09,959 can leave the 11th part so just hit

352 00:15:09,060 --> 00:15:12,120 enter

353 00:15:09,959 --> 00:15:14,100 and then okay

354 00:15:12,120 --> 00:15:16,139 now it is saying format the bottom

355 00:15:14,100 --> 00:15:18,000 control to use this okay and align the

356 00:15:16,139 --> 00:15:19,440 top of the new button with the top of

357 00:15:18,000 --> 00:15:22,079 the clear button

358 00:15:19,440 --> 00:15:24,240 okay so again right click and then

359 00:15:22,079 --> 00:15:25,560 escape and then move this little bit of

360 00:15:24,240 --> 00:15:27,260 book

361 00:15:25,560 --> 00:15:29,399 okay

362 00:15:27,260 --> 00:15:32,760 all right

363 00:15:29,399 --> 00:15:35,760 so let's check the 0.3 inch and

364 00:15:32,760 --> 00:15:39,060 a width 1.8 inch

365 00:15:35,760 --> 00:15:42,360 so just click save format 0.3 158 all

366 00:15:39,060 --> 00:15:44,519 right now it is saying first insert the

367 00:15:42,360 --> 00:15:46,860 tutor registration data Sony table one

368 00:15:44,519 --> 00:15:49,320 then use the add Twitter button to run

369 00:15:46,860 --> 00:15:50,820 that Twitter macro and then verify that

370 00:15:49,320 --> 00:15:53,880 is added

371 00:15:50,820 --> 00:15:59,000 or record on the tutor records worksheet

372 00:15:53,880 --> 00:15:59,000 so let's copy this put on this

373 00:15:59,519 --> 00:16:04,800 Santos

374 00:16:02,459 --> 00:16:06,420 just over here right click and then

375 00:16:04,800 --> 00:16:09,120 paste the text

376 00:16:06,420 --> 00:16:12,480 and then beverage

377 00:16:09,120 --> 00:16:15,000 and then right click just paste text

378 00:16:12,480 --> 00:16:18,199 and then date will be this and then

379 00:16:15,000 --> 00:16:18,199 signs and then l

380 00:16:18,300 --> 00:16:25,740 paste it and then

381 00:16:21,440 --> 00:16:28,320 signs and T-shirt size is l

382 00:16:25,740 --> 00:16:30,779 yup T-shirt size is L now we need to

383 00:16:28,320 --> 00:16:33,720 click on ADD Twitter button and verify

384 00:16:30,779 --> 00:16:37,139 if it's get added here similarly it's

385 00:16:33,720 --> 00:16:40,440 just made feature so let's see click on

386 00:16:37,139 --> 00:16:42,959 ADD tutor so it should go here and then

387 00:16:40,440 --> 00:16:44,940 it added this data and it came here and

388 00:16:42,959 --> 00:16:49,880 then it cleared this

389 00:16:44,940 --> 00:16:49,880 all right so catch you in another video