Excel Macros VBA - Level 1


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.


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.


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

Pre-Word Required



Suggested Class Size

Minimum 3
Maximum 12


Course Length

8 hours