Time
8 hours 33 minutes
Difficulty
Intermediate
CEU/CPE
9

Video Transcription

00:00
Okay, we have a ride of the end of this macho, and we're going to do the short recap, and I going to give you the guidelines for the exercise file that you will be able to find under resource is stab off this course.
00:13
So in this macho, you have been able to learn the detailed explanation off some malfunctions text functions in for functions or information functions and look up functions. Um, when I say selected or ah group of functions in each,
00:32
it's like that set the functions in each group.
00:35
Um, I have chosen those to match the level of this course, which is intermediate course. And also, I have excluded
00:46
the functions that have some kind of niche usage, for example to economically functions I abused by people who need them in their populations, for example, engineers or somebody doing some math calculation geometry.
01:00
Um, and they're pretty much simple to use, and they're basically not interested. Interesting for general population off axel users, Um,
01:15
so after you have learned all of this functions, it is time for you to do your exercise. And the exercise file for module tree has four,
01:26
uh, exercises for tasks.
01:30
So the 1st 1 is that you're given a list of invoices sent to a group of customers With their status status can be paid or pending
01:40
in S O F. Three. You have to make a formula that will calculate some off influences that
01:47
comply with both. Criterias directed from dropdown List and sells F one and if do and let's clarify that a little.
01:55
So I have invoice number, which is basically not interesting in this
01:59
task. You have customer name I should have just placed ABC doesn't matter the names of the customers. Then there is amount. And then there is status paid and unpaid. And here you can have
02:10
customer A, B and C
02:15
and
02:16
status could be paid and paid.
02:19
And upon a selection, you should calculate the total amount of invoices that are, for example, in this case for customer A and that they're paid or you can just select unpaid. So this formula should work. Whatever the selection off these is
02:36
task to
02:38
is in sell off S L. A. One of the worksheet us do You're given the sentence with misspelled upper and lower case Little's letters, and you should make a formula that will just to correct spelling. So the first letter of the sentence should be upper case and all the other should be lower case
02:59
because we don't have names in this sentence. Um,
03:05
task three
03:06
in sale. A wonder is the drop down a list of increasing numbers and letters
03:12
in cell to create formula that will calculate square root of the number.
03:16
Or just copy the content is sell a one doesn't contained in America, will you? So here we have a drop down list. Didn't you see what we can have? A king? 498 25 Q et cetera.
03:30
So here you should make a formula that will simply
03:34
calculate with square. Oh, do whatever you have selected here. If this is a number and if this is ah, something else, then it should just copy the cell
03:46
and final tusk
03:47
in cells. Ah, a two
03:51
to a seven.
03:53
It was a typo. I will correct it and their names of, uh, contestants in the race and this is their position at the end of the race. So else it was, for instance, on some.
04:03
So here we have a drop down list with the
04:08
positions
04:10
and in this cell cell C three, you should calculate
04:14
the
04:15
ah list the initial culture. You should retrieve the address of the cell
04:24
off with containing the name of competitors. Er, that has finished.
04:30
As the selection says. So if it's one, it should be Elsa. If it's five, it should be beat.
04:38
So he's the winner. But here, you don't want to put his name. You need to put the address of this cell.
04:46
So, for example, if it's five and it's beat, it should be a
04:50
five.
04:54
So you have to make it for formula that we retrieved that address
04:59
and that soul for the,
05:01
uh, this exercise file. I hope you'll solve it without any problems. If you still have some problems, you should look. ATT The Salt exercise file, which is also available. The resources step.
05:16
Thank you

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