Course Recap

Video Activity
Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6
Video Transcription
00:01
OK, so at the end of this course, let's do a recap of what you learned in it.
00:07
So in the first module, uh, which was named Entering Dating Excel,
00:13
you have been able to learn
00:15
about essentially how excelled works. What are the elements of
00:19
user interface in Excel?
00:21
What is excelled
00:23
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
00:35
on the computer.
00:37
Then I talked a little about limitations and excel,
00:41
and in the end, I mentioned how to do proofing and translation in Excel, and I say proof in a
00:48
especially meant on spell checking. So it's the same, like in any other Microsoft office
00:56
software or back part off Mike Ross's office package.
01:02
So next module was about formulas and excel, and in debt module I talked about the formulas are and Howard they entered.
01:11
Then you have been able to learn about automatic and manual recalculation and how to turn off automatic calculation. And back on
01:23
then, I explained about types of formulas have existed. Existing Excel
01:27
and I paid special attention on math calculations and Matt formulas and text formulas.
01:34
And at the end of this module, I talked about evaluating formulas and looking for errors
01:42
in Module four.
01:44
Ah,
01:46
which is about files and dating Excel
01:49
I I presented to you what types of Excel files exist,
01:55
what our data types and how to create custom dated types than what their names and excel and how to create
02:02
custom names
02:04
or names.
02:06
Then about creating templates in excel or in brother templates, template files.
02:14
I talked about hiding cells and sheets,
02:16
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.
02:30
In Model five. I talked about Data Tab,
02:34
and this tab is very important. Contains very important functions because they're crucial for analyzing data.
02:43
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.
03:00
Then very important thing is sub totals or talked about creating sub totals.
03:06
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.
03:16
And there's a part of that. There was a talk about how to create dropdown list. Basically
03:22
toe allow the user of the file to entering cell just those items that are in the drop down list for that self.
03:30
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.
03:43
So, um, in module six
03:46
Ah, I talked about former thing cells and sheets,
03:52
and first of all, you have been able to see what their sell properties are
03:57
so how to form at the cell. It means you change some properties of that cell,
04:02
then how to use pre existing style that are pretty finding excel, or how to create your own.
04:10
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.
04:20
And finally it was all about creating tables
04:26
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.
04:42
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
04:54
or date or something like that. So
04:57
I showed you what someone insert tab, then how to insert informant shapes, how to insert informer pictures,
05:04
how to insert symbols and equations, mathematical equations or
05:11
physical or
05:13
chemical equations.
05:15
And at the end of that model, it was all about creating charts because charts are extremely powerful and very important
05:21
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,
05:41
it's much much easier to comprehend what the data actually want to say.
05:46
Module eight.
05:48
Ah, I specifically paid attention toe one thing in
05:54
Excel, which is called people tables and people tables basically allow you to extract data from
06:00
some important information from larger data
06:03
and to get, uh, some
06:09
insight in in in what this date actually presents.
06:15
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
06:26
off. You're off the actual paper on which your worksheet is going to be printed.
06:31
Then how to insert headers and footers if necessary
06:34
or needed.
06:35
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.
06:44
And that a ll the data. You want to be grouped on one sheet of paper? Stay there.
06:50
So that was all about this course. I hope you have learned a lot. It was useful to you,
06:58
and I wish you a very happy and successful use of excel in the future.