8 hours 33 minutes
Hello and welcome to another exciting course at Sai Bury. This is excellent immediate course. And it is
I meant to give you intermediate knowledge of Fuse Off Excel.
The version of Excel we're going to talk about in this course is going to be 2019.
So let's ah, start with the introduction.
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.
How to create Micro's
how to import data from other files and programs
and then how to customize Excel interface, how to create map chards
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
all from ah,
different kind that will give you the inside how to do certain things.
Um, so in the first part, where we talk about their raise, you're going to learn how to
use a raise in excel, functions and formulas.
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.
In the macro is part you will be able to see how to write serious Mac Rose, how to use
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
useful and more convenient for the user
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.
what you need to know before you take this course
a meaning prerequisites. So
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.
So basically what you need to know on what this course ah
presumes that you already know is how to manage workbooks.
How to apply
custom data for months, how to create them, how to use them.
then Ah, how to apply conditional formatting and filters. This is very important because
filters is something that the knowledge of filters is something that is presumed for this course.
The next thing you should
be quite comfortable with is how to create and modify custom work for comments.
the other part of prerequisites
is the basic Look up by using functions in the XL
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.
You need to know how to perform some basic data analysis and business intelligence. In Excel
Off course, you need to know the procedures of troubleshooting formulas.
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
presumed in this course is as ah,
also, you need to know how the formulas work. Basic logic operations in excel. Ah,
you need to know something about doing the functions. Indeed, the tab.
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.
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.
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
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.
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,
you know, reporting is never
the primary job you do.
So who is this course for?
If your administrative assistant this is going to be extremely helpful
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
have to prepare all these reports and extract data from the road data that have bean entered by someone else,
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
reports for doing forecasts corporate sales predictions for the future,
then you can do quite a lot of things with what you
can. I learn in this course.
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.
And finally, if your student or professor or somebody
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
So supplementary materials for this course, every excel worksheet you will see in this course
will be available. Injuries under resources step.
So it will be for each module. There will be one file in multiple tabs,
every example will have the separate
tab or worksheet. And, uh
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.
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,
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,
then yes, you can be an expert in excel. But if you're doing something else in using Excel for that work,
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
this is why you have discipline mentally materials to help you go through and see. OK, dysfunction is used like that door.
This macro can be written like this and son, son.
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.