Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:00
at the end of this module like the end of everyone. Let's do a short recap off what
00:06
you have bean learning in this module.
00:09
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
00:20
explanation off that you can
00:23
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.
00:37
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
00:52
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
01:10
to understand it in the
01:11
most in the easiest and fastest way.
01:15
The next thing
01:19
I talked about was how to use styles and create custom styles for a cell or group of cells
01:26
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
01:42
to whatever cell has to have a group of cells that have.
01:46
I need to have the same properties. That is the style you have defined.
01:52
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
02:07
is based on what is in the cell. So, for example, if the value off the cell is ah
02:13
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.
02:31
It is also extremely useful when you're doing some statistical analysis and you want to see
02:38
things that air
02:39
out off some peaks O. R. Or some some values that their way below expected some anomalies.
02:49
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.
03:07
It gets a special name
03:09
and it gets the special properties. Plus, all the combs get filters as well.
03:17
So this is it for this module on, and please do continue with this course.

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