5910 Breckenridge Pkwy Suite B, Tampa, FL. 33610
(800) 272-0707

SkillSoft Explore Course

Collections     Accelerator 2.0: Office 365     Microsoft Microsoft 365: Intermediate Excel

In Excel for Office 365 you can use the Visual Basic Editor to create and manage your macros. It's important to identify the key objects in your macro in order to start writing code for your Excel document.


In this course you will see how to insert procedures and start writing code. You will also see how to use objects and even create events to interact with those objects. Once you start writing code it's important to know how to identify and correct errors found in your code.



Objectives

Excel Office 365 (Windows): Creating & Editing Macros

  • identify the key components of a macro
  • create, edit and remove modules
  • insert procedures into your macro modules
  • write code in Visual Basic
  • declare variables and insert constants
  • insert objects and create object collections
  • insert and test operators
  • execute actions under conditions
  • create events
  • manage and correct macro errors