Getting to Know Macros

Excel 2019 (Windows)
  • 10 Videos | 33m 44s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Likes 53 Likes 53
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.

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

  • Playable
    1. 
    Recording a macro
    3m 1s
    UP NEXT
  • Playable
    2. 
    Saving a workbook with macros
    3m 24s
  • Locked
    3. 
    Discovering Excel macro tools
    3m 32s
  • Locked
    4. 
    Navigating the VBA Editor
    3m 52s
  • Locked
    5. 
    Running macros
    3m 25s
  • Locked
    6. 
    Managing macros
    3m 7s
  • Locked
    7. 
    Editing a macro
    3m 41s
  • Locked
    8. 
    Enabling macros in a workbook
    3m 5s
  • Locked
    9. 
    Managing macros security options
    3m 15s
  • Locked
    10. 
    Using macros in different workbooks
    3m 23s

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.

YOU MIGHT ALSO LIKE

Likes 713 Likes 713  
Likes 84 Likes 84  
Likes 279 Likes 279  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 23 Likes 23  
Likes 12 Likes 12  
Likes 146 Likes 146