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.

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