Managing macros in Excel 365

Excel Microsoft 365 (2021)    |    Expert
  • 11 Videos | 36m 6s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Likes 1 Likes 1
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 course
    identify macro components in Excel 365
    work with modules in Excel 365
    insert procedures in Excel 365
    write code with Visual Basic in Excel 365
    use variables and constraints in Excel 365
  • use objects in Excel 365
    use operators in Excel 365
    execute actions under conditions in Excel 365
    create events in Excel 365
    manage errors in Excel 365

IN THIS COURSE

  • Playable
    1. 
    Overview: Managing macros in Excel 365
    52s
    UP NEXT
  • Playable
    2. 
    Identifying macro components
    2m 10s
  • Locked
    3. 
    Working with modules
    2m 40s
    FREE ACCESS
  • Locked
    4. 
    Inserting procedures
    3m 11s
    FREE ACCESS
  • Locked
    5. 
    Writing code in Visual Basic
    5m
    FREE ACCESS
  • Locked
    6. 
    Using variables and constraints
    2m 33s
    FREE ACCESS
  • Locked
    7. 
    Using objects
    4m 31s
    FREE ACCESS
  • Locked
    8. 
    Using operators
    2m 57s
    FREE ACCESS
  • Locked
    9. 
    Executing actions under conditions
    4m 16s
    FREE ACCESS
  • Locked
    10. 
    Creating events
    3m 57s
    FREE ACCESS
  • Locked
    11. 
    Managing errors
    4m
    FREE ACCESS

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

COURSE Getting to Know Macros in Excel
Likes 210 Likes 210  
BOOK Excel Basics
COURSE Adding & arranging data in Excel 365
Likes 13 Likes 13