Productivity & Collaboration Tools     Office 365     Excel 365

---

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.

---

---

Objectives

Excel 365: Creating and editing macros in Excel 365 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 Knowledge Check: Creating and editing macros in Excel 365