Excel: Automating Tasks with Macros
August 21, 2024
1:00 pm-3:00 pm
via Zoom
  • 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