Excel Macros

Excel Macros Training

Excel

Class Duration: 4 hours

Excel macros are an excellent tool to help streamline your workflow, and cut down on repetitive tasks. The ability to record macros in Microsoft Excel means that you can easily add macros to your daily work. Learn how to automate your spreadsheets from one of our instructors either at your location or through our Virtual Training Center.

Training Class Goal

This class will cover the steps necessary to create macros, recording macros, your personal macro workbook and a brief introduction to the VBA Editor that will allow you to edit existing macros.

Prerequisites

Understanding of Excel fundamentals including formatting, navigation, basic formulas, basic functions. Students should be comfortable with basic IF statements.

Topics Covered

Creating and Editing Macros

  • Planning a macro
  • Recording macros
  • Accessing macros
  • Intro to VBA Editor
  • Editing an existing macro in the VBA Editor
  • Personal Macro Workbook
  • Moving a macro to your personal macro workbook

Our courses are designed specifically for companies and their employees. Our instructors are based in Denver and Phoenix, but can travel to any location in the nation.