Microsoft Excel Macro Programming

Microsoft Excel Macro Programming

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


Prerequisites

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

$199

8:30 am - 4:30 pm
Lunch is on your own
11:30 am - 12:30 pm

10% discount for University of Arkansas Faculty, Staff and Current Students. To receive the discount, you must register with your uark email address and enter coupon code 'UA10' at checkout. Status will be verified and correct rate will be applied. Additional discounts do not apply.​
No refunds of the UA 10% discount, or any other discount, will be granted once registration is complete.


Part 1 Schedule

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

Send Me Updates