Time
8 hours 33 minutes
Difficulty
Intermediate
CEU/CPE
9

Video Transcription

00:00
Hello and welcome to another exciting course at Sai Bury. This is excellent immediate course. And it is
00:07
I meant to give you intermediate knowledge of Fuse Off Excel.
00:12
The version of Excel we're going to talk about in this course is going to be 2019.
00:18
So let's ah, start with the introduction.
00:21
In this course, you will be able to learn how to work with a raise, how to use advanced functions. Matt functions, text functions, information functions and welcome functions.
00:35
How to create Micro's
00:38
how to import data from other files and programs
00:41
and then how to customize Excel interface, how to create map chards
00:48
and, in the end, how to do complex data analyses manipulation by combining all these things you have learned so far. So in this final module, when we talk about complex data analysis and manipulation, what we're actually going to give you is three examples
01:06
all from ah,
01:07
different kind that will give you the inside how to do certain things.
01:12
Um, so in the first part, where we talk about their raise, you're going to learn how to
01:19
use a raise in excel, functions and formulas.
01:25
Ah, then ah, in the in the part where we talk about functions, we're going to go through functions, detail, give you example off each one of them.
01:37
In the macro is part you will be able to see how to write serious Mac Rose, how to use
01:46
most commonly of structures and macros and how to do some very nice manipulation with what you see on screen in Excel in order to make it more
01:56
useful and more convenient for the user
02:00
in customizing Excel interface. Ah, important data and creating map charts. We're just going to focus in each of these modules on just one of these things.
02:10
So
02:12
ah,
02:15
what you need to know before you take this course
02:19
a meaning prerequisites. So
02:22
it would be it is suggested that you take some kind of interest to excel. Course it can be here in Siberia or you had somewhere else or you had experience with excel that would constitute is basic knowledge.
02:37
So basically what you need to know on what this course ah
02:42
presumes that you already know is how to manage workbooks.
02:46
How to apply
02:47
custom data for months, how to create them, how to use them.
02:53
Um,
02:54
then Ah, how to apply conditional formatting and filters. This is very important because
03:02
filters is something that the knowledge of filters is something that is presumed for this course.
03:08
The next thing you should
03:12
be quite comfortable with is how to create and modify custom work for comments.
03:21
Uh,
03:23
then,
03:23
um,
03:25
the other part of prerequisites
03:29
is the basic Look up by using functions in the XL
03:35
without going into any detail. So you just need to know basics, because in this course, we are going to cover a lot off Look up functions and advance. Look up. That can be done in excel.
03:49
You need to know how to perform some basic data analysis and business intelligence. In Excel
03:57
Off course, you need to know the procedures of troubleshooting formulas.
04:01
Ah, and then, of course, Ah, we're way. You need to know how to create charts, people, tables and people charts. So these things
04:12
will be
04:14
presumed in this course is as ah,
04:16
acquired knowledge.
04:18
Um,
04:20
also, you need to know how the formulas work. Basic logic operations in excel. Ah,
04:30
you need to know something about doing the functions. Indeed, the tab.
04:34
Ah.
04:35
Then, uh,
04:39
basically, how to print reports. So all the things that people normally use in Excel at that they're on what is considered the basic level knowledge.
04:51
A SZ. Far as I'm concerned, I be our instructor for this course. My name's Millen Heritage on I'm currently working is independent I t. Security consultant.
05:01
I have something like 25 years experience in I t. Have been nightie journalist for nine years. But most importantly, I have been used in Excel
05:12
for 20 years, and I have reached quite an advanced level in using it. The writing Mac Rose and doing all the stuff that is necessary to make your Excel worksheets work perfectly. So I was.
05:26
I was working as a pre sales consultant for 15 years, and part of my job was to create or sorts of reports for me and my customers, for my managers and my customers, actually, and I had simply to learn a ll the things in Excel to make this as fast as possible because this was,
05:46
you know, reporting is never
05:47
the primary job you do.
05:51
So who is this course for?
05:55
If your administrative assistant this is going to be extremely helpful
06:00
because if your administrative assistant. Special leave to some kind of manager you all the time have to prepare some kindof data digging from the road eight eyes, especially if it's sales, but also if it's manufacturing, production or operations. So if you if you
06:18
have to prepare all these reports and extract data from the road data that have bean entered by someone else,
06:28
Uh, then this is This course is definitely for you. Also, if you're in sales and you want to you improve your skills off using Excel for doing
06:39
reports for doing forecasts corporate sales predictions for the future,
06:45
then you can do quite a lot of things with what you
06:49
can. I learn in this course.
06:51
Also, if you're some kind of operations meaning sales, operations or manufacturing or supply or even shipping, this course can be very interesting for you, if nothing else. In in order to learn howto automate your Excel, how to create forms to enter data and stuff like that.
07:12
And finally, if your student or professor or somebody
07:17
with any connections with academia, for example, teaching assistant, learning things in this course will help you do things in your everyday work. Much more efficient and much more
07:30
functional.
07:33
So supplementary materials for this course, every excel worksheet you will see in this course
07:41
will be available. Injuries under resources step.
07:45
So it will be for each module. There will be one file in multiple tabs,
07:50
and, uh,
07:53
every example will have the separate
07:58
tab or worksheet. And, uh
08:01
ah,
08:03
you will be able to see them in the form in which they were exactly at the end off the example as shown in the lesson.
08:13
Also, for some of the modules, there will be additional exercise files in which I will give you tasks to do certain things in order to practice what you have learned. So the thing about Excel is that whatever you know, if you're out of practice,
08:28
you will need quite a lot of time reminding yourself. Knowing everything about successful is absolutely, I think, impossible for one person, except if that is the only thing you do in your daily work. So if you're doing on Lee Excel,
08:45
then yes, you can be an expert in excel. But if you're doing something else in using Excel for that work,
08:50
using, knowing all the things is simply out of the question. You simply have to practice them. So things you do on a daily basis, you will know very well things you don't do on a daily basis. You will need some reminding for
09:05
this is why you have discipline mentally materials to help you go through and see. OK, dysfunction is used like that door.
09:11
This macro can be written like this and son, son.
09:18
So, um, this is the end of introduction. I sure hope you will have good time learning in this course. And let's start with lessons. Thank you.

Up Next

Intermediate Excel

Being an intermediate level user of Excel can help save a user hours of work time and take full advantage of the Excel application. Taking an intermediate Excel training will help students advance their skills and pass an intermediate Excel exam.

Instructed By

Instructor Profile Image
Milan Cetic
IT Security Consultant
Instructor