Excel 2019 Automating with Macros

 One Hour
Delivery Methods

This course gives an introduction to macros in Microsoft Excel. Using macros, you can automate repetitive tasks and gain more control over how you work with data. This course focuses on the basics of creating and running macros and also introduces students to Visual Basic for Applications (VBA), an advanced tool for creating and editing macros through coding.


Upcoming Class Dates and Times

Oh Snap!
There are no dates listed.
Please contact us to get something scheduled.

Who Should Attend

In order to automate functionality in Excel, it is important for students to first have a solid understanding of what Excel is and is not capable of. For this reason, this Power Hour is not recommended for beginners. However, creating macros requires very little to no experience writing formulas and manipulating data, so less experienced users can still benefit from the power and efficiency that macros allow.

Course Objectives

    The goal of this Power Hour is to introduce students to the concept of creating macros and teach them how to use macros efficiently. Students will also receive a brief introduction to VBA. By the end of this course, you will be able to create macros for a variety of purposes and will be ready to start exploring VBA in more depth.


1 - Lessons
  • * Creating a Macro - Learn how to enable macros in Excel and access the tools to record a macro.
  • * Recording a Macro to Automate Formatting - Learn how to reuse formatting across sheets and workbooks by recording formatting features.
  • * Running a Macro - Learn how to run saved macros from the Macros window or by creating a button on a worksheet or on the Quick Access Toolbar.
  • * Exploring the VBA Environment - Learn how to navigate the Visual Basic Editor and edit the code that makes macros tick.