Excel Macros VBA - Level 1

Audience

This 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.

Description

Upon 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-Word Required

None

 

Suggested Class Size

Minimum 3
Maximum 12

 

Course Length

8 hours