Font size:

Excel Macros

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 on-site instructors.

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
Find a class and register in three easy steps:
  • 1. Select Location:
  • 2. Select Date Range:
    to
  • 3. Select Class Type:
    • All Types
    • C Classroom
    • V Virtual Live
    • Cv In-Class Virtual
    • O Online
CO Centennial4/30/2018 8:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day235.002046528
AZ Tempe5/22/2018 8:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day235.002046536
CO Westminster7/19/2018 8:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day235.002046541
AZ Tempe8/14/2018 1:00:00 PM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day235.002046529
CO Centennial10/11/2018 8:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day235.002046532
AZ Tempe12/13/2018 1:00:00 PM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day235.002046540
seek-warrow-w
  • 1
arrow-eseek-eitems per page1 - 6 of 6 items