Getting to Know Macros

Excel 2019 (Windows)    |    Expert
  • 10 Videos | 48m 44s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Likes 94 Likes 94
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 95 Likes 95  
Likes 172 Likes 172  
Likes 266 Likes 266  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 132 Likes 132  
Likes 46 Likes 46  
Likes 212 Likes 212