1
00:00:00,100 --> 00:00:06,660
Back to another class, of course, about the complete introduction to Microsoft Excel, the use of

2
00:00:06,660 --> 00:00:08,910
VBA or the V for Microsoft Excel.

3
00:00:09,720 --> 00:00:16,170
So in this class, we are still going to talk about Microsoft and different types of macros that exist.

4
00:00:16,440 --> 00:00:22,620
And basically what I want to do today is really putting everything that we have just learned into application

5
00:00:22,950 --> 00:00:26,650
and create a few macros that can be really useful for you guys.

6
00:00:26,670 --> 00:00:31,680
Well, basically, in your use of Excel and at the same time, you are going to learn what exactly you

7
00:00:31,680 --> 00:00:33,170
can do with macros.

8
00:00:34,710 --> 00:00:40,500
So as I said in the past few classes, what does what macros exactly does?

9
00:00:40,890 --> 00:00:46,430
So basically it will automate tasks that normally takes you a few steps to make.

10
00:00:47,040 --> 00:00:49,830
So let's say, for example, we have this table right here.

11
00:00:50,310 --> 00:00:56,250
And I don't know, I want to, for example, take the letter A and simply add color to the letter A

12
00:00:56,340 --> 00:00:58,320
and make it a little bit bigger.

13
00:00:59,220 --> 00:01:04,570
So basically, I will be able to do it in a few steps, but I think also using macros.

14
00:01:04,570 --> 00:01:07,500
So let's just use as an example the letter.

15
00:01:08,190 --> 00:01:14,010
So let's say, for example, for my letter eight, I want to grow the well, the size of my letter A

16
00:01:14,010 --> 00:01:19,800
put it at 14 change, put it in bold change.

17
00:01:19,800 --> 00:01:23,880
The colors will basically make the whole cell yellow and the text.

18
00:01:23,970 --> 00:01:25,090
So right here in the red.

19
00:01:25,620 --> 00:01:28,590
So basically, as you can see, took me more than one step.

20
00:01:28,590 --> 00:01:33,900
And also at this, let's say this one so easily took me way more than one step.

21
00:01:34,740 --> 00:01:39,690
But I will what I can do as well is using a macro to be able to automate all those steps, because if

22
00:01:39,690 --> 00:01:44,700
I want to do the same thing for other letters, all the letters right here, I won't be able because

23
00:01:44,700 --> 00:01:47,190
once again, I can only do this with the letter.

24
00:01:47,190 --> 00:01:50,370
I did it only with the letter A yes, I can select everything.

25
00:01:50,370 --> 00:01:52,390
But let's say, for example, I want to do something different.

26
00:01:52,410 --> 00:01:55,950
Will there be for the letter F, for the letter G, for example?

27
00:01:55,960 --> 00:01:59,430
So it's easier sometimes to use the macros.

28
00:02:00,330 --> 00:02:03,210
So basically what we'll do at first is pretty simple.

29
00:02:03,210 --> 00:02:06,250
We're just going to practice this macro that I just showed you.

30
00:02:06,660 --> 00:02:08,880
So if we try it out, that's pretty simple.

31
00:02:09,510 --> 00:02:15,810
We are going to go here and use relative references because I want to be able to do this everywhere

32
00:02:16,800 --> 00:02:18,340
and we're going to record the macro.

33
00:02:18,930 --> 00:02:23,420
So we'll call it, I don't know, we'll call it a and we'll click on.

34
00:02:23,430 --> 00:02:29,430
OK, so if our macro what we need to do is pretty simple, first of all, we want to change the size

35
00:02:29,430 --> 00:02:30,230
of our letter.

36
00:02:30,360 --> 00:02:33,390
So it was at 14, we're going to put it at 18.

37
00:02:33,990 --> 00:02:35,390
We want to add some color.

38
00:02:35,580 --> 00:02:40,980
We want to add this thing right here and we want to make it in bold.

39
00:02:41,280 --> 00:02:41,910
So that's it.

40
00:02:41,910 --> 00:02:42,870
That's all I wanted to do.

41
00:02:42,870 --> 00:02:45,340
I wanted to add also red color to it.

42
00:02:45,960 --> 00:02:46,920
So that's it then.

43
00:02:46,920 --> 00:02:51,870
The next thing, we just come back in our developer and stop recording our macro.

44
00:02:53,070 --> 00:02:54,510
So right now we have our macro.

45
00:02:54,510 --> 00:02:55,200
That is the letter.

46
00:02:55,770 --> 00:03:00,540
So basically, if I want to do the exact same thing to my other letters, so it's pretty simple, I

47
00:03:00,540 --> 00:03:04,100
simply go here, select my microplane and click on Run.

48
00:03:04,110 --> 00:03:07,830
And as you can see, the same thing will automatically be done with the letter C.

49
00:03:07,830 --> 00:03:09,650
I want to do the same thing for the letter K.

50
00:03:09,840 --> 00:03:10,710
Well, pretty simple.

51
00:03:10,980 --> 00:03:12,780
I can go here and simply run it.

52
00:03:13,020 --> 00:03:15,900
And once again, no, forget one thing you guys can basically.

53
00:03:15,900 --> 00:03:19,290
What if you right now I use the macro right here.

54
00:03:19,290 --> 00:03:20,640
I click and I run it this one.

55
00:03:20,970 --> 00:03:23,720
But you guys can use a shortcut, a shortcut keys.

56
00:03:23,730 --> 00:03:27,690
So basically you can use control and thus control A control B control.

57
00:03:27,690 --> 00:03:30,780
C, you can decide your short shortcut key.

58
00:03:30,990 --> 00:03:36,900
And basically by having a shortcut key if you need to do this in in many places, instead of having

59
00:03:36,900 --> 00:03:40,640
to do all the five steps, we can just run the shortcut.

60
00:03:42,030 --> 00:03:45,060
So that's for all the basics.

61
00:03:45,540 --> 00:03:50,970
So just put in bringing it back to normal, taking away the caller.

62
00:03:53,210 --> 00:03:54,330
Here we go.

63
00:03:57,390 --> 00:03:57,720
All right.

64
00:04:00,560 --> 00:04:01,800
So right now, everything is fine.

65
00:04:02,090 --> 00:04:05,990
So what we're going to do right now, we are going basically to practice everything that we have just

66
00:04:05,990 --> 00:04:07,820
learned in the past few classes.

67
00:04:08,000 --> 00:04:09,340
So how we are going to do this.

68
00:04:09,350 --> 00:04:12,700
So I propose you to create a small table that looks something like this.

69
00:04:13,070 --> 00:04:17,930
So pretty simple, will have later letters, will have dates, will have a percentage, will have a

70
00:04:17,930 --> 00:04:18,320
number.

71
00:04:18,320 --> 00:04:23,180
And we are also going to do a test using the if function.

72
00:04:23,210 --> 00:04:28,400
So basically, if you guys are not familiar with the function, it's not a big deal because it's not

73
00:04:28,790 --> 00:04:29,570
part of the course.

74
00:04:29,570 --> 00:04:33,680
But I'm going to show it to you well, in the scores as well.

75
00:04:33,690 --> 00:04:35,130
So you learn a little bit more.

76
00:04:36,440 --> 00:04:37,330
So pretty simple.

77
00:04:37,550 --> 00:04:41,930
First thing as you guys do is simply write down all the letters of the alphabet.

78
00:04:41,960 --> 00:04:47,810
So basically, ABC, until set in the dates part, what we are going to do, we are going to generate

79
00:04:47,810 --> 00:04:48,680
a random number.

80
00:04:48,890 --> 00:04:54,600
So we are going to write down with you random functions here in between and we are going to generate

81
00:04:54,600 --> 00:04:59,110
the random number between one and let's say thirty thousand.

82
00:05:00,050 --> 00:05:01,520
So why exactly thirty thousand.

83
00:05:01,530 --> 00:05:06,470
So you'll see a little bit later in this case right here.

84
00:05:06,500 --> 00:05:09,320
So we have percentage pretty simple.

85
00:05:09,320 --> 00:05:12,030
We are going to use the random function.

86
00:05:12,050 --> 00:05:15,600
So basically it's going to be rent in just the read function.

87
00:05:15,830 --> 00:05:19,240
So basically it's going to generate a number between zero and one.

88
00:05:21,080 --> 00:05:24,900
And finally, for the number, we can just generate a random number.

89
00:05:24,980 --> 00:05:29,420
So you're run between and around.

90
00:05:30,500 --> 00:05:39,290
Between here we go, we will generate a random random number between one and twenty five, let's say

91
00:05:39,290 --> 00:05:39,740
one in five.

92
00:05:40,430 --> 00:05:40,980
It's going to be better.

93
00:05:41,570 --> 00:05:41,900
All right.

94
00:05:42,050 --> 00:05:44,540
So right now, we have everything that we need.

95
00:05:46,790 --> 00:05:48,440
There we go.

96
00:05:48,680 --> 00:05:49,320
All right, great.

97
00:05:49,700 --> 00:05:55,210
So right now that we have everything that we need, we'll do just select everything and just drag it

98
00:05:55,220 --> 00:05:56,200
until down there.

99
00:05:56,390 --> 00:05:58,940
So we have our dates, we have our percentage.

100
00:05:58,940 --> 00:06:00,290
We have our numbers.

101
00:06:00,980 --> 00:06:01,340
All right.

102
00:06:02,510 --> 00:06:03,770
So next step.

103
00:06:03,800 --> 00:06:06,430
Let's say, for example, we are at the date right here.

104
00:06:06,450 --> 00:06:07,880
So it doesn't make sense.

105
00:06:07,880 --> 00:06:09,320
It's just a number.

106
00:06:09,680 --> 00:06:16,490
And let's say we need to well, we need to convert some of those dates into dates and we want to change

107
00:06:16,490 --> 00:06:18,170
also their size and everything.

108
00:06:18,500 --> 00:06:20,260
So how exactly we can do this?

109
00:06:20,540 --> 00:06:21,260
So pretty simple.

110
00:06:21,260 --> 00:06:26,900
We're going to use it on one of those dates to be able to change everything about it.

111
00:06:26,930 --> 00:06:32,180
So pretty simple to change the date of this element, what steps we need to take.

112
00:06:32,210 --> 00:06:32,810
So pretty simple.

113
00:06:32,810 --> 00:06:36,380
We just need to go here in general and simply select the date.

114
00:06:36,410 --> 00:06:38,300
So basically, it's going to be a long date.

115
00:06:39,320 --> 00:06:43,610
And we if we open it up like this, as you can see, it's going to be Sunday, October 6th.

116
00:06:44,480 --> 00:06:45,440
Nineteen twenty nine.

117
00:06:45,440 --> 00:06:49,190
Each time you refreshed, the date will change, which is pretty cool.

118
00:06:50,300 --> 00:06:50,660
All right.

119
00:06:51,620 --> 00:06:58,550
So basically what I do is not applying it to everything that we have here, but just to a few of those

120
00:06:58,670 --> 00:07:04,100
dates, a few dates that we select, we want to add, we want to have a complete date for for just a

121
00:07:04,100 --> 00:07:04,700
few of those.

122
00:07:05,720 --> 00:07:09,160
So not only this, we also want to add color to it.

123
00:07:09,170 --> 00:07:11,180
So let's say we want to add the yellow color.

124
00:07:12,050 --> 00:07:15,890
We want to make it bold, and we want to add this type of table.

125
00:07:16,040 --> 00:07:19,100
So something that is like this, so pretty simple.

126
00:07:20,150 --> 00:07:23,100
Each time we refresh it, it's going to be it's going to change automatically.

127
00:07:23,570 --> 00:07:25,040
So how exactly do we do this?

128
00:07:25,040 --> 00:07:30,310
So as you guys saw, we had a few steps that we need to accomplish before achieving this.

129
00:07:30,620 --> 00:07:31,280
So pretty simple.

130
00:07:31,280 --> 00:07:33,230
First of all, we needed to change the date.

131
00:07:33,630 --> 00:07:35,300
Then we need to add a color.

132
00:07:35,420 --> 00:07:37,040
Then we need to add the bold.

133
00:07:37,070 --> 00:07:40,880
And then if you guys want to change also the size of the text, you can do it as well.

134
00:07:42,410 --> 00:07:43,470
So we'll try it out.

135
00:07:43,490 --> 00:07:48,860
So basically, if you guys wanted to do this well on some of those dates, it's going to take you five

136
00:07:48,860 --> 00:07:50,990
steps each time, which takes a lot of time.

137
00:07:51,020 --> 00:07:52,590
This is why we're going to create the micro.

138
00:07:53,510 --> 00:07:56,670
So this is exactly what we're going to do right now.

139
00:07:56,690 --> 00:07:57,380
So pretty simple.

140
00:07:57,380 --> 00:07:59,750
We're going to take this date right here.

141
00:08:02,760 --> 00:08:05,680
All right, we're going to bring it to general, right?

142
00:08:05,950 --> 00:08:06,760
So let's start.

143
00:08:06,890 --> 00:08:12,070
All right, so first step that we want to do is simply come back to our go back to our developer tab

144
00:08:12,520 --> 00:08:14,710
and use relative references.

145
00:08:14,830 --> 00:08:17,200
Then we are going to record our Macroom.

146
00:08:17,980 --> 00:08:19,600
So we're clicking here and here.

147
00:08:19,600 --> 00:08:20,510
We are going to add.

148
00:08:21,070 --> 00:08:24,850
So for those of you who want to try this shortcut, you can add a shortcut.

149
00:08:25,360 --> 00:08:31,030
So basically, if you want to click control A.E able to generate the macro, you can do it as well,

150
00:08:31,030 --> 00:08:32,980
just like for practice purposes.

151
00:08:33,010 --> 00:08:36,020
I'm not going to do it personally, but if you guys want to do it, you can do it.

152
00:08:36,850 --> 00:08:40,090
So we'll call this micro date and then click on.

153
00:08:40,090 --> 00:08:40,480
OK,

154
00:08:43,870 --> 00:08:44,380
go.

155
00:08:47,080 --> 00:08:47,410
They're.

156
00:08:54,050 --> 00:08:57,480
OK, we'll try again, right?

157
00:08:57,650 --> 00:08:58,980
We'll keep it back for twenty seven.

158
00:08:59,780 --> 00:09:00,500
It's going to be easier.

159
00:09:00,800 --> 00:09:01,190
All right.

160
00:09:01,190 --> 00:09:03,790
So basically what exactly we need to do at first.

161
00:09:03,800 --> 00:09:04,640
So we come back here.

162
00:09:05,240 --> 00:09:11,390
First step will be changing the type of our text to basically hear what we need.

163
00:09:12,110 --> 00:09:13,600
We need a date.

164
00:09:13,610 --> 00:09:15,140
So basically a long date.

165
00:09:15,290 --> 00:09:17,500
We're going to select this one right here.

166
00:09:17,660 --> 00:09:19,190
So we have our long date.

167
00:09:19,610 --> 00:09:21,820
Next step we want to do is make it bold.

168
00:09:21,860 --> 00:09:29,030
So we'll click on it, then make the size of our text a little bit bigger, add some color to it and

169
00:09:29,030 --> 00:09:29,390
that's it.

170
00:09:29,420 --> 00:09:32,030
So basically, everything works perfectly right now.

171
00:09:32,030 --> 00:09:35,930
So we have everything that we if you guys want to add a bit of coloration through your text, you can

172
00:09:35,930 --> 00:09:36,590
do it as well.

173
00:09:37,200 --> 00:09:40,490
So when it's all done, you just stop recording your macro.

174
00:09:42,140 --> 00:09:44,030
So we'll just make it bigger to be able to see it.

175
00:09:44,390 --> 00:09:44,990
So here we go.

176
00:09:44,990 --> 00:09:46,150
We have our date right here.

177
00:09:46,340 --> 00:09:49,160
We forgot one step, which is adding this thing right here.

178
00:09:49,160 --> 00:09:50,320
But once again, it's not a big deal.

179
00:09:50,930 --> 00:09:53,530
So right now, let's say I want to run this macro right here.

180
00:09:53,540 --> 00:09:54,290
So pretty simple.

181
00:09:54,290 --> 00:09:59,750
What I will do is simply go in here and select my macro, which would be macro twenty seven, and I'll

182
00:09:59,750 --> 00:10:03,230
just run it and see everything works perfectly fine.

183
00:10:03,380 --> 00:10:06,890
So I'm coming back here and I run it.

184
00:10:06,920 --> 00:10:14,090
So as you can see, everything is perfect, so everything works fine and I can do it whatever I want.

185
00:10:15,170 --> 00:10:15,590
All right.

186
00:10:15,590 --> 00:10:20,080
So next thing we're going back to we coming to our percentages right here.

187
00:10:20,540 --> 00:10:23,330
So what I want to do in this case is pretty simple.

188
00:10:23,330 --> 00:10:27,370
So we want to change this some of those into percentages.

189
00:10:27,380 --> 00:10:33,980
So basically, we want to generate we want to have this case, for example, in the format of a percentage

190
00:10:33,980 --> 00:10:37,850
of basically zero point nine nine five, it's going to be ninety nine point five percent.

191
00:10:38,720 --> 00:10:40,460
And this is exactly what we want to do.

192
00:10:40,910 --> 00:10:43,160
So basically to be able to do this, it's pretty simple.

193
00:10:43,670 --> 00:10:46,250
We simply need to click right here.

194
00:10:46,640 --> 00:10:52,940
So let's say you want to do the same thing, but instead of the yellow color, we want to make it green.

195
00:10:52,950 --> 00:10:55,440
So basically we're going to use the green color instead.

196
00:10:55,880 --> 00:10:57,950
So what we're going to do is pretty much the same thing.

197
00:10:57,950 --> 00:11:02,810
We're going to create Imakura for our well for some of those elements.

198
00:11:03,800 --> 00:11:05,750
So we'll come back to our developer tab.

199
00:11:05,930 --> 00:11:11,550
We're going to use a reference because once again, we want to do is use our macros everywhere.

200
00:11:12,650 --> 00:11:13,490
So pretty simple.

201
00:11:13,790 --> 00:11:19,500
And then what we're going to do, we are going to record our macro and we'll call it for something.

202
00:11:21,140 --> 00:11:22,600
Just click on, OK?

203
00:11:23,330 --> 00:11:26,040
And then what I do is simply create our macros.

204
00:11:26,060 --> 00:11:32,330
So first step is pretty simple, is putting it into percentage so we can click on the button right here

205
00:11:32,720 --> 00:11:35,230
or just select the percentage there.

206
00:11:35,240 --> 00:11:36,170
So here it is.

207
00:11:37,010 --> 00:11:40,340
Then the next step is pretty simple, changing the color.

208
00:11:40,430 --> 00:11:48,020
So putting it into green, then next step, adding this thing right here, making the text bold and

209
00:11:48,020 --> 00:11:50,200
maybe changing the size of urtext.

210
00:11:50,810 --> 00:11:51,530
So here we go.

211
00:11:51,530 --> 00:11:52,860
We have all our macro.

212
00:11:53,330 --> 00:11:54,380
So we're coming back here.

213
00:11:54,380 --> 00:11:58,210
We stop recording and we can try our micro.

214
00:11:58,220 --> 00:11:59,450
So let's try it right there.

215
00:12:00,320 --> 00:12:02,260
Pretty simple how exactly we run our micro.

216
00:12:02,360 --> 00:12:05,330
So we just go in our macros, we have our percentage and we run it.

217
00:12:05,750 --> 00:12:07,640
Those you can see everything works fine.

218
00:12:08,000 --> 00:12:11,510
So if I run my percentage micro right here, it's going to look like this.

219
00:12:11,510 --> 00:12:19,610
If I run my data micro, which in my case is micro twenty seven, it's going to become yellow and with

220
00:12:19,940 --> 00:12:23,500
text if I try it out, as you can see it's yellow with able text.

221
00:12:23,510 --> 00:12:26,300
But we have a problem because once again it works with data.

222
00:12:26,300 --> 00:12:27,540
So basically it's going to generate.

223
00:12:27,920 --> 00:12:29,060
That doesn't make sense.

224
00:12:29,690 --> 00:12:33,130
So we'll run our percentage for you.

225
00:12:33,590 --> 00:12:34,220
All right, great.

226
00:12:34,520 --> 00:12:40,600
So let's thing that I want to try out is creating a function instead inside of a macro.

227
00:12:40,610 --> 00:12:42,920
So basically this is exactly what we are going to do.

228
00:12:43,340 --> 00:12:46,790
So here we are going to use an if function and what exactly you want to do.

229
00:12:46,790 --> 00:12:49,160
So basically each time we refresh the numbers here will change.

230
00:12:50,570 --> 00:12:54,820
So when I create a really simple if function, so what exactly it does.

231
00:12:55,100 --> 00:12:57,430
So if we read this function is pretty simple.

232
00:12:57,620 --> 00:13:06,980
So if in this case each five, which is this case right here, is greater than 20, I want myself to

233
00:13:06,980 --> 00:13:07,190
be.

234
00:13:07,190 --> 00:13:07,730
Yes.

235
00:13:07,850 --> 00:13:10,190
Otherwise I want my self to be.

236
00:13:10,190 --> 00:13:10,660
No.

237
00:13:10,910 --> 00:13:13,550
So it's pretty simple to understand and pretty straight to the point.

238
00:13:13,790 --> 00:13:16,370
And let's say I want to test some of my skills.

239
00:13:16,820 --> 00:13:21,260
So what I can do is basically rewrite the whole function for each cell that I want to test.

240
00:13:21,560 --> 00:13:22,730
But I don't want to do this.

241
00:13:22,760 --> 00:13:24,260
What I want to do is pretty simple.

242
00:13:24,530 --> 00:13:26,120
I want to be able to do it in one step.

243
00:13:26,120 --> 00:13:29,870
Yes, I can copy and paste once again for the purpose of this quiz.

244
00:13:30,110 --> 00:13:32,870
I want to use macros, so this is exactly what I will do.

245
00:13:32,870 --> 00:13:36,670
So we'll start with the first step right here.

246
00:13:38,480 --> 00:13:39,590
It bothers me a little bit.

247
00:13:39,830 --> 00:13:43,580
So basically we'll start with the we'll do it right there.

248
00:13:43,590 --> 00:13:44,480
So pretty simple.

249
00:13:45,080 --> 00:13:50,360
What I want to do right now is simply using a relative reference at first, then recording macro and

250
00:13:50,360 --> 00:13:52,640
we'll call it test one.

251
00:13:54,300 --> 00:14:00,590
So pretty simple right now, what I will do is simply trying what I want to do, so I'll write down

252
00:14:00,630 --> 00:14:03,370
equal and then I write down my function.

253
00:14:03,390 --> 00:14:05,340
So if in this case.

254
00:14:07,020 --> 00:14:11,160
This function right here is greater than 20.

255
00:14:12,390 --> 00:14:15,010
I want Excel to return.

256
00:14:15,190 --> 00:14:19,980
Yes, it's a really important not forget those parenthesis inside of your yes.

257
00:14:20,670 --> 00:14:23,100
Otherwise, I want Excel to return.

258
00:14:23,220 --> 00:14:23,640
No.

259
00:14:25,260 --> 00:14:31,800
Once again, pretty simple, and then I can run everything, so in this case, it's yes, because it's

260
00:14:31,800 --> 00:14:32,990
greater than 20.

261
00:14:33,660 --> 00:14:34,300
So that's it.

262
00:14:34,320 --> 00:14:35,360
I have my my career ready.

263
00:14:35,370 --> 00:14:37,500
I can stop recording then.

264
00:14:37,500 --> 00:14:40,860
What I want to do is simply run my crew at another place.

265
00:14:41,080 --> 00:14:43,140
So that's one that's right there.

266
00:14:43,530 --> 00:14:44,220
I can run it.

267
00:14:44,340 --> 00:14:46,200
As you can see, it works pretty fine.

268
00:14:46,650 --> 00:14:48,230
So everything works perfectly.

269
00:14:48,750 --> 00:14:55,290
And also, since it's a relative reference, it will automatically do the test for DLH 14.

270
00:14:55,310 --> 00:15:00,480
It's not going to do this test for the cell that is right here, which is pretty cool.

271
00:15:00,480 --> 00:15:02,400
So I can run my test anywhere.

272
00:15:02,630 --> 00:15:06,450
I just can see it's pretty simple to understand and pretty simple.

273
00:15:06,450 --> 00:15:09,950
Well, I'm not talking about the functions, but I'm talking about the MacRobert.

274
00:15:09,960 --> 00:15:15,270
It's pretty simple to another tip that I can give you guys when you are working with macros, when you're

275
00:15:15,300 --> 00:15:19,200
recording your Michu, don't click everywhere, so don't click everywhere.

276
00:15:20,130 --> 00:15:24,390
What's going to happen is that all those things will be recorded as well.

277
00:15:24,600 --> 00:15:30,390
So we will have a lot of chances to have bugs or errors and set inside of your macros.

278
00:15:30,810 --> 00:15:36,210
This is that usually that what's happened, what happens when people click everywhere when they're recording

279
00:15:36,210 --> 00:15:36,840
their macros.

280
00:15:37,170 --> 00:15:38,220
So go straight to the point.

281
00:15:38,520 --> 00:15:41,930
So basically you select you click only on the cells that you guys will use.

282
00:15:42,060 --> 00:15:48,510
So basically that's the simplest way to not have errors when you guys are working with macros.

283
00:15:49,380 --> 00:15:54,180
So right now, basically, this class was really for practicing everything that we have just learned.

284
00:15:54,570 --> 00:16:02,850
And to also show you what you guys can do with macros and how you can work with macros on a day to day

285
00:16:02,850 --> 00:16:05,220
basis when you guys are working with Excel.

286
00:16:05,580 --> 00:16:08,910
So that's at first class guys insu on our next class.