Time
8 hours 33 minutes
Difficulty
Intermediate
CEU/CPE
9

Video Transcription

00:01
Okay. This module was about macros. And in my opinion, this is the most important part of this course.
00:10
So
00:11
with Mac Rose, you really get the advantage over regular user.
00:16
If you know how to write my crow's. If you know how to use them, how to modify them.
00:21
You have
00:22
gained the level of expertise in in using excel and making excellent, very powerful tool that will definitely be the envy of your colleagues.
00:34
So
00:35
where in this, uh,
00:37
module you have seen what kind of Mac rose there are,
00:42
then you have seen
00:45
the types of variables that can be used in Mac Rose. You have seen how, uh, what kind of loops you havin micro's
00:54
and what kind off? What is if then, else structure and how is used. Also, as we were going along,
01:03
you have been able to see a lot of ways to get and to change some things in my inn in AA cells in cell using Mac Rose. So you have seen how you reach your value of a certain cell, how you changed that value, how you change the
01:22
perimeters off certain
01:25
well, parts of worksheet. For example, how you can hide the worksheet and what variable have to change in order to or parameter have to change in order to make this sheet invisible and not
01:42
on and so that nobody except you can on hide it and make visible again. So if you want to hide some things,
01:49
um,
01:51
and we have not addressed lot off these parameters in excel because there's so many of them that it is essentially a subject to the course by itself. So I have just given you hear the idea what you can do in excel with basic things.
02:09
And, uh, when it comes to Mac Rose s so that you can automate your excel much better.
02:17
Also, you have seen how to use the form toe, enter data so that so that your macro can interact with you or any other user of that Excel file and give you the possibility to enter some data and to some actions based on the data.
02:36
It was used when we were entering passport, but it could have been done
02:40
for any kind of data entry. For example, if you want to know, create a procedure toe, enter records in
02:49
some kind of database that is
02:52
or serum file that is contained in Excel.
02:54
So at the end of this module,
02:58
I hope that the remaining model will help you learn even more about how to use Excel in much better way.
03:07
Q.

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