Excel - Build Muscle with Macros

Price
$49.00
Duration
 One Hour
Delivery Methods
 VILT

This session introduces Macros and how to use them. Automate repetitive tasks and gain more control over how you work with data. Create and run macros and with coding in Visual Basic for Applications (VBA).

 

Upcoming Class Dates and Times

Aug 11, 2022
10:00AM - 11:00AM Central
One Hour
Virtual Instructor Led
 GTR
Sep 06, 2022
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR
Sep 22, 2022
3:00PM - 4:00PM Central
One Hour
Virtual Instructor Led
 GTR
Oct 17, 2022
1:00PM - 2:00PM Central
One Hour
Virtual Instructor Led
 GTR
Nov 11, 2022
1:00PM - 2:00PM Central
One Hour
Virtual Instructor Led
 GTR
Dec 02, 2022
10:00AM - 11:00AM Central
One Hour
Virtual Instructor Led
 GTR
Dec 29, 2022
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR

Agenda

1 - Outline
  • Create a Macro and access the tools to record a macro.
  • Record a Macro to reuse formatting across sheets and workbooks by recording formatting features.
  • Use Relative References in a macro
  • Run saved macros from the Macros window or by creating a button on a worksheet or on the Quick Access Toolbar.
  • Perform basic edits in the Visual Basic Editor and add code from a shared macro.