6 hours 3 minutes
OK, so at the end of this course, let's do a recap of what you learned in it.
So in the first module, uh, which was named Entering Dating Excel,
you have been able to learn
about essentially how excelled works. What are the elements of
user interface in Excel?
What is excelled
used for? Then I talked about who need excel and just to remind you pretty much anybody who is doing any kind of calculation or data manipulation in
on the computer.
Then I talked a little about limitations and excel,
and in the end, I mentioned how to do proofing and translation in Excel, and I say proof in a
especially meant on spell checking. So it's the same, like in any other Microsoft office
software or back part off Mike Ross's office package.
So next module was about formulas and excel, and in debt module I talked about the formulas are and Howard they entered.
Then you have been able to learn about automatic and manual recalculation and how to turn off automatic calculation. And back on
then, I explained about types of formulas have existed. Existing Excel
and I paid special attention on math calculations and Matt formulas and text formulas.
And at the end of this module, I talked about evaluating formulas and looking for errors
in Module four.
which is about files and dating Excel
I I presented to you what types of Excel files exist,
what our data types and how to create custom dated types than what their names and excel and how to create
Then about creating templates in excel or in brother templates, template files.
I talked about hiding cells and sheets,
and at the end I talked about how to protect the sheet from billing altered or from somebody who is not authorized to access some daytime your sheet.
In Model five. I talked about Data Tab,
and this tab is very important. Contains very important functions because they're crucial for analyzing data.
Uh, when you have them already entered in your exile sheet. So part off what I talked about in model fires about sorting data than using filters, then why and how to group cells and then howto on group them.
Then very important thing is sub totals or talked about creating sub totals.
Then I talked about data validation, which allows you to restrict what can be entered in a cell of in terms of type of data or the values.
And there's a part of that. There was a talk about how to create dropdown list. Basically
toe allow the user of the file to entering cell just those items that are in the drop down list for that self.
At the end of that model, it was all about consolidating data from different data sheets or files into one and working with that data.
So, um, in module six
Ah, I talked about former thing cells and sheets,
and first of all, you have been able to see what their sell properties are
so how to form at the cell. It means you change some properties of that cell,
then how to use pre existing style that are pretty finding excel, or how to create your own.
Then how to do the conditional formatting or cell, which means that cell will have a different appearance, depending on what's in it in terms off value, off the data in it.
And finally it was all about creating tables
so tables within tables because one every worksheet in Excel is actually one big table, but then you have a special entity within Excel that is also called table. And it was all about this.
Um, next model Model seven was about inserting objects in Excel. So those objects that are not things that you usually put in a cell, which is text or formula or numerical Well, you
or date or something like that. So
I showed you what someone insert tab, then how to insert informant shapes, how to insert informer pictures,
how to insert symbols and equations, mathematical equations or
And at the end of that model, it was all about creating charts because charts are extremely powerful and very important
Tool in Excel, which allows you to graphically represent datum, which is very also useful if you have a lot of data, because just looking at the numbers on the screen is usually a problem for many people. But if you have these data organizing some kind of graph or diagram,
it's much much easier to comprehend what the data actually want to say.
Ah, I specifically paid attention toe one thing in
Excel, which is called people tables and people tables basically allow you to extract data from
some important information from larger data
and to get, uh, some
insight in in in what this date actually presents.
And finally, in last model model nine, I talked about former thing Paige and printing sheets. So it was all about how to choose paper size margins and orientation
off. You're off the actual paper on which your worksheet is going to be printed.
Then how to insert headers and footers if necessary
And finally, how to make sure that your sheet fits on a printed paper in a way that it can be read and comprehended after printing.
And that a ll the data. You want to be grouped on one sheet of paper? Stay there.
So that was all about this course. I hope you have learned a lot. It was useful to you,
and I wish you a very happy and successful use of excel in the future.