Macros combine a sequence of commands into a single action and user-defined functions are used to perform complex calculations that can be launched from a single function name. In this workshop, participants will learn how to use advanced macro capabilities to automate complex workflows and how to write and assign user-defined functions. Participants will incorporate decision making logic and repeating actions into their macros and add to Excel’s default function library by creating their own functions.

(Description continued below)

Participants will:

• Run macros when files open
• Add dialog and input boxes to macros
• Create macros that can make decisions
• Create user-defined functions to perform complex calculations
• Use user-defined functions in an Excel worksheet
• Learn basic Visual Basic for Applications programming concepts

The following workshops are suggested prerequisites to this workshop:

• Excel: Basic Automation Using Macros

Participants should already be able to:

• Record basic macros
• Edit basic macros using the Visual Basic Editor
• Use the Personal Macro Workbook to store macros