Managing macros in Excel 365

IN THIS COURSE

• 1.  Overview: Managing macros in Excel 365
  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
• 2.  Identifying macro components
  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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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