Using macros in Excel 365

Excel Microsoft 365 (2021)    |    Expert
  • 9 Videos | 31m 10s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
If you are using your Excel worksheet to input data, you can create forms to quickly fill out your worksheets. With the VBA editor, you can insert, edit, and customize your forms to make inputting data easier for your users. Excel 365 also makes it possible to use macros within formulas to format text, perform calculations, and even export charts to easily share or present the data to others. In order to practice what you have learned, you will find practice exercises and samples in the Resources section.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this Using macros in Excel 365 course
    insert, format, and remove UserForms in Excel 365
    customize a UserForm in Excel 365
    program a form to perform actions in Excel 365
    create macro actions that track changes in Excel 365
  • insert a macro function as a formula in Excel 365
    create macros to format data in Excel 365
    calculate formatted values with macros in Excel 365
    export charts using macros in Excel 365

IN THIS COURSE

  • Playable
    1. 
    Overview: Using macros in Excel 365
    51s
    UP NEXT
  • Playable
    2. 
    Creating a form
    3m 43s
  • Locked
    3. 
    Customizing a form
    4m 44s
  • Locked
    4. 
    Programming a form
    4m 41s
  • Locked
    5. 
    Tracking changes with macros
    3m 46s
  • Locked
    6. 
    Using macros in formulas
    3m 6s
  • Locked
    7. 
    Formatting data with macros
    4m 7s
  • Locked
    8. 
    Calculating formatted values with macros
    3m 14s
  • Locked
    9. 
    Exporting charts with macros
    2m 57s

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