### Intermediate Excel

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

### Video Transcription

00:00
Okay, so first of all, I made small mistake. So this is not here going to be result.
00:06
It's going to be Elaine.
00:08
So we're looking and in which lane
00:12
we're going to s o. We want somebody to be in Lane eight or lane four, and we want the name of that contestant.
00:22
And, uh, we know that
00:27
or sorry, we're going to determine Lane manually is going to be, like
00:32
position. So this guy's going to So we're going to ask, give us the name off the competitors that was in position, for example seven
00:42
and is going to written to us that.
00:45
Okay, so
00:47
way we're going to have a loop. So for I equals 1 to 8,
00:53
and then the question is going to ask and we want what we are going to ask. We're going to ask if
01:00
the position ah, off the S o. If
01:04
what is the name
01:07
off
01:10
competitors?
01:11
That is, for example, seventh
01:14
on the list.
01:17
So
01:18
01:22
tar
01:23
off
01:25
position
01:27
is equal tar off
01:30
I
01:33
And if that is the case, then
01:37
what we're going to do? We're going toe to toe. Look. Att. The name
01:46
So we have here,
01:48
we're going to different defined. This results or we're going to put it is a temporary variable.
01:53
So, for example, I don't know. This guy has qualified and we want him.
01:59
We find him
02:00
and way have this results. So we're going to score this result.
02:07
So
02:08
we're going to say
02:10
temp result
02:15
result.
02:20
Sorry.
02:22
Then result
02:25
is equal.
02:28
Two
02:29
tar
02:30
off. I
02:31
So death one
02:37
like this
02:38
may not actually can do it here.
02:44
You don't need block if
02:46
and we're going to just say next
02:49
I
02:51
And now we're going to go again
02:53
through entire list off competitors in the seven filed. Also for I equals 3 to 26.
03:06
And then we're going to have if and let's say that
03:13
them result is equal
03:17
to range. And well, now let's lift where the results are.
03:23
So it's f
03:28
and I
03:30
then
03:32
and what we're now returning.
03:35
It's
03:37
before I now name
03:40
is going to be equal to
03:44
Where is the name in cold e. So range
03:49
off E
03:51
and,
03:53
boy,
03:57
we're a simple
03:59
and again next I
04:02
and this is how it's done. So we found the result, and now we're going to put the name to that result and it's going to be
04:12
the value off the
04:15
home he's
04:15
we just have to put here Sorry.
04:19
Well, you
04:21
and here we have to put value
04:26
on and everything else is okay,
04:29
so we have finalized this module so it's called Final and M to save this close this
04:38
and then we're going to just say it's going to be final
04:42
and I am
04:44
and we have just one parameter also say this was seven
04:48
and then it's going to be cool for now
04:51
and I'm
04:54
so it's going to be five
04:57
on and let's copied
05:00
and then just changed this. So it's going to be three
05:04
and then the next he's going to be one
05:08
and it is going to be too
05:12
send
05:15
for
05:16
on six
05:20
and eight
05:25
and we got all of them.
05:28
And now what? The only thing left over for us to do
05:31
is to put here They're starting number
05:35
because that's the way that people helping the athletes in the
05:42
field
05:43
or the track
05:45
are going to know where to put the trunk.
05:47
So we're going to use simple look up command, so we're going to say
05:51
Look up
05:55
and then we're going to open.
05:57
And so what we're looking
06:00
is
06:00
this
06:03
and then the rain.
06:08
And this is wrong.
06:11
Yeah. So then look up, Director. So where are we looking Here
06:16
and where are we getting the results from?
06:20
It's here. We're going to close
06:23
and
06:24
get this. And let's just post here some dollar signs
06:30
this year
06:32
and here here.
06:35
So the results say the same. So let's just check if this is working so named 13 6 49 So it's clear
06:45
and we just expend this formula. And now we have created two functions that will help us that did help us do this job and with this job combining functions and custom functions, and now everything is ready for the final race. And now we're just waiting for
07:03
them to type in the results
07:05
and then the raking. So in the finals race, it's obviously for the finish, so ranking it usually happens that two competitors have the same result, so we're not going to do automatic ranking. It's going to be done by we're free or whoever is doing this, uh, manually.
07:24
So we have finished this
07:26
on dhe. The race can begin
07:29
and thank you for your attention in next module and just going to do the short recap off the entire
07:36
course. 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