Microsoft Excel Macro Programming

Microsoft Excel Macro Programming

This "Programming for Non-Programmers" course is intended for advanced Microsoft Excel professionals who need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA).



To be successful in this course, students should have completed Microsoft® Office Excel®: Part 1, Part 2 and/or Part 3 in preparation for this course.


Lesson Contents

  • Create a Macro Using the Macro Recorder
  • Edit a Macro
  • Debug a Macro
  • Customize the Quick Access Toolbar and Hotkeys
  • Set Macro Security
  • Insert Text
  • Format Text
  • Sort Data
  • Duplicate Data
  • Generate a Report
  • Determine the Dialog Box Type
  • Capture User Input
  • Insert, Copy, and Delete Worksheets
  • Rename Worksheets
  • Modify the Order of Worksheets
  • Print Worksheets
  • Create User-Defined Functions
  • Automate SUM Functions


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