Time
8 hours 33 minutes
Difficulty
Intermediate
CEU/CPE
9

Video Transcription

00:00
So we're continuing the conversion.
00:02
Yeah,
00:03
process
00:05
or visual basic macros that are needed for this.
00:09
And here
00:11
we have
00:12
then this by calling opening the message box and saying, Imperial instead of that,
00:19
you're just going to call.
00:23
So if it's imperial, we have to change it to metric, and we're going to call Imperial
00:30
two Metric.
00:33
And here
00:35
if it's
00:37
metric, we're going to call
00:41
metric.
00:43
Sorry
00:46
to Imperial.
00:50
You don't actually have to match these cases here, but it looks nicer if you type it properly
00:56
and we're going to save this.
00:59
Close it.
01:00
And now let's do our conversion.
01:03
Let's see if everything is working.
01:07
We're just going to assign macro to it
01:12
and it's going to be the decide one.
01:17
And now we're going to click on it.
01:19
Sorry,
01:22
and it works. So we gave us a mounted leaders. We click again.
01:26
It brings us back
01:29
the unit's imperial units.
01:32
So
01:33
this is it. You see, the answers have been changed to grams
01:38
and milk chocolate
01:40
units, which were also ounces. Have we changed the grams
01:44
and we're getting here.
01:47
Ah,
01:48
shop not, sir. Now in leaders,
01:49
this might be a problem because in metric recipes we do have
01:55
transfer these thes thes products are given in Graham's not in Liters.
02:04
However, it would be really complicated to have for every different product conversion, so we're just going to keep it like this. So this way
02:15
we have created successfully a button within this sheet and we can copy between worksheets. So if you have more recipes, we can just
02:24
copied this button. We just have to keep the comparison chart sheet in
02:30
the Excel file, and it will work perfectly every time, so escorted back to Imperial and close this
02:40
part of this listen.

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