Managing macros in Excel 365

Excel Microsoft 365 (2021)    |    Expert
  • 11 videos | 37m 1s
  • Includes Assessment
  • Earns a Badge
  • Certification 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 Course Contents pane or 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

  • 52s
    This video outlines the key content covered in this Microsoft 365: Managing macros in Excel 365 course, including how to insert procedures, write code with the VBA Editor, and how to manage and correct macro errors. FREE ACCESS
  • 2m 10s
    From Excel 365’s Visual Basic Editor, you can get a complete view of your macros and their components. These components include comments, sub procedure, and executable statements. In this video, you will explore how to identify macro components in Excel 365. FREE ACCESS
  • Locked
    3.  Working with modules
    2m 40s
    Excel 365 macros can be edited with Visual Basic. In the VBA Editor, macros are contained within modules. You can add modules, rename modules, and even remove modules. In this video, you will discover how to work with modules in Excel 365. FREE ACCESS
  • Locked
    4.  Inserting procedures
    3m 11s
    Modules in Excel 365 are used to store procedures. In the VBA editor you can manually insert procedures or use the insert tool. These procedures can be public or private. In this video, you will learn how to insert procedures in Excel 365. FREE ACCESS
  • Locked
    5.  Writing code in Visual Basic
    5m
    With Visual Basic in Excel 365 you can write your own code from scratch. While writing code, you can add properties, methods, and comments. You can also edit your code formatting by using the Edit tool. In this video, you will explore how to write code with Visual Basic in Excel 365. FREE ACCESS
  • Locked
    6.  Using variables and constraints
    2m 33s
    When creating macros in Excel 365, you will need to know how to declare and assign variables. You'll also need to insert constants to save time when writing code in Visual Basic. In this video, you will discover how to use variables and constraints in Excel 365. FREE ACCESS
  • Locked
    7.  Using objects
    4m 31s
    Visual Basic in Excel 365 works with an object model program. You can easily insert an object, browse the object library and create object collections. In this video, you will learn how to use objects in Excel 365. FREE ACCESS
  • Locked
    8.  Using operators
    2m 57s
    You can insert operators into your Excel 365 macros to perform calculations. It's also possible to insert comparison and logical operators to perform calculations if certain criteria are met. In this video, you will explore how to use operators in Excel 365. FREE ACCESS
  • Locked
    9.  Executing actions under conditions
    4m 16s
    With Excel 365, you can insert procedures with conditions using If, Then, and Else to return specific values. It also gives you the possibility to work with cases by inserting the CaseValue procedure. In this video, you will discover how to execute actions under conditions in Excel 365. FREE ACCESS
  • Locked
    10.  Creating events
    4m 52s
    Event procedures in Excel 365 enable you to interact with objects. You can rename spreadsheets and create reminders within the Excel application. In this video, you will learn how to create events in Excel 365. FREE ACCESS
  • Locked
    11.  Managing errors
    4m
    When using macros in Excel 365 there are three types of errors that can occur: syntax, runtime, and logic errors. It's important to know how to identify and correct macro errors. In this video, you will explore how to manage errors in Excel 365. 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Creating and editing macros in Excel 365
Course Excel Visualization: Getting Started with Excel for Data Visualization
Course Formatting cells and ranges in Excel 365

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Performing data analysis and forecasting in Excel 365
Course Performing data calculations using formulas in Excel 365
Course Manipulating PivotTable data in Excel 365