Course ID: EXCELM-L

Excel Power User: Macro Programming using Visual Basic for Applications

About & Customize

Popular Options

  • In-Person
  • Live Webcast

  • Design, create and test many macro examples in Excel
  • Apply easy-to-follow in-class relevant business examples
  • Take away a library of useful macro code and examples

  • Understand Visual Basic for Applications (VBA)
  • Run macros in a variety of ways
  • Use the macro recorder
  • Examine module design
  • Edit code in the Visual Basic Editor
  • Assign macros to objects
  • Create decision-making code using the If Then Else decision structure
  • Create code for looping structures
  • Use a For Next statement
  • Use a Do Loop statement
  • Use Macro management rules
  • Use the Personal Macro Workbook for generic macro code
  • Assign sub procedures to run automatically
  • Create code to interact with the user and gather information from the user
  • Use the custom message box
  • Use the custom input box
  • Assign macros to worksheet buttons and keyboard shortcuts
  • Test and debug macro code
  • Protect and hide macro code
Designed For

CPAs and Professionals at all levels of an organization needing to automate tasks in Excel beyond the capability of the macro recorder in order to save time performing repetitive report generation, data cleanup, data analysis and worksheet manipulation

Field of Study
Computer Software & Applications
Prerequisites

Advanced Excel training or equivalent experience

Course Producer
Business Learning Institute
CPE Credits
6
Level
Advanced
Available Formats
In-Person, Live Webcast
Types
Seminars

This course, like all courses in the BLI catalog, is customizable for your organization. Format, length, and content customizations are available.

To get started, contact BLI:
(888) 777-7077
team@blionline.org