Managing macros in Excel 365
Excel Microsoft 365 (2021)
| Expert
- 11 Videos | 36m 6s
- Includes Assessment
- Earns a Badge
- CPE
- PMI PDU
In Excel 365, you can use the Visual Basic Editor to create and manage your macros. It's important to learn how to identify macro components, so you can start writing code for your Excel workbook. In this course, you will explore how to insert procedures and write code in the VBA Editor. You will also learn about using objects and even creating events to interact with those objects. Once you start creating macros, it's important to know how to identify and correct errors found in your code.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this Managing macros in Excel 365 courseidentify macro components in Excel 365work with modules in Excel 365insert procedures in Excel 365write code with Visual Basic in Excel 365use variables and constraints in Excel 365
-
use objects in Excel 365use operators in Excel 365execute actions under conditions in Excel 365create events in Excel 365manage errors in Excel 365
IN THIS COURSE
-
1.Overview: Managing macros in Excel 36552sUP NEXT
-
2.Identifying macro components2m 10s
-
3.Working with modules2m 40s
-
4.Inserting procedures3m 11s
-
5.Writing code in Visual Basic5m
-
6.Using variables and constraints2m 33s
-
7.Using objects4m 31s
-
8.Using operators2m 57s
-
9.Executing actions under conditions4m 16s
-
10.Creating events3m 57s
-
11.Managing errors4m
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.YOU MIGHT ALSO LIKE

BOOK
Excel Basics