Excel 2016 Automating with Macros

Course Overview

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.

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.

Course Outline

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.

Price: $49.95

Class times are listed Central time.

To sort by location or date, click the ‘When’ and ‘Where’ column headings.

Cart When Time Where How
11/16/2020 8:00AM - 9:00AM Online LIVE LNL
12/07/2020 10:00AM - 11:00AM Online LIVE LNL

Class times are listed Central time

This class is part of our LearnNow Pass. Click here for more details.