Creating and editing macros in Excel 365

Excel Microsoft 365 (2021)    |    Expert
  • 11 videos | 34m 17s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
If you have tasks in Excel 365 that you perform repeatedly, you can record a macro to automate those tasks. When creating a macro, you are recording your mouse clicks and keystrokes. After you create a macro, you can edit it to change the way it works. In this course, you will explore how to record macros and perform actions that can be implemented in Excel workbooks, and how to save in an Excel macro-enabled workbook. Find and use macro tools that are available in multiple locations, use macros across multiple workbooks, and add the Macro recording button to your status bar for easier access. In addition, you will learn how to navigate the VBA Editor interface, which is an application that's accessible via Excel, to manage your macros and workbook VBA code. You will further explore how to manage macros, edit macros, and enable macros in a workbook; and how to access and manage macro security settings. In order to practice what you have learned, you will find practice exercises and samples in the Resources section.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this Creating and editing macros in Excel 365 course
    enable macros in an Excel 365 workbook
    record a macro in Excel 365
    save an Excel 365 workbook with macros
    customize Excel 365 macro tools
    run macros in Excel 365
  • view and modify macros in Excel 365
    navigate the VBA Editor in Excel 365
    edit a macro in Excel 365
    use macros in different Excel 365 workbooks
    manage macro security options in Excel 365

IN THIS COURSE

  • Playable
    1.  Overview: Creating and editing macros in Excel 365
    54s
    This video outlines the key content covered in this Microsoft 365: Creating and editing macros in Excel 365 course, including how to enable and record a macro, navigate the VBA Editor, and how to manage use macros in… FREE ACCESS
  • Playable
    2.  Enabling macros in a workbook
    2m 46s
    If you're opening an Excel 365 workbook with macros that you’ve received from another user, you’ll be prompted to enable the content. You can check that you’re receiving the workbook from a trusted source and discover the… FREE ACCESS
  • Locked
    3.  Recording a macro
    2m 36s
    Tasks can be automated in Excel 365 by recording your mouse clicks and keystrokes. Once the macro is recorded, Excel will automatically execute the steps when instructed to do so. In this video, you will discover how to… FREE ACCESS
  • Locked
    4.  Saving a workbook with macros
    4m 5s
    Once you start recording macros in Excel 365, it's important to save your workbook in the correct format. If your workbook isn’t saved as an Excel macro-enabled workbook, the macros cannot save. In this video, you will… FREE ACCESS
  • Locked
    5.  Customizing Excel macro tools
    3m 12s
    Excel 365's macro tools are available in multiple locations. You can add the Macro recording tool to your Status bar or access more advanced macro tools by activating the Developer tab. In this video, you will learn… FREE ACCESS
  • Locked
    6.  Running macros
    2m 34s
    After recording a macro in Excel 365, you have multiple options to run the macro to perform the recorded tasks. Use the Macro tool on the View tab or insert buttons to run your macros directly from the worksheet… FREE ACCESS
  • Locked
    7.  Viewing and modifying macros
    3m 3s
    Macros, once added to Excel 365, can be modified, such as changing the keyboard shortcut. It's also important to know how to locate the macros you've saved. You can even remove macros you no longer use. In this video, you… FREE ACCESS
  • Locked
    8.  Navigating the VBA Editor
    4m 41s
    You can access the Microsoft Visual Basic for Applications Editor in Excel 365 to manage your macros and workbook VBA code. In this video, you will discover how to access and navigate the VBA Editor in Excel 365 as well… FREE ACCESS
  • Locked
    9.  Editing a macro
    3m 9s
    If your Excel 365 macros are not running smoothly or you want to streamline the actions, you can easily access and edit them in the VBA Editor. You can remove unwanted actions, correct errors, or even delete macros. In… FREE ACCESS
  • Locked
    10.  Using macros in different workbooks
    3m 53s
    Macros in Excel 365 can easily be transferred from one workbook to another. With the VBA Editor, you can quickly copy, export, and import macros. In this video, you will explore how to use macros in different Excel 365… FREE ACCESS
  • Locked
    11.  Managing macro security options
    3m 25s
    In Excel 365, there are various ways to access your macro security settings. In the Trust Center, you can modify various options, such as trusted documents and the message bar display. In this video, you will learn how to… 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.