### Intermediate Excel

Course
Time
8 hours 33 minutes
Difficulty
Intermediate
CEU/CPE
9

### Video Transcription

00:00
so so far you have seen how we create Mac Rose as a subroutine. Whether we recorded or we type it,
00:09
it's a 17 that can be cold from another 17 or function.
00:14
But now let's create a function
00:17
within Excel using macros, a visual basic.
00:23
This function can be then cold in a cell like any of the other functioned. It exists in visual basic
00:31
that would take a visual basic.
00:35
We go to insert, we have module,
00:38
we select module
00:40
and then we type
00:44
function.
00:48
They're going to call it the oregano, and it's going to have
00:52
all right, number one
00:54
and them, too.
00:58
Parameters
01:02
and dysfunction is going to calculated the agonal off a triangle has one
01:07
right angle. So
01:11
sorry. Straight at the 90 degree angle. So, um,
01:15
it's, um
01:19
yeah, you know
01:21
is equal
01:23
two
01:25
sq r
01:27
off
01:30
them one,
01:34
someone,
01:37
waas
01:38
two.
01:40
Multiply it
01:44
but itself.
01:47
And, uh,
01:51
we just say, like save because this is it.
01:53
It's going to take number one. It's going to multiplied by itself. It's going to add number two multiplied by itself,
02:00
and then it's going to calculate square root of it.
02:07
And when we do this first time get this message which says that
02:13
we cannot save dysfunction
02:15
in a standard X l s X format. We have to save it in a format that supports my crows.
02:23
So we take here or no,
02:25
we get the same file and then here we select type as ex Elice em
02:32
save
02:35
you Close this.
02:37
And now we have
02:38
this module here as ex Ellis M, meaning that it campaigns macros.
02:44
So
02:45
didn't just stay there, Colonel
02:47
and Selectees too.
02:53
And the cantor and we get the number here,
02:57
which is exactly that. So,
02:59
um, just to make sure that
03:02
this is correct, we're going to type here three and four and we get five because it's ah, it's a common knowledge. If you remember your math in high school that to the triangle
03:16
that has to size three and four, the agonal is five.
03:21
03:23
well, how to create
03:27
Ah, you function.
03:30
And
03:31
what you have seen is also
03:35
that there. And I start typing equals and I just out d I
03:39
You get diagonal. So Excel already has put this function in the list of functions
03:46
and it's there. Andi, also,
03:50
if I go here, insert. Sorry.
03:54
Just this.
03:57
Okay,
03:58
Go into formulas and go to insert function.
04:01
And I say all and I go here.
04:06
It should be in the list.
04:12
Here it is.
04:13
So it's added to the list of all functions
04:16
in excel. So now you know what's the difference between sub macro and function macro and how to create one and the other.
04:28
And in, ah, next lesson, I'm going to talk about some other things that you can nicely do
04:35
in macros. Visual Basic.
04:40
So thank you.

### 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

Milan Cetic
IT Security Consultant
Instructor