Course ID: EXCELM-L

Excel Power User: Macro Programming using Visual Basic for Applications

Enhance your productivity and save time with Excel macros. This course will teach you how to work effectively with the Visual Basic Programming language as it applies to Excel, use the Excel Visual Basic Editor to create macro code and create macros that go beyond the capabilities of the macro recorder. The material is presented in an exceptionally easy-to-follow format with examples, clear definitions of terms and useful take-home examples. The content of this presentation applies to Excel 2016, 2013, and 2010. (Format: “hands-on, instructor-led group training”)


LEARNING OBJECTIVES
  • 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

MAJOR TOPICS
  • 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 Science

PREREQUISITES
Advanced Excel training or equivalent experience

COURSE PRODUCER
Business Learning Institute

CPE CREDITS
8.0

LEVEL
Advanced

This course is available for your group as:

Group Live
 

Let's Roll!

To learn more or customize this course for your group, complete this form and a BLI team member will get back with you shortly.


Or, contact BLI: 888-481-3500 or learn@blionline.org