Getting to Know Macros in Excel Microsoft 365 for Windows

Excel Microsoft 365 (Windows)    |    Expert
  • 10 videos | 36m 55s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 3 users Rating 4.7 of 3 users (3)
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

  • 2m 32s
    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 42s
    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 Microsoft 365 for Windows
    3m 41s
    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 Microsoft 365 for Windows
    4m 54s
    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 Microsoft 365 for Windows
    2m 59s
    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 Microsoft 365 for Windows
    3m 46s
    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 Microsoft 365 for Windows
    3m 47s
    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 Microsoft 365 for Windows
    2m 47s
    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 Microsoft 365 for Windows
    3m 57s
    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 Microsoft 365 for Windows
    4m 51s
    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

Course Working with macros in Excel 365 (2024)
Rating 3.5 of 6 users Rating 3.5 of 6 users (6)
Book Microsoft Excel In Easy Steps: Illustrated Using Excel in Office 365
Course 10 common tools in Excel 365 (2023)
Rating 3.0 of 2 users Rating 3.0 of 2 users (2)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Using fields, forms and macros in Word Microsoft 365 (2021)
Rating 4.5 of 25 users Rating 4.5 of 25 users (25)
Course Collaborating effectively in Excel 365
Rating 4.6 of 378 users Rating 4.6 of 378 users (378)
Course Advanced Topics in C: Managing Code Compilations Using Preprocessor Directives
Rating 4.3 of 73 users Rating 4.3 of 73 users (73)