Hour 20. Automating Tasks with Macros and Smart Tags

The highlights in this hour are as follows :

What a macro is and what it can do for you
How to create a macro
How to run a macro
How to fix macro errors
How to attach a macro to a toolbar
How to use a macro in other workbooks
How to prevent macro viruses

During this hour, you will learn how to use macros to simplify your work in Excel, making you more efficient and leaving time for other things you need to do on the job. Macros are not difficult to create and use. They are special instructions that control how Excel functions.

The To Do exercises in this hour show you how to automate Excel through macros. You learn how to create, record, run, edit, and delete macros in one hour. You create a simple macro to change the font and font size of data. When you run this macro, all you have to do is sit back and watch what it does for you. It's that easy.

When this hour ends, and after you're comfortable with the macro tools and features you learn about in this hour, you'll be able to experiment with Excel and simple macros.