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).
- 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
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.