Managing macros in Excel 365

Excel Microsoft 365 (2021)    |    Expert
  • 11 Videos | 37m 1s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
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. 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 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
  • Locked
    4. 
    Inserting procedures
    3m 11s
  • Locked
    5. 
    Writing code in Visual Basic
    5m
  • Locked
    6. 
    Using variables and constraints
    2m 33s
  • Locked
    7. 
    Using objects
    4m 31s
  • Locked
    8. 
    Using operators
    2m 57s
  • Locked
    9. 
    Executing actions under conditions
    4m 16s
  • Locked
    10. 
    Creating events
    4m 52s
  • Locked
    11. 
    Managing errors
    4m

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

Likes 94 Likes 94  
Likes 1 Likes 1  
Likes 219 Likes 219