Discover how to automate tasks in Excel. Learn how to record, share, and edit macros.
Overview
Syllabus
Introduction
- Welcome
- Using the exercise files
- Identifying applicable situations for using macros
- Recognizing the need for single-action macros
- Understanding security
- Short examples of the recording method
- Overview of other techniques
- Running a macro from the Developer tab or the View tab
- Running a macro from the Quick Access Toolbar button
- Running a macro from a keystroke shortcut
- Running a macro from an object or clip art
- The VBA environment and VBA components
- Creating the Personal Macro Workbook
- Closing and updating the Personal Macro Workbook
- Recording a simple macro
- Expanding a macro with the if statement
- Understanding when to use absolute or relative references
- Using For and For Next statements
- Using Do While and Do Until statements
- Creating interactive macros
- Planning a macro
- Recording partial code
- Using loop structures in context
- Testing a macro in Step mode
- Pulling the data together
- Joining two macros
- Streamlining macros
- Next steps
Taught by
Dennis Taylor