Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:00
Okay, so we are now at the end of model four and we're now going to do the labs. I strongly suggest that if you have opened this video first,
00:09
you don't watch it through the end. Instead, you should open the Model four labs Excel file and try to do labs by yourself. You get stuck. Look, ATT, the instructions and
00:25
or this video. So, um, in this labs, we're going to create exchange rate software secretary, not exchange rates after, but the exchange rate table, which automatically give you the,
00:40
uh the
00:42
exchange rate and the amount in all other currencies according to one that you pick up. So this is our basic exchange rate table
00:52
that represents Ah,
00:55
the data we have pre entered
00:57
and now in Ah ah, tab model for labs. You should create
01:04
a table like the one that you have seen in the instructions,
01:10
Um,
01:11
a pdf file that comes with this labs.
01:17
So it should have exchange rate calculator as calculator as ah, heading.
01:23
And then it should be a date here, and we're going to use today function which give us today state,
01:30
and then we're going to merge these cells so that
01:34
it looks nicer and we're going to change the size.
01:40
So it looks like it is supposed to look like
01:42
and we're going to
01:46
change with size
01:48
off the
01:49
cones
01:55
like this. So it fits so that everything fits in.
02:00
And then we're going to set the comet equal for all of these cones
02:06
just to make it look nicer again. We're going to merge cells
02:10
and
02:15
see we have changed the front size and color
02:21
big runs size.
02:23
And now we are.
02:25
I'm going to use data
02:28
from the
02:29
change rate Basic table.
02:31
Just two.
02:34
Put them
02:36
in our
02:38
the sheet,
02:40
and then
02:45
we're going to go again and copy these files. We could type them as well, but this is easier thing to do.
02:53
Okay,
02:57
So the idea is that if you're looking, for example, how many years dollars is worked all other currencies,
03:04
you're going to just enter the amount for us dollars,
03:07
and the stable is going to calculate everything for you.
03:13
So we're going to make them
03:15
different colors
03:22
so that they match the
03:23
the colors that we have given is a task.
03:47
Okay, so
03:53
this is a little bit of former thing
04:06
We have used the former pager command to copy
04:10
the former. It's off
04:13
each currency
04:15
so
04:16
that they mentioned color.
04:40
Okay,
04:41
now we have finished the formal thing,
04:45
and now we're going to enter the formulas.
04:49
So you're going to see
04:53
for U. S dollar? It's the U. S. Dollar. There is no calculation.
05:21
And now we're going to use the exchange rates to calculate
05:26
the well use.
05:33
And of course, we can also named the cells.
05:39
So for example, this one we're going to call us dollar two euro
05:46
and this one will be used Dollar,
05:49
British pound,
06:00
and so on and so on.
06:35
And we're going to continue that with all off the cells.
06:53
So now we're at the end. I just kept the naming of the cells because the logic is the same everywhere.
06:59
So now Hungarian forint to Canadian dollar
07:03
and her guarantee, for instance, ground.
07:20
And now we have finished
07:24
the naming of the cells,
07:30
as you can see.
07:34
So instead of reference to the cell
07:39
with sheet name, you're just going to say you is don't Euro and you get to the
07:44
list off all the names that we have defined that begin with the same name. So we're going to basically
07:51
do this for all off the cells.
08:37
Okay, so we have done it for years. Dollar.
08:41
And now we're going to follow the same logic
08:45
for all the other cells.
09:28
Yeah, conversion from euro, too.
09:31
British pound
09:33
than two Canadian dollar
09:37
and so on. So so were we skipped
09:43
a few steps, and now we're at the end.
09:48
So just remember that on the day agonal of this table,
09:54
the formula should be equal just
09:56
before or C four or D for
10:00
up to g four.
10:01
Because we don't
10:09
convert currency.
10:11
We don't need the conversion from the currency to the same currency. So it's always
10:22
I just need to do some corrections.
10:26
And this is it. This is our table.
10:33
We have done the finished lab, and now we just have to hide the exchange rates
10:39
table.
10:48
I'm sorry.
10:50
We're going to hide it,
10:56
and then we go to protect World Book,
11:01
and we add password for opening the exchange rate table
11:09
tab so that you can
11:11
later at it if needed.
11:16
I just entered the default. Want to three password? Never do that by yourself.
11:30
And now just a test are
11:35
go.
11:35
This is what this calculator should
11:39
act if done properly.

Up Next

Intro to Excel

This basic Excel training course will give you knowledge of Excel and the ability to use this software to do elementary calculations, file manipulation, data manipulation, to create charts, pivot tables and templates.

Instructed By

Instructor Profile Image
Milan Cetic
IT Security Consultant
Instructor