Introduction to Microsoft Office Excel Macro Programming

Microsoft Excel Macro Programming

This course is intended for advanced Microsoft Excel professionals that need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA).



Knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data. Students are recommended to first take the Microsoft® Office Excel®: Part 1, Part 2 and/or Part 3 in preparation for this course.


Course Objectives

Upon successful completion of this course, students will be able to :

  • Record a macro
  • View macro code in VBA editor
  • Edit macro code
  • Run a macro



  • Create a Macro Using the Macro Recorder
  • Edit a Macro
  • Debug a Macro
  • Set Macro Security
  • Insert Text
  • Format Text
  • Sort Data
  • Duplicate Data
  • Insert, Copy, and Delete Worksheets
  • Rename Worksheets


Jul 17, 2019

This course is not yet scheduled, but we can notify you when it is.

Send Me Updates  

8:30 am - 4:30 pm