Time
8 hours 33 minutes
Difficulty
Intermediate
CEU/CPE
9

Video Transcription

00:01
So when we created this macro copy constants,
00:06
we have assigned it to a shortcut keeper Charcot, which was control shift. Then,
00:10
um, you can also assign macro
00:15
toe a button that you creating an excel. So, for example, during some calculation, and in the end, you want to start your macro anyone people to be able to use it without actually remembering what?
00:28
What shortcut is for that macro? Or you have several Mac Rose and you want them
00:34
easily accessible.
00:37
So you go
00:38
here the home
00:41
Sorry
00:42
to insert
00:44
and you go to shapes and you select some shape you want to use. For example,
00:50
this one
00:52
and then you added techs just
00:57
copy,
00:59
constant.
01:00
So you want to these continents to be this? This doesn't have to be the same.
01:07
Um,
01:07
text, like in the name of the macro, just has to describe you what you want to do with it.
01:14
So we put it centered, just make it nicer.
01:19
We select the text and we can make it larger just
01:25
for it to fit better into button.
01:27
Then click on button.
01:30
Sorry.
01:33
And we have the option to assign macro,
01:37
and it will give us the
01:41
name of the macro by default, which is the name of the object. We're assigning macro too. But we actually want to assign
01:51
this micro.
01:53
You just say OK,
01:55
so let's hear type
01:59
again.
02:00
Formulas.
02:04
All right,
02:06
so we have formulas here
02:08
and we click here and we get concert. So the macro has been executed,
02:13
and, uh,
02:15
we
02:16
have now the
02:20
button that is
02:23
doing the same function as a keyboard shortcut.
02:28
But it is now completely clear
02:31
to everybody using this.
02:35
They s spreadsheet, the worksheet, what it's actually doing. Now, you see that
02:40
when we click here and we try to move it,
02:45
it will just perform the macro again again. So if you want to move this,
02:51
put it in some other position In inside
02:53
you're
02:55
you have to,
02:59
right click
03:00
and, uh,
03:04
cut it and placed it somewhere else.
03:07
So,
03:13
yeah,
03:14
or you can do it with control.
03:16
So you can you can
03:19
click here on the edge of it.
03:22
Sorry. Come here, press control.
03:29
And then you can move it around. You release the control before you,
03:35
you know,
03:36
released the mouse button. Because in that case
03:39
it will make a copy like I just did before. So this is it. So we just moved it. It's active, so you cannot still anything with it
03:51
while he's like that.
03:52
So,
03:53
uh, this is about the basic
03:57
micro, how to create it, how to edit it
04:00
and also how to, um,
04:02
assign it to a button.

Up Next

Intermediate Excel

Being an intermediate level user of Excel can help save a user hours of work time and take full advantage of the Excel application. Taking an intermediate Excel training will help students advance their skills and pass an intermediate Excel exam.

Instructed By

Instructor Profile Image
Milan Cetic
IT Security Consultant
Instructor