- Completion of Excel: Intermediate or similar familiarity with Excel is strongly encouraged.
- This course covers Windows for PC only (Macros on MacOS are not covered.)
This hands-on course is intended to teach employees advanced features of Excel, including the following topics.
- What Is a Macro?
- Understanding Macro Security
- Why Use Macros?
- Preparing to Record a Macro
- Absolute and Relative Macro Recording.
- Recording a Macro
- Saving a Workbook That Contains Macros
- Opening a Workbook That Contains Macros
- Running a Macro
- Viewing and Editing a Macro
- Assigning a Macro to a Shortcut Key.
- Deleting a Macro
- Working with a Macro in the Personal Macro Workbook
- Assigning a Macro to the Quick Access Toolbar
- Assigning a Macro to a Button
- Creating a Macro That Runs when Opening a Workbook