Managing macros in Excel 365
Excel Microsoft 365 (2021)
| Expert
- 11 videos | 37m 1s
- Includes Assessment
- Earns a Badge
- CPE
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. In order to practice what you have learned, you will find practice exercises and samples in the Resources section.
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 events4m 52s
-
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 on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.