Business & Industry Credential 

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.

Learn More >>

Excel Macros VBA-Level 1

Student in the Student Pavilion

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.

  • Program Plan
  • Tuition Info
  • Career Planning

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:

  • Microsoft® Windows® experience
  • Microsoft® Office Excel® 2010 Beginning
  • Microsoft® Office Excel® 2010 Intermediate
  • Microsoft® Office Excel® 2010 Advanced

$350 per person / 8 contact hours