AudienceThis course is designed for individuals interested in learning the skills necessary to use VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations.

DescriptionUpon successful completion of this course, individuals will be able to:
  • Run macros and explain the basics of a Visual Basic Module.
  • Create relative and absolute recorded macros and assign macros to various objects in a workbook.
  • Write procedures that test conditions and then run only certain statements based on the results.
  • Write procedures that execute one or more lines of code repetitively.
  • Store Excel macros so they are available in any workbook.
  • Create macros that interact with the user.

Prerequisites

To ensure your success, we recommend you first take the following courses or have equivalent knowledge:
Pre-Work Required

None
Suggested Class SizeMinimum 3
Maximum 12

Course Length8 hours