Introduction

Video Activity
Join over 3 million cybersecurity professionals advancing their career
Sign up with
Required fields are marked with an *
or

Already have an account? Sign In »

Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6
Video Transcription
00:00
hello and welcome to hinder to Excel Course, this chorus is mint for
00:06
you to learn about XL 2019 The basics of it or at the latest version off Accel from office 3 65
00:20
So,
00:22
um, if you want to listen to this course, you really don't have to have any special previous knowledge.
00:30
So what? You need to know his basic knowledge of what excel is, and you should be
00:37
where, Why you need it.
00:39
You should have. But it's not necessary. Some familiarity with the other Microsoft office programs, especially word because some of the things that they're used here, some of the logic off use
00:52
is the same
00:54
you need to be comfortable with using PCR my computer
00:59
s o. That means ah, basic piece of personal computer operation, how the operating system works.
01:07
And of course, you need some basic knowledge of how files they're organized. Water folders, directories.
01:14
How were the files are saved in and on your computer,
01:18
and these things off course, you should need a novice meaning office 2019 or off his 3 65
01:27
now just wants to mention that there is a slight difference
01:34
between office 3 65 in office, 2019. But for the purposes of this course, they're so small that we're not going to mention
01:45
my name is Milan Jet each. I will be in structure this course
01:49
I'm I t consultant. I have 25 years of experience. Unite E. Bean 90 journals for nine years old. More But most importantly, I have Bean Excel user for 20 years
02:01
in my free time. I'm also very interested in fine wines and cooking. I cook a lot whenever I have the opportunity.
02:10
And if you want to find me, contact me regarding this course or any other course here in cyber ery. Here's my email address and you can use it to ask me a question.
02:24
So accept of this presentation and the videos you will hear
02:30
there will be some extra materials for this course, so
02:32
you'll have labs after some of the lessons and models, these labs will include some simplemente re materials, for example. There will be some quizzes, questions, things like that.
02:49
Uh, there will be quite a lot of flab, so you're not going to see them list bill here because it would be a really long list.
02:58
There is going to be additional exercise
03:02
files meant for you to practice on your own. But you learned in each of the models okay, not all of the models, because some of the models like this one, which is introductory, has no practice it all. Also, Madi another number one will not be
03:21
with any exercise files because it's going to be simple explanation off the basics off Excel user interface and how to use it.
03:31
So, um,
03:32
most of the other models are going to have exercise files at the end,
03:38
and also there is going to be a separate file with that's a solved exercises or test that you have in exercise files. And, ah, if you can find your answer yourself, you can look at these fast, although I strongly suggest you try to
03:57
make a solution on your own, which would prove that you have
04:01
learned your lesson.
04:05
This course is meant for pretty much anybody that wants to improve their data manipulation skills, which is was the XL is used for.
04:15
So it means that students, sales assistants, business assistance also salespeople ones that still don't know how to use Excel so
04:28
probably a beginner's, because I don't think that today you can be a sales person
04:32
in the modern world without knowing how to use Excel, at least on the basic level,
04:40
but also for people who want to use it at home. For budget planning on dhe, whatever
04:46
you might need it at home. It might be interesting,
04:49
Um,
04:53
so what are you going to be able to learn in this course?
04:58
First of all, we're going to talk about how you enter data in Excel sheet, including some basics about the interface user interfaces itself.
05:09
Then I'm going to talk about manipulating data using formulas, functions and logical operations.
05:15
You will be able to learn how to sail files in different for months, how to create templates,
05:20
how to use different data types on and create custom rated types. In Excel. Excel has a great variety of data types, but you might want to do
05:30
something by yourself to add something,
05:33
then how to use names in excel
05:38
and also how to hide cells and whole worksheets and protect them.
05:45
You will be able to learn how to Seoul, sort, filter and group data and do various data manipulation.
05:53
How to form its cells, how to make cells get the conditional formatting. So different, for example, color
06:00
regarding the content of the cell itself. How to your style's house to insert two different objects, like pictures in Excel Sheet or
06:11
something from another program.
06:14
And at the end, I'm going to talk about using people tables in pure charts. And finally,
06:19
before we close this training this course, I will talk to you a little about how to print your working desired form it. I know that most of the people still use
06:32
Excel on Lee on screen, but sometimes you just have to print atleast in pdf format. So
06:40
we'll talk about that,
06:43
and that's pretty much it about the introduction for this course.
06:47
I wish you very good luck in learning about the cell,
06:51
the basics of it,
06:54
and let's finish this module now
Up Next