1
00:00:00,210 --> 00:00:06,670
And welcome back to another class, of course, about the complete introduction to the debate with Excel.

2
00:00:07,950 --> 00:00:11,160
So in the past few classes, we learn pretty cool things.

3
00:00:11,880 --> 00:00:18,960
So basically, as you can see here, we have created a macro that enables us the capacity of generating

4
00:00:18,960 --> 00:00:20,680
this table right there.

5
00:00:21,060 --> 00:00:23,120
So once again, it's pretty cool.

6
00:00:23,130 --> 00:00:28,390
And right now it only requires us one click to be able to generate all this table.

7
00:00:28,410 --> 00:00:29,670
Well, three clicks.

8
00:00:29,880 --> 00:00:34,340
We can do it even in one click to be able to generate all of this table.

9
00:00:35,250 --> 00:00:38,220
What I wanted to do, what I want to do today is pretty simple.

10
00:00:38,250 --> 00:00:41,170
So basically, we're going to work on the exact same project.

11
00:00:41,190 --> 00:00:44,820
So this project right here, we're going to recreate it.

12
00:00:45,120 --> 00:00:48,700
But but but but we are going to add a really interesting feature.

13
00:00:49,140 --> 00:00:50,250
So pretty simple.

14
00:00:50,640 --> 00:00:57,240
Let's say we are here and basically what we want to do, we want to work with our Mac.

15
00:00:57,360 --> 00:00:58,630
So pretty simple as always.

16
00:00:58,630 --> 00:00:59,460
We're going to go here.

17
00:00:59,460 --> 00:01:00,750
We got to run our step.

18
00:01:00,750 --> 00:01:06,000
Number one, as you can see, we will have our numbers and names right here if we want our step number

19
00:01:06,000 --> 00:01:07,590
two, same thing.

20
00:01:08,220 --> 00:01:10,620
And if we are step number three, it's going to come there.

21
00:01:10,860 --> 00:01:12,120
But there is one problem.

22
00:01:12,630 --> 00:01:14,550
We can run all our macros.

23
00:01:14,550 --> 00:01:21,180
But the the run simply here, let's say, for example, we want to run our table right there or right

24
00:01:21,180 --> 00:01:22,080
there or right there.

25
00:01:22,210 --> 00:01:28,710
Well, it's not really possible because we have used absolute references in the case of this table right

26
00:01:28,710 --> 00:01:28,920
there.

27
00:01:29,760 --> 00:01:35,230
So what I want to do in this class is teach you how to run your macros, whatever you want.

28
00:01:35,250 --> 00:01:38,220
So basically, you can run them whatever you want on this table.

29
00:01:39,210 --> 00:01:41,220
And you'll see it's pretty simple.

30
00:01:41,220 --> 00:01:43,410
And what we can do with this is pretty cool.

31
00:01:44,670 --> 00:01:48,990
So basically what we are going to use, we are going to use this little button that is just here, which

32
00:01:48,990 --> 00:01:51,060
is using relative references.

33
00:01:51,720 --> 00:01:52,730
So you'll see it's pretty cool.

34
00:01:52,740 --> 00:01:59,670
So what I said what I just said is that you will be able to run all your macros anywhere you want on

35
00:01:59,670 --> 00:02:00,260
this table.

36
00:02:01,230 --> 00:02:02,070
So let's start.

37
00:02:02,370 --> 00:02:05,660
Basically, what we are going to do today is the exact same project.

38
00:02:05,700 --> 00:02:10,650
So we'll start with the first step, which would be writing down numbers and names.

39
00:02:11,070 --> 00:02:11,890
So pretty simple.

40
00:02:12,060 --> 00:02:13,990
This is exactly what we are going to do.

41
00:02:14,280 --> 00:02:19,380
So first of all, we click on use relative references to be able to use relative references and then

42
00:02:19,380 --> 00:02:20,860
we are going to record or macro.

43
00:02:21,390 --> 00:02:27,660
So in this case, we are at the project number two and we are at the step number one.

44
00:02:28,740 --> 00:02:34,600
One last thing, if you want to put a space right here, it's not going to work because it doesn't allow

45
00:02:34,600 --> 00:02:35,400
you to do so.

46
00:02:35,430 --> 00:02:36,640
So as you can see, it doesn't work.

47
00:02:36,660 --> 00:02:41,140
So just put everything together and then you just click on, OK?

48
00:02:41,640 --> 00:02:41,970
All right.

49
00:02:42,000 --> 00:02:43,810
So right now we are recording our macro.

50
00:02:44,010 --> 00:02:47,130
So first thing, we just put everything here together.

51
00:02:48,180 --> 00:02:58,280
We merge the cells, we write the number and names, and that's it.

52
00:02:58,710 --> 00:03:02,010
Then we can just stop the recording of or macros.

53
00:03:02,490 --> 00:03:04,680
Right now we have our macro right here.

54
00:03:04,950 --> 00:03:09,630
So basically, if we want to run it somewhere, so let's run it right here.

55
00:03:10,950 --> 00:03:17,610
As you can see, it runs perfectly, so if we run it right there once again, it's perfect and that

56
00:03:17,640 --> 00:03:19,230
works perfectly, which is pretty good.

57
00:03:20,490 --> 00:03:21,840
Now we have one small problem.

58
00:03:21,840 --> 00:03:27,730
It's that we didn't put it inside of a table, so we can just do it once again.

59
00:03:27,750 --> 00:03:28,420
Pretty simple.

60
00:03:28,440 --> 00:03:30,330
Just delete this one right here.

61
00:03:33,070 --> 00:03:34,900
There we delete it and we'll do it again.

62
00:03:34,930 --> 00:03:41,950
So pretty simple, we'll just use the relative reference we record or micro, we'll call it, as I said,

63
00:03:42,150 --> 00:03:49,210
to step one and click on OK, and then we can recreate our macro.

64
00:03:49,300 --> 00:03:52,360
So basically, we'll just select ourselves, will merge them together.

65
00:03:52,690 --> 00:03:59,050
We'll write down numbers and names and that's it.

66
00:04:00,220 --> 00:04:03,280
Then we can just stop recording.

67
00:04:04,210 --> 00:04:05,800
So right now we have everything that we need.

68
00:04:05,800 --> 00:04:10,650
We can test our macro to see if it works fine so we can see it works perfectly fine.

69
00:04:11,590 --> 00:04:13,860
So everything works perfectly fine.

70
00:04:15,310 --> 00:04:16,600
One less thing.

71
00:04:16,600 --> 00:04:23,020
If you have an issue and let's say, for example, you are running your macro and that instead of running

72
00:04:23,020 --> 00:04:26,660
at the right place, it runs somewhere right here or somewhere right here.

73
00:04:26,920 --> 00:04:31,810
This means when you were recording your macro, you were clearing either on the enter button, either

74
00:04:31,810 --> 00:04:32,920
you were playing around.

75
00:04:32,950 --> 00:04:37,570
So basically, this could be a bug with what you have did.

76
00:04:38,430 --> 00:04:39,210
So pretty simple.

77
00:04:39,220 --> 00:04:43,150
The second step, as I said, will be writing or creating this table right here.

78
00:04:43,160 --> 00:04:45,550
So instead of each here, we'll write down a number.

79
00:04:46,330 --> 00:04:49,370
So here will have no one in here will have number two.

80
00:04:51,370 --> 00:04:52,100
So pretty simple.

81
00:04:52,390 --> 00:04:52,800
All right.

82
00:04:52,810 --> 00:04:55,290
So let's just rewind our macro.

83
00:04:55,720 --> 00:04:59,890
So we'll go in the developer tab and we will run our macro.

84
00:04:59,890 --> 00:05:00,070
Right.

85
00:05:00,080 --> 00:05:01,790
So everything is at its place.

86
00:05:02,230 --> 00:05:05,410
So, as I said, the second step is recording or micro.

87
00:05:05,410 --> 00:05:06,880
So we click on a record.

88
00:05:08,440 --> 00:05:11,410
It's going to be project number two.

89
00:05:11,950 --> 00:05:13,450
Step number two.

90
00:05:14,230 --> 00:05:15,010
So pretty simple.

91
00:05:15,070 --> 00:05:15,450
All right.

92
00:05:15,490 --> 00:05:18,020
So right now we are going to record our macro.

93
00:05:18,160 --> 00:05:19,460
So here will have a name.

94
00:05:20,470 --> 00:05:21,550
I will have.

95
00:05:23,380 --> 00:05:26,720
So first thing that we recording will be our name.

96
00:05:28,270 --> 00:05:30,560
Then we are going to record number one.

97
00:05:30,580 --> 00:05:31,120
So we're right.

98
00:05:31,390 --> 00:05:34,030
Number one here.

99
00:05:38,170 --> 00:05:39,880
And you will have no.

100
00:05:43,450 --> 00:05:44,920
So right now, we have everything that we need.

101
00:05:46,010 --> 00:05:50,810
Now, next thing will simply be putting everything together right here.

102
00:05:52,470 --> 00:05:53,360
So here we go.

103
00:05:54,390 --> 00:05:54,900
This way.

104
00:05:56,900 --> 00:06:00,080
And then here we are going to add the some.

105
00:06:09,450 --> 00:06:10,630
Here are the calculations.

106
00:06:10,650 --> 00:06:15,840
So basically here will have this will write down the calculations, so this will be equal to the sum

107
00:06:16,290 --> 00:06:17,420
of all this.

108
00:06:17,460 --> 00:06:18,570
So all those numbers.

109
00:06:24,800 --> 00:06:30,130
And same thing right here, some of all those numbers right there.

110
00:06:32,200 --> 00:06:34,000
And finally, the last step, just putting.

111
00:06:35,390 --> 00:06:36,560
I think some little things.

112
00:06:37,010 --> 00:06:37,490
All right, great.

113
00:06:37,540 --> 00:06:39,100
So right now we have everything that we need.

114
00:06:39,110 --> 00:06:40,880
We can stop the recording.

115
00:06:42,080 --> 00:06:46,360
So right now what we are going to do, we are just going to generate everything so pretty simple.

116
00:06:46,910 --> 00:06:52,250
We are going to go here and trying to generate this second step so you can see the whole table have

117
00:06:52,250 --> 00:06:55,190
been generated so we can do the same thing right there.

118
00:06:56,840 --> 00:07:03,380
Once again, we ran it, as can see, everything is perfectly integrated, and if we generate that step

119
00:07:03,380 --> 00:07:06,210
one, we can just generate it right here.

120
00:07:06,260 --> 00:07:11,010
So as you can see here, we have our step one and our step two that are working perfectly.

121
00:07:12,350 --> 00:07:12,740
All right.

122
00:07:12,750 --> 00:07:16,550
So last thing that we want to do, pretty simple.

123
00:07:16,970 --> 00:07:23,300
We want to create our step number three, that we are going to be able to generate also.

124
00:07:24,840 --> 00:07:27,300
Just merge everything to delete it, delete it.

125
00:07:29,010 --> 00:07:30,690
So here is our step number three.

126
00:07:31,170 --> 00:07:31,560
All right.

127
00:07:31,560 --> 00:07:32,940
So pretty simple right now.

128
00:07:32,950 --> 00:07:39,330
What I'm going to do, instead of just creating this step number three, I'm going to recreate the whole

129
00:07:39,330 --> 00:07:39,840
project.

130
00:07:40,500 --> 00:07:42,710
So pretty simple right now.

131
00:07:42,720 --> 00:07:47,810
What I'm going to do, as I said, creating the whole project and stacking it as one macro.

132
00:07:47,880 --> 00:07:51,520
So this way you will be able to see that it's possible to put everything inside of one macro.

133
00:07:51,530 --> 00:07:54,600
So if you want, we can do the exact same thing with me.

134
00:07:55,200 --> 00:07:56,100
So pretty simple.

135
00:07:56,100 --> 00:07:57,600
Let's start.

136
00:07:58,500 --> 00:08:00,390
So we'll go right here.

137
00:08:00,780 --> 00:08:03,380
So, as always, it's going to be our developer tab.

138
00:08:04,050 --> 00:08:10,200
What we're going to do right now, we are going to record our macro some pretty simple project.

139
00:08:10,200 --> 00:08:12,970
Number two will call it full.

140
00:08:14,550 --> 00:08:16,990
And here we are going to create micro.

141
00:08:17,250 --> 00:08:26,940
I forgot one little thing so you can see here I forgot to click on our user relative references.

142
00:08:27,690 --> 00:08:34,230
So it will start again with our micro project to for.

143
00:08:35,180 --> 00:08:39,320
Great, right now, what we are going to do, we are going to record our project.

144
00:08:40,280 --> 00:08:47,150
So a first step, pretty simple as always, we select ourselves, we merge them and write down numbers

145
00:08:47,540 --> 00:08:48,980
and names.

146
00:08:50,240 --> 00:08:58,630
So once we have this, we come back here, we select our first case that will be name.

147
00:09:00,080 --> 00:09:01,730
Then we'll have number one.

148
00:09:07,590 --> 00:09:09,900
Then we'll have number two.

149
00:09:16,210 --> 00:09:22,150
Then was like this, then here will have that some.

150
00:09:27,070 --> 00:09:29,500
Here will have the sum of everything.

151
00:09:31,740 --> 00:09:34,690
So this will be equal to the formula of the sum.

152
00:09:35,240 --> 00:09:36,870
So, once again, the sum of all this.

153
00:09:39,640 --> 00:09:45,300
So you're pretty much the same thing, so the sum of all this.

154
00:09:47,840 --> 00:09:51,260
Finally, we're going to go to the second place right here.

155
00:09:52,040 --> 00:09:53,410
Here will have the name.

156
00:09:53,690 --> 00:09:54,770
So once again, name.

157
00:09:59,440 --> 00:10:00,130
The number.

158
00:10:05,010 --> 00:10:11,340
And right there, we're going to select all those cases, finally the some.

159
00:10:12,530 --> 00:10:14,540
So right here, we'll have the some.

160
00:10:19,020 --> 00:10:26,560
And here, some of our numbers, so we'll have the sell off of our numbers right there.

161
00:10:27,360 --> 00:10:27,720
Great.

162
00:10:29,310 --> 00:10:36,470
So right now we have our macro as a whole so we can stop recording and we can try to run our macro somewhere.

163
00:10:36,660 --> 00:10:38,790
So we'll just delete this macro.

164
00:10:41,960 --> 00:10:46,670
Delete everything that we have written right here, and we'll try to run our macro somewhere right there,

165
00:10:46,670 --> 00:10:47,970
let's say, for example, run it here.

166
00:10:48,770 --> 00:10:49,550
So pretty simple.

167
00:10:49,560 --> 00:10:55,760
We come back here and we use our relative, our macros, and we can run our micro right here.

168
00:10:55,760 --> 00:10:58,190
And then, as you can see, everything runs perfectly.

169
00:10:59,060 --> 00:11:00,530
So next step is pretty simple.

170
00:11:00,530 --> 00:11:05,960
It's just adding our numbers to test everything so we can copy the numbers that we have right here and

171
00:11:05,960 --> 00:11:07,400
just adding add them.

172
00:11:10,010 --> 00:11:15,450
So we forgot to add one thing to our macro, which is to copy everything from here.

173
00:11:16,310 --> 00:11:18,880
So pretty simple, we can just add it manually.

174
00:11:19,250 --> 00:11:26,060
But basically what you guys can do is simply copy and paste the same thing for the numbers.

175
00:11:27,470 --> 00:11:34,760
So we forgot to add the operation, which is pretty simple, so he will do the same thing, so it will

176
00:11:34,760 --> 00:11:38,330
be equal to this number plus this number.

177
00:11:40,290 --> 00:11:41,290
So here we go.

178
00:11:42,330 --> 00:11:44,160
All right, so right now I did it manually.

179
00:11:44,700 --> 00:11:47,280
Once again, you can do it with a macro.

180
00:11:47,640 --> 00:11:52,950
So let's think what's also possible to do, it's also possible to, for example, create a graph for

181
00:11:52,950 --> 00:11:53,870
our macros.

182
00:11:53,900 --> 00:11:55,820
Let's say, for example, I want to create a graph.

183
00:11:55,830 --> 00:11:56,670
It's pretty simple.

184
00:11:56,970 --> 00:12:03,660
I can just select the whole thing right here and just generate a graph with it, whatever I want.

185
00:12:03,690 --> 00:12:06,380
So it's pretty much the same way for it to generate a graph.

186
00:12:07,830 --> 00:12:09,350
So I'm going to go in developer.

187
00:12:09,570 --> 00:12:12,990
So use relative reference record macros.

188
00:12:13,440 --> 00:12:14,820
So I'll call it graph.

189
00:12:17,140 --> 00:12:24,400
And OK, so pretty simple, what I'm going to do, I'm just going to click on insur select, my numbers

190
00:12:24,790 --> 00:12:29,080
will select everything that I need to select and just click on the recommended chart.

191
00:12:29,830 --> 00:12:31,460
Here I have my chart.

192
00:12:31,990 --> 00:12:32,540
So here we go.

193
00:12:32,620 --> 00:12:34,270
I have my chart that have been created.

194
00:12:34,930 --> 00:12:35,770
So pretty simple.

195
00:12:37,000 --> 00:12:41,390
Come back to my developers, stop recording, and normally everything should work fine.

196
00:12:42,310 --> 00:12:44,560
So if I run my Gref micro.

197
00:12:49,440 --> 00:12:54,870
Actually, oil from indico, so we have our chart right here that have been generated.

198
00:12:55,860 --> 00:12:57,720
So as you can see, it works pretty fine.

199
00:12:58,170 --> 00:12:58,480
All right.

200
00:12:58,500 --> 00:12:59,470
So pretty simple.

201
00:13:00,510 --> 00:13:03,630
So right now, what you guys have learned is pretty simple.

202
00:13:03,630 --> 00:13:10,350
You guys right now know how to basically run your macros anywhere you want on your Excel chart.

203
00:13:10,840 --> 00:13:12,180
Well, on your Excel workbook.

204
00:13:12,180 --> 00:13:14,700
So let's say, for example, on this macro right here.

205
00:13:14,700 --> 00:13:15,300
Right there.

206
00:13:15,310 --> 00:13:19,400
So it's possible I can just go on my developer tab, choose the macro that I want to run.

207
00:13:19,410 --> 00:13:24,540
So in this case, project to full, I can run it right here and it has run there.

208
00:13:24,570 --> 00:13:26,550
I can do the exact same thing right here.

209
00:13:26,880 --> 00:13:31,650
So I select my micro project to full and works perfectly.

210
00:13:31,680 --> 00:13:33,600
So right now I just need to add the numbers.

211
00:13:33,600 --> 00:13:38,520
And basically one problem that we forgot to do is simply adding the calculations right there.

212
00:13:38,910 --> 00:13:42,000
But besides of that, it's not that much of a big deal.

213
00:13:42,780 --> 00:13:47,130
So right now, what you guys have learned, you have learned how to use the relative reference with

214
00:13:47,130 --> 00:13:48,210
your macros.

215
00:13:48,630 --> 00:13:50,250
So you'll see right now it's pretty cool.

216
00:13:50,460 --> 00:13:52,470
So we are still in the creation?

217
00:13:52,470 --> 00:13:55,270
Well, in the macro creation part of this course.

218
00:13:55,590 --> 00:13:56,640
So that's it for us guys.

219
00:13:56,640 --> 00:13:58,650
And see our next class.