Creating and editing macros in Excel 365

Excel    |    Expert
  • 11 videos | 34m 17s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.5 of 380 users Rating 4.5 of 380 users (380)
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 Course Contents pane or 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

  • 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 different workbooks. FREE ACCESS
  • 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 security details regarding this particular security warning in Excel. In this video, you will explore how to enable macros in an Excel 365 workbook. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 1.1.3 Enable macros in a workbook. 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 record a macro in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 3.6.1 Record simple macros. 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 discover how to save an Excel 365 workbook with macros. 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 how to customize Excel 365 macro tools. 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 interface. In this video, you will explore how to run macros in Excel 365. 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 will explore how to view and modify macros in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 3.6.2 Name simple macros. 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 as identify the key tools needed to become familiar with the application layout. 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 this video, you will learn how to edit a macro in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 3.6.3 Edit simple macros. 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 workbooks. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 1.1.1 Copy macros between workbooks. 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 manage macro security options in Excel 365. 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.

YOU MIGHT ALSO LIKE

Rating 4.5 of 2242 users Rating 4.5 of 2242 users (2242)
Rating 4.5 of 1331 users Rating 4.5 of 1331 users (1331)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 378 users Rating 4.6 of 378 users (378)
Rating 4.5 of 1670 users Rating 4.5 of 1670 users (1670)
Rating 4.6 of 190 users Rating 4.6 of 190 users (190)