Getting to Know Macros in Excel Microsoft 365 for Windows


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Learners will receive an in-depth exploration of macros to automate frequent tasks in Excel for Office 365, in this 10-video course, which shows how to record macros, perform actions to automate tasks, and how to save a workbook as an Excel macro-enabled workbook. You will examine how to access macro tools by adding macro recording to the status bar, and by activating the Developer tab in the tool ribbon. Next, you will learn how to use the Visual Basic editor and navigate the key interface tools to manage your macros and workbook VBA (Visual Basic for Applications) code. You will learn how to use the VBA editor to remove unwanted actions, correct errors, or remove macros from your Excel macro document. You will examine Excel's security and warning details to ensure a macro from an outside source is safe, and learn how to access and manage documents from the Developer tab. Finally, learners will observe how to copy and import macros into other macro documents.



Expected Duration (hours)
0.6

Lesson Objectives

Getting to Know Macros in Excel Microsoft 365 for Windows

  • record macros
  • save a workbook with macros
  • identify and use the key macro tools
  • navigate and discover the VBA Editor interface
  • run macros within Excel
  • manage macros
  • edit macros
  • enable macros in a workbook
  • manage macro security options
  • use macros across multiple workbooks
  • Course Number:
    ds_msex365_22_enus

    Expertise Level
    Expert