Getting to Know Macros in Excel 2019 for Windows

Excel 2019 (Windows)    |    Expert
  • 10 videos | 33m 44s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.4 of 307 users Rating 4.4 of 307 users (307)
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • 3m 1s
    In order to automate tasks more easily you can record macros. See how to record macros and perform actions that can be implemented in your Excel workbooks. FREE ACCESS
  • 3m 24s
    Once you start recording macros it's important to save your workbook as an Excel macro enabled workbook. See how to easily save and identify Excel macro enabled workbooks. FREE ACCESS
  • Locked
    3.  Discovering Excel macro tools in Excel 2019 for Windows
    3m 32s
    Excel's macro tools are available in multiple locations. You can add macro recording to your status bar for easy access. You can also access more advanced macro tools by activating the Developer tab in your tool ribbon. FREE ACCESS
  • Locked
    4.  Navigating the VBA Editor in Excel 2019 for Windows
    3m 52s
    The Visual Basics Editor is an application easily accessible via Excel to manage your macros and workbook VBA code. See how to access the VBA Editor and navigate the key interface tools as well as identify the key tools needed to become familiar with the application layout. FREE ACCESS
  • Locked
    5.  Running macros in Excel 2019 for Windows
    3m 25s
    Once you've recorded a macro, you can run the macro to perform the recorded tasks. You can also insert buttons to run your macros directly from the worksheet interface. FREE ACCESS
  • Locked
    6.  Managing macros in Excel 2019 for Windows
    3m 7s
    Once you've recorded macros it's important to know how to find and manage those macros. See how to view, modify options and even remove macros that you no longer need. FREE ACCESS
  • Locked
    7.  Editing a macro in Excel 2019 for Windows
    3m 41s
    If you find that your macros are not running smoothly or you would like to streamline the actions, you can easily access and edit your macros in the VBA Editor. See how to remove unwanted actions, correct errors or even remove macros from your Excel macro document. FREE ACCESS
  • Locked
    8.  Enabling macros in a workbook in Excel 2019 for Windows
    3m 5s
    If you're opening a macro from another user you may be prompted to enable the content. Ensure that you are receiving a macro from a trusted source and discover the security details regarding this particular security warning in Excel. FREE ACCESS
  • Locked
    9.  Managing macros security options in Excel 2019 for Windows
    3m 15s
    From the Developer tab you can easily access your macro security settings. See how to access and manage security settings such as trusted documents as well as enable the message bar display. FREE ACCESS
  • Locked
    10.  Using macros in different workbooks in Excel 2019 for Windows
    3m 23s
    Rather than creating the same macros over and over, you can easily copy and import macros into other macro documents. See how to quickly copy, export and import macros into other workbooks in Excel. 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.

YOU MIGHT ALSO LIKE

Rating 4.9 of 7 users Rating 4.9 of 7 users (7)
Rating 3.5 of 57 users Rating 3.5 of 57 users (57)
Rating 4.5 of 1331 users Rating 4.5 of 1331 users (1331)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 455 users Rating 4.5 of 455 users (455)
Rating 4.4 of 855 users Rating 4.4 of 855 users (855)
Rating 4.5 of 143 users Rating 4.5 of 143 users (143)