SkillSoft Explore Course – Lambers, Inc.

Collections Accelerator 2.0: Office 365 Microsoft Office 2019: Intermediate Excel

In Excel 2019 you can use the Visual Basic Editor to create and manage your macros. It's important to identify the key objects in your macro in order to start writing code for your Excel document. In this course you will see how to insert procedures and start writing code. You will also see how to use objects and even create events to interact with those objects. Once you start writing code it's important to know how to identify and correct errors found in your code.

In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Creating & Editing Macros Exercise as well as the associated materials in the Resources section.

Asset ID	ds_msex2019_23_06_enus
Course Type	Video Course
Course Category	Accelerator 2.0: Office 365

Objectives
Excel 2019 for Windows: Creating & Editing Macros identify the key components of a macro work with modules in the VBA Editor insert procedures into macro modules write code in Visual Basic declare variables and insert constants insert objects and create object collections use operators execute actions under conditions create events manage errors Knowledge Check: Creating & Editing Macros

Objectives

Excel 2019 for Windows: Creating & Editing Macros

identify the key components of a macro
work with modules in the VBA Editor
insert procedures into macro modules
write code in Visual Basic
declare variables and insert constants
insert objects and create object collections
use operators
execute actions under conditions
create events
manage errors
Knowledge Check: Creating & Editing Macros