Excel 365 Automating with Macros

Price
$49.00
Duration
 One Hour
Delivery Methods
 VILT

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

Jul 29, 2021
10:00AM - 11:00AM Central
One Hour
Virtual Instructor Led
 GTR
Aug 23, 2021
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR
Sep 15, 2021
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR
Oct 06, 2021
3:00PM - 4:00PM Central
One Hour
Virtual Instructor Led
 GTR
Oct 28, 2021
1:00PM - 2:00PM Central
One Hour
Virtual Instructor Led
 GTR
Nov 19, 2021
10:00AM - 11:00AM Central
One Hour
Virtual Instructor Led
 GTR
Dec 15, 2021
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR

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.

Agenda

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.