Getting to Know Macros in Excel Microsoft 365 for Windows

Excel Microsoft 365 (Windows)    |    Expert
  • 10 Videos | 36m 55s
  • Includes Assessment
  • Earns a Badge
Likes 210 Likes 210
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • Playable
    1. 
    Recording a macro in Excel Microsoft 365 for Windows
    2m 32s
    UP NEXT
  • Playable
    2. 
    Saving a workbook with macros in Excel Microsoft 365 for Windows
    3m 42s
  • Locked
    3. 
    Discovering Excel macro tools in Excel Microsoft 365 for Windows
    3m 41s
  • Locked
    4. 
    Navigating the VBA Editor in Excel Microsoft 365 for Windows
    4m 54s
  • Locked
    5. 
    Running macros in Excel Microsoft 365 for Windows
    2m 59s
  • Locked
    6. 
    Managing macros in Excel Microsoft 365 for Windows
    3m 46s
  • Locked
    7. 
    Editing a macro in Excel Microsoft 365 for Windows
    3m 47s
  • Locked
    8. 
    Enabling macros in a workbook in Excel Microsoft 365 for Windows
    2m 47s
  • Locked
    9. 
    Managing macros security options in Excel Microsoft 365 for Windows
    3m 57s
  • Locked
    10. 
    Using macros in different workbooks in Excel Microsoft 365 for Windows
    4m 51s

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

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE