5910 Breckenridge Pkwy Suite B, Tampa, FL. 33610
(800) 272-0707

SkillSoft Explore Course

Collections     Accelerator 2.0: Office 365     Microsoft Office 2019: Intermediate Excel

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.



Objectives

Excel 2019 for Windows: Getting to Know Macros in Excel

  • record macros
  • save a workbook with macros
  • use key macros tools
  • navigate the VBA Editor
  • run macros in Excel
  • manage macros
  • edit a macro
  • enable macros in a workbook
  • manage macro security options
  • use macros across multiple workbooks