8 hours 33 minutes
in this macho man. This is the final module of this course.
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.
So these three examples three will be
1st 1 will be to, um,
how to enter data in excel using forms and cow tow perform calculation within these forms.
Ah. Then 2nd 1 will be how to create
quiz air tests with grading so
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.
ah, the end. We're going to, um,
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,
this Ah, this Axl, a macro or sheet will create ranking and make the list of competitors for the finals race.
So about details off each of these examples are exercises. We're going to talk directly in them.
Eso Let's open the 1st 1 and the 1st 1 is to create it. So the first task, the first exercise,
is to create form that will calculate third side of triangle, which has one great angle
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
all three of them,
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
formula for this is a squared plus B squared equals age square. Their ages can heip witness. So, um
uh, let's, uh, get started with this, uh, immediately
by going into
developer and let's first see how to create form.
So let's open this
and let's click here and we could use their form
and here he could get the basic user form.
And here is also toolbox that we can use to create
this form. So
in this form we should have three fields
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.
So we're creating three labels. So 1st 1 is a
that one should be
Yeah, we conflict curing properties and see here we have a front.
So we want some other Funt
finds the one that we want.
Then we select the style of the front and then re select a size. For example, 16.
There is also encoding or called Paige,
and we clean
this and this is not big enough. So we want to be bigger. So it's so 20.
And let's, uh,
do you see it?
Let's move it a little bit from the corner.
Let's also say we don't want capital A. We want lower case A
and we have first label.
it's press control shift. Story doesn't work here.
Let's ah, copy this Control C and then paste.
And let's create another one
which is going to be B
and gentle. It's based it again
and create a tch.
Now it could have been C as well, but I like it better this way. So So we have those three
and then we want to put here the space in which we can enter
the values. So it's going to be called tech stocks.
let's put this text books here
and let's look at the properties so the
text is also going to be a different one.
So let's find the one that we're using.
let's not make it a ball because it's just entry
And then let's, uh, look here
So we need this one as well and paste again, and we need 1/3 1
And that's pretty much it from the fields that we need
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
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
fields. They have no function.
So what we have to add
is button command button and the end.
And let's put it here
and let's change text in debt. Common button. Let's see,
And let's also change that front
to the same one where we were using. Let's put T o B size 12. Let's be extra bold here. This
So now we have
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
background color because we don't want to be displaying
gray. So let's make it slightly or interesting, okay? Or maybe
maybe like this one.
Now that's too
So you can pick their choose. You cannot pick.
sorry. You cannot pick.
You don't have the core picker or chooser.
So let's go with this one. It's a nice one.
But then we also have to change the same background color off these labels.
let's go here
just for them not to be different than the background
and speak of
you see you quick and something happens which didn't expect
and also this one.
So let's change the color
and yeah, this is it. And maybe we click back on this one. Now the border doesn't fit
well, so we want this border to be,
uh, let's make it
yeah, it's, uh
it's changed. This is Well, no, we don't need that. Okay, so we have to check one more thing
before we finish
creation of the form.
And this is this field which is called Tab Index.
So if you start typing
in this form and you don't want to use mouse, then you want this one to be first
and this one Toby
and this one to be
and then you won't calculate to be
So basically it will start to the
course air here, and then you can just type in click tab and click, enter, radiant
and let's stop for now. And in continuance of this lesson, we're going to see next what to do with this?
Data Analyst Excel
The Data Analyst Excel Test is a premium Cybrary assessment created by iMocha and intended ...
Monitor a Web App
In this IT Pro challenge, participants get hands-on experience activating server logging and using Application ...
Learn On Demand