Getting to Know Macros in Excel

Excel Microsoft 365 (Windows)
  • 10 Videos | 41m 55s
  • Includes Assessment
  • Earns a Badge
Likes 132 Likes 132
Learners will receive an in-depth exploration of macros to automate frequent tasks in Excel for Office 365, in this 10-video course, which shows how to record macros, perform actions to automate tasks, and how to save a workbook as an Excel macro-enabled workbook. You will examine how to access macro tools by adding macro recording to the status bar, and by activating the Developer tab in the tool ribbon. Next, you will learn how to use the Visual Basic editor and navigate the key interface tools to manage your macros and workbook VBA (Visual Basic for Applications) code. You will learn how to use the VBA editor to remove unwanted actions, correct errors, or remove macros from your Excel macro document. You will examine Excel's security and warning details to ensure a macro from an outside source is safe, and learn how to access and manage documents from the Developer tab. Finally, learners will observe how to copy and import macros into other macro documents.

WHAT YOU WILL LEARN

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

IN THIS COURSE

  • Playable
    1. 
    Recording a macro
    2m 32s
    UP NEXT
  • Playable
    2. 
    Saving a workbook with macros
    3m 42s
  • Locked
    3. 
    Discovering Excel macro tools
    3m 41s
  • Locked
    4. 
    Navigating the VBA Editor
    4m 54s
  • Locked
    5. 
    Running macros
    2m 59s
  • Locked
    6. 
    Managing macros
    3m 46s
  • Locked
    7. 
    Editing a macro
    3m 47s
  • Locked
    8. 
    Enabling macros in a workbook
    2m 47s
  • Locked
    9. 
    Managing macros security options
    3m 57s
  • Locked
    10. 
    Using macros in different workbooks
    4m 51s

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 67 Likes 67  
COURSE Managing Data
Likes 75 Likes 75  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 103 Likes 103  
Likes 178 Likes 178  
Likes 1408 Likes 1408