Excel 2010-Advanced Macros & User Defined Functions

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


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