8 hours 33 minutes
Okay. This module was about macros. And in my opinion, this is the most important part of this course.
with Mac Rose, you really get the advantage over regular user.
If you know how to write my crow's. If you know how to use them, how to modify them.
gained the level of expertise in in using excel and making excellent, very powerful tool that will definitely be the envy of your colleagues.
where in this, uh,
module you have seen what kind of Mac rose there are,
then you have seen
the types of variables that can be used in Mac Rose. You have seen how, uh, what kind of loops you havin micro's
and what kind off? What is if then, else structure and how is used. Also, as we were going along,
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
perimeters off certain
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
on and so that nobody except you can on hide it and make visible again. So if you want to hide some things,
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.
And, uh, when it comes to Mac Rose s so that you can automate your excel much better.
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.
It was used when we were entering passport, but it could have been done
for any kind of data entry. For example, if you want to know, create a procedure toe, enter records in
some kind of database that is
or serum file that is contained in Excel.
So at the end of this module,
I hope that the remaining model will help you learn even more about how to use Excel in much better way.