Tuesday, August 25, 2026, 10:00am - 12:00pm
This hands-on course is intended to teach employees advanced features of Excel, including the following topics. Completion of Excel: Intermediate or similar familiarity with Excel is strongly encouraged.
Learn to record macros to automate various Excel tasks. This course covers Windows for PC only (Macros on MacOS are not covered.)
- 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
Please note that the class is PC-based. You can attend using a Mac, but there may be some slight differences.