Creating and editing macros in Excel 365

Excel Microsoft 365 (2021)    |    Expert
  • 11 Videos | 34m 17s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
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.

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
    UP NEXT
  • Playable
    2. 
    Enabling macros in a workbook
    2m 46s
  • Locked
    3. 
    Recording a macro
    2m 36s
  • Locked
    4. 
    Saving a workbook with macros
    4m 5s
  • Locked
    5. 
    Customizing Excel macro tools
    3m 12s
  • Locked
    6. 
    Running macros
    2m 34s
  • Locked
    7. 
    Viewing and modifying macros
    3m 3s
  • Locked
    8. 
    Navigating the VBA Editor
    4m 41s
  • Locked
    9. 
    Editing a macro
    3m 9s
  • Locked
    10. 
    Using macros in different workbooks
    3m 53s
  • Locked
    11. 
    Managing macro security options
    3m 25s

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

Likes 1 Likes 1  
Likes 94 Likes 94