6 hours 3 minutes
at the end of this module like the end of everyone. Let's do a short recap off what
you have bean learning in this module.
So first you have seen all about properties of a cell in Excel, and they're quite a lot of them, and we didn't touch each and every one of them. But basically you had
explanation off that you can
changed the front type from size from style in each individual cell or a group of cells than you can change the color of text color of background of the cell.
You can change the borders, and you can change, for example, the type of data that's in the cell, which is something that we mentioned already before when we talked about
and the types. So there are quite a lot of properties of cell which are there to help you display the content of the cell or group of sell off the entire sheet in a way that you find the best for you or anybody who's going to view that excel sheet
to understand it in the
most in the easiest and fastest way.
The next thing
I talked about was how to use styles and create custom styles for a cell or group of cells
on. And that is also very important because if you're constantly doing some kind of formal thing of cells, it's very nice to put it in a style, save that style and that, Ah, after that you can just reapply that style
to whatever cell has to have a group of cells that have.
I need to have the same properties. That is the style you have defined.
Conditional for wanting was next and in conditional form. Lesson about conditional formatting. You have learned how to form at the cell or some paramedic er's of the former thing of cell in a way that it
is based on what is in the cell. So, for example, if the value off the cell is ah
above a certain or below certain limit, it can change color and indicate that something is wrong there. And it is really good in all kinds of business. Usage of Excel sales reports on dhe, similar things.
It is also extremely useful when you're doing some statistical analysis and you want to see
things that air
out off some peaks O. R. Or some some values that their way below expected some anomalies.
So this is what conditional former thing is mostly used for and in the end is a part of for the whole thing regarding for mating cells, you have been able to see how to create a table in excel so that you select a group of cell and name it.
It gets a special name
and it gets the special properties. Plus, all the combs get filters as well.
So this is it for this module on, and please do continue with this course.
LPI Linux Essentials
LPI Linux Essentials practice exam helps to prepare for the LPI Linux Essentials 010-160 certification ...
Being an intermediate level user of Excel can help save a user hours of work ...
9 CEU/CPE Hours Available
Certificate of Completion Offered