Creating and editing macros in Excel 365
Excel Microsoft 365 (2021)
| Expert
- 11 videos | 34m 17s
- Includes Assessment
- Earns a Badge
- 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 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
-
54sThis 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 46sIf 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
-
3. Recording a macro2m 36sTasks 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
-
4. Saving a workbook with macros4m 5sOnce 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
-
5. Customizing Excel macro tools3m 12sExcel 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
-
6. Running macros2m 34sAfter 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
-
7. Viewing and modifying macros3m 3sMacros, 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
-
8. Navigating the VBA Editor4m 41sYou 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
-
9. Editing a macro3m 9sIf 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
-
10. Using macros in different workbooks3m 53sMacros 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
-
11. Managing macro security options3m 25sIn 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.
