Time
8 hours 33 minutes
Difficulty
Intermediate
CEU/CPE
9

Video Transcription

00:01
in this macho man. This is the final module of this course.
00:05
Uh, I'm going to show you how to do three exercises which represent practical examples off things that can be used in real life in itself.
00:21
So these three examples three will be
00:25
1st 1 will be to, um,
00:28
how to enter data in excel using forms and cow tow perform calculation within these forms.
00:35
Ah. Then 2nd 1 will be how to create
00:41
quiz air tests with grading so
00:44
that student can open an excel file and gets a list of questions. Clicks, um, ABC answers and then finished gets the information if they have passed or not.
00:58
And, uh
01:00
ah, the end. We're going to, um,
01:03
do the exercises, which you you will see how we're going to create chart in which the data from the semifinals off 100 meters race is entered. And based on these results,
01:23
this Ah, this Axl, a macro or sheet will create ranking and make the list of competitors for the finals race.
01:37
So about details off each of these examples are exercises. We're going to talk directly in them.
01:46
Eso Let's open the 1st 1 and the 1st 1 is to create it. So the first task, the first exercise,
01:55
is to create form that will calculate third side of triangle, which has one great angle
02:00
based on the length of other too. So you are supposed to create. We're supposed to create form which will have feels to enter
02:10
all three of them,
02:13
and the user is supposed to enter just two of them and then to calculate the third based on the values off first to. So if you don't remember, the
02:27
formula for this is a squared plus B squared equals age square. Their ages can heip witness. So, um
02:37
uh, let's, uh, get started with this, uh, immediately
02:42
by going into
02:45
developer and let's first see how to create form.
02:50
So let's open this
02:54
and let's click here and we could use their form
03:00
and here he could get the basic user form.
03:05
And here is also toolbox that we can use to create
03:08
this form. So
03:14
in this form we should have three fields
03:16
in which to enter numbers, and first of all, we want to mark them. So let's say the 1st 1 is going to be and this this is called label.
03:25
So we're creating three labels. So 1st 1 is a
03:31
and, uh,
03:36
that one should be
03:38
with Ah,
03:42
sorry. Here.
03:50
Yeah, we conflict curing properties and see here we have a front.
03:54
So we want some other Funt
04:00
and we
04:02
finds the one that we want.
04:05
Then we select the style of the front and then re select a size. For example, 16.
04:13
There is also encoding or called Paige,
04:16
and we clean
04:19
this and this is not big enough. So we want to be bigger. So it's so 20.
04:28
And let's, uh,
04:30
do you see it?
04:31
Let's move it a little bit from the corner.
04:34
Let's also say we don't want capital A. We want lower case A
04:43
and we have first label.
04:46
Then
04:46
it's press control shift. Story doesn't work here.
04:50
Let's ah, copy this Control C and then paste.
04:58
It's here.
05:00
And let's create another one
05:02
which is going to be B
05:06
and gentle. It's based it again
05:10
and create a tch.
05:14
Now it could have been C as well, but I like it better this way. So So we have those three
05:20
and then we want to put here the space in which we can enter
05:28
the values. So it's going to be called tech stocks.
05:33
And
05:35
let's put this text books here
05:39
and let's look at the properties so the
05:43
text is also going to be a different one.
05:49
So let's find the one that we're using.
05:54
That's what
05:56
fund
05:58
let's not make it a ball because it's just entry
06:01
Next.
06:02
And then let's, uh, look here
06:08
copy
06:10
based.
06:12
So we need this one as well and paste again, and we need 1/3 1
06:20
And that's pretty much it from the fields that we need
06:26
to enter
06:28
now. What we can also change here is the name of user form. But I'm going to leave it like this because you just
06:34
let's not complicate things at this point. So the point of this exercise is for you to see how to create the form. Now in every form, just thes
06:44
fields. They have no function.
06:46
So what we have to add
06:49
is button command button and the end.
06:54
And let's put it here
06:58
and let's change text in debt. Common button. Let's see,
07:03
calculate.
07:08
And let's also change that front
07:12
again
07:17
to the same one where we were using. Let's put T o B size 12. Let's be extra bold here. This
07:28
So now we have
07:30
this form almost finished. So let's just make it a little bit smaller because we don't need this extra space. And let's change the
07:45
background color because we don't want to be displaying
07:49
gray. So let's make it slightly or interesting, okay? Or maybe
07:57
maybe like this one.
07:59
Now that's too
08:01
Okay.
08:03
So you can pick their choose. You cannot pick.
08:07
Um,
08:09
sorry. You cannot pick.
08:13
Ah,
08:15
here.
08:16
You don't have the core picker or chooser.
08:18
So let's go with this one. It's a nice one.
08:22
But then we also have to change the same background color off these labels.
08:31
So
08:31
let's go here
08:33
just for them not to be different than the background
08:39
and speak of
08:41
Yeah,
08:41
you see you quick and something happens which didn't expect
08:46
and also this one.
08:50
So let's change the color
08:54
and yeah, this is it. And maybe we click back on this one. Now the border doesn't fit
09:01
well, so we want this border to be,
09:05
uh, let's make it
09:07
like this.
09:11
And, uh,
09:15
yeah, it's, uh
09:18
it's changed. This is Well, no, we don't need that. Okay, so we have to check one more thing
09:24
before we finish
09:26
creation of the form.
09:30
And this is this field which is called Tab Index.
09:33
So if you start typing
09:37
in this form and you don't want to use mouse, then you want this one to be first
09:43
and this one Toby
09:46
second
09:48
and this one to be
09:52
thirds,
09:52
and then you won't calculate to be
09:56
fort.
09:58
So basically it will start to the
10:01
course air here, and then you can just type in click tab and click, enter, radiant
10:07
and let's stop for now. And in continuance of this lesson, we're going to see next what to do with this?

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