Getting to Know Macros in Excel 2019 for Windows

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. If you have tasks in Excel 2019 that you do repeatedly, you can record a macro to automate those tasks. When you create a macro, you are recording your mouse clicks and keystrokes. After you create a macro, you can edit it to make minor changes to the way it works. Key concepts covered in this 10-video course include how to record macros and perform actions that can be implemented in Excel workbooks, how to save a workbook with macros and an Excel macro-enabled workbook, how to find and use macro tools that are available in multiple locations, and how to add macro recording to your status bar for easy access. Then learn how to navigate the VBA Editor interface, an application easily accessible via Excel, to manage your macros and workbook VBA code; how to manage macros, edit macros, and enable macros in a workbook; and how to access macro security settings and manage macro security options. Finally, you will observe how to use macros across multiple workbooks. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Getting to Know Macros Exercise as well as the associated materials in the Resources section.