Macro Tutorial for Word and Excel

Here is an excellent one-page Word and Excel Macro Tutorial from Brown University. This will help you understand when to use and how to create macros for Word and Excel.

According to Microsoft, “If you perform a task repeatedly in Word, you can automate the task by using a macro. A macro is a series of Word commands and instructions that you group together as a single command to accomplish a task automatically. Instead of manually performing a series of time-consuming, repetitive actions in Word, you can create and run a single macro, in effect, a custom command, that accomplishes the task for you.

Here are some typical uses for macros:

 - To speed up routine editing and formatting
 - To combine multiple commands; for example, inserting a table with a specific size and borders
 - To automate a complex series of tasks.


Macro Tutorial Objectives:

 - Understand what a macro is and how it works
 - Learn how to conceptualize and record your own macros
 - Learn how to run them simply and efficiently via shortcut keys
 - Learn how to install pre-written macros
 - Learn how to save and embed them into your documents

Popularity: 31% [?]