About the Class:
This workshop lasts 3.5 hours.
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.
What You’ll Learn:
- 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
What You Need to Know:
- Record basic macros
- Edit basic macros using the Visual Basic Editor
- Use the Personal Macro Workbook to store macros
If you don’t have those skills, consider first taking the workshop:
- Excel 2010 – Basic Automation Using Macros
Resources
| Excel 2010(PC) | Excel 2011(Mac) |
| Microsoft Office: Run a Macro | Microsoft Office: Create, Run, Edit, or Delete a Macro |
| Microsoft Office: (Tutorial) Automate Tasks with Visual Basic Macros | |