Students who need to create macros for use in Word and Excel will greatly benefit from this class.
Intermediate level experience with Microsoft Word and Excel
- Run and record macros
- Assign macros to menus, buttons and toolbars
- Create decision making code
- Use If, If..Then..Else decision structures
- Use Loop structures
- Assign Sub procedures to run automatically
- Macro management
- Record a macro in Word 97 and Excel
- Interactive macros
- Create a custom message box, custom input box
- Extract data from Excel
- Debug and test code
- Overview of macros in PowerPoint and Access