Excel 2019: Working with Macros in Excel


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

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 2019 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.



Expected Duration (hours)
0.6

Lesson Objectives

Excel 2019: Working with Macros in Excel

  • 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
  • Course Number:
    ds_msex2019_24_enus

    Expertise Level
    Expert