Getting to Know Macros in Excel
Excel Microsoft 365 (Windows)
| Expert
- 10 Videos | 36m 55s
- Includes Assessment
- Earns a Badge
Learners will receive an in-depth exploration of macros to automate frequent tasks in Excel for Office 365, in this 10-video course, which shows how to record macros, perform actions to automate tasks, and how to save a workbook as an Excel macro-enabled workbook. You will examine how to access macro tools by adding macro recording to the status bar, and by activating the Developer tab in the tool ribbon. Next, you will learn how to use the Visual Basic editor and navigate the key interface tools to manage your macros and workbook VBA (Visual Basic for Applications) code. You will learn how to use the VBA editor to remove unwanted actions, correct errors, or remove macros from your Excel macro document. You will examine Excel's security and warning details to ensure a macro from an outside source is safe, and learn how to access and manage documents from the Developer tab. Finally, learners will observe how to copy and import macros into other macro documents.
WHAT YOU WILL LEARN
-
record macrossave a workbook with macrosidentify and use the key macro toolsnavigate and discover the VBA Editor interfacerun macros within Excel
-
manage macrosedit macrosenable macros in a workbookmanage macro security optionsuse macros across multiple workbooks
IN THIS COURSE
-
1.Recording a macro2m 32sUP NEXT
-
2.Saving a workbook with macros3m 42s
-
3.Discovering Excel macro tools3m 41s
-
4.Navigating the VBA Editor4m 54s
-
5.Running macros2m 59s
-
6.Managing macros3m 46s
-
7.Editing a macro3m 47s
-
8.Enabling macros in a workbook2m 47s
-
9.Managing macros security options3m 57s
-
10.Using macros in different workbooks4m 51s
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.