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
    FREE ACCESS
  • Locked
    4. 
    Navigating the VBA Editor
    4m 54s
    FREE ACCESS
  • Locked
    5. 
    Running macros
    2m 59s
    FREE ACCESS
  • Locked
    6. 
    Managing macros
    3m 46s
    FREE ACCESS
  • Locked
    7. 
    Editing a macro
    3m 47s
    FREE ACCESS
  • Locked
    8. 
    Enabling macros in a workbook
    2m 47s
    FREE ACCESS
  • Locked
    9. 
    Managing macros security options
    3m 57s
    FREE ACCESS
  • Locked
    10. 
    Using macros in different workbooks
    4m 51s
    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 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

COURSE Excel Visualization: Getting Started with Excel for Data Visualization
Likes 0 Likes 0  
COURSE Working with Macros in Excel
Likes 67 Likes 67  
COURSE Managing Data
Likes 75 Likes 75  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Finding & Analyzing Information with Formulas
Likes 103 Likes 103  
COURSE Custom & Conditional Formatting
Likes 178 Likes 178  
COURSE Getting Started with Excel for Office 365
Likes 1408 Likes 1408