### Intermediate Excel

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

### Video Transcription

00:01
So in this macro I have already created, which is called Imperial to Metric. We have a code to convert thes
00:09
Ah ah! Units
00:11
on and the amounts from imperial to metric. So what's you get the code
00:16
and we have two counters here at first define. So we have counter one which will guide us through the rows in
00:24
the recipe and the second counter, which will take us through the roads in comparison chart.
00:31
And, uh
00:33
so we set the first counter to three because this is the first throw. And then we started the doo boo, and first thing we do is set counter to one,
00:44
and then we go to find the equivalent unit.
00:47
So again, a do loop, which will take us through all ingredients, regardless of how many off them there are. So in this point, we have just four of them. But it might be that we had something in the future
01:00
and we have a questions. If she eats comparison chart, range a encounter too. So that means that way. Look. Att? The first row row in comparison sheet in range, eh
01:15
equals,
01:18
um
01:19
in a recipe cell C
01:25
And this is three Because this is the first line of ingredients.
01:29
Then we go to change value to metrics. So we
01:33
say that
01:34
Ah, combi
01:38
line three
01:40
value equals
01:42
that will you
01:44
times
01:46
What we found is the equivalent
01:49
unit in metric units.
01:53
So
01:53
basically we look att, this number that we
01:57
that represents the difference because in this case, his ounces and grams
02:02
and maybe multiply it with
02:06
the amount of chances. And then what we also do is we changed the unit name to metric. So we look att
02:14
the own see
02:15
C three is now equal What is in comparison chart in the one
02:24
and we end. If so, if it's not
02:28
or if it is, it doesn't matter. It go to second counter and we go through all this case four units
02:36
off,
02:37
uh, in compares a sheet
02:40
and then we
02:43
closed the loop by loop until and we look it that when the first entry in comparison chart in in cold a is now blank space
02:54
and we when we closed this loop,
02:58
we go. So we always go through all ingredients because we don't know which one is going to be,
03:04
uh, the one we're looking for And it really doesn't matter if we found it and we go again, it won't change again because we found that unit has only one occurrences in this range. And we continue
03:21
with the whole thing.
03:23
Ah,
03:25
again for next row. So we now go to next four ingredients. We increase the counter toe by one and we look in a loop until so again, If we reached instructions,
03:39
then we stop
03:42
and we end this 17. So this is how we change imperial to metric.
03:49
Uh, and let's not do this at this point.
03:53
The just
03:53
copy this
03:57
and close this one.
04:00
Close this one.
04:01
So let's go to make Rose
04:04
and type the new name. So metric
04:08
two,
04:10
Imperial check. If there are no spaces, let's create it.
04:15
And we have this sub here
04:21
and
04:23
let's copy the content of the other one there.
04:28
So let's copy
04:30
this. So we have again
04:33
definition off
04:35
counters contraband and count to do it again. Started counting tree.
04:41
And now we look att comparison charts, but not any more in the range.
04:49
Be three but a three. But in B three, So we're looking now in a column with metric units.
04:58
And if it's equal
05:00
the
05:03
unit in
05:08
the recipe,
05:10
then we change
05:14
value to metric. So again, we're changing range B.
05:19
But here,
05:24
we're dividing it.
05:30
So we have the same number.
05:31
But now we're dividing it.
05:35
Sorry, we're dividing this
05:45
with the value from from comparison chart
05:48
and we're changing units
05:54
and we're no longer looking at the range. Beware The metric units are because we are metric units. We're going to change it to
06:01
imperial units,
06:05
and then we're still looping until
06:09
we're reaching
06:11
no more entries in comparison chart,
06:14
and then we're doing the same thing again and loping until we
06:19
reach instructions.
06:21
Uh, in, uh,
06:24
recipe
06:25
comb A
06:27
and this is it deserved. The only change is so we're going to save it now.
06:33
And
06:35
this way we have created to several teens, which we're going to call
06:41
from the one that we're going to create, which is going to
06:46
which would be here already created, the one that's called decide.
06:50
So let's close this. Let's make short break
06:55
and continue
06:57
in next video

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