Getting to Know Macros in Excel 2019 for Windows

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.