Working with Macros in Excel

Excel Microsoft 365 (Windows)    |    Expert
  • 8 Videos | 40m 40s
  • Includes Assessment
  • Earns a Badge
Likes 67 Likes 67
If you are using your Excel worksheet to input data, you can create form to fill out you worksheets more easily. With the VBA editor you can insert, edit and customize your forms to make inputting data easier for your users. Excel for Office 365 also gives you the possibility to use macros within formulas. You can use macros in formulas to format text, perform calculations and even export charts to easily share or present to others.

WHAT YOU WILL LEARN

  • insert, format and remover UserForms
    customize a form's size, color and alignment
    program a form to perform actions
    create actions to track changes in macros
  • insert a macro function as a formula
    format text using macros
    calculate formatted values with macros
    export charts using macros

IN THIS COURSE

  • Playable
    1. 
    Creating a form
    6m 10s
    UP NEXT
  • Playable
    2. 
    Customizing a form
    5m 53s
  • Locked
    3. 
    Programming a form
    5m 16s
  • Locked
    4. 
    Tracking changes with macros
    4m 31s
  • Locked
    5. 
    Using macros in formulas
    3m 5s
  • Locked
    6. 
    Formatting data with macros
    4m 40s
  • Locked
    7. 
    Calculating formatted values with macros
    3m 25s
  • Locked
    8. 
    Exporting charts with macros
    3m 40s

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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 218 Likes 218  
Likes 128 Likes 128  
Likes 44 Likes 44