5910 Breckenridge Pkwy Suite B, Tampa, FL. 33610
(800) 272-0707

SkillSoft Explore Course

Collections     Accelerator 2.0: Office 365     Microsoft Office 2019: Intermediate Excel

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.


In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Working with Macros Exercise as well as the associated materials in the Resources section.



Objectives

Excel 2019 for Windows: Working with Macros in Excel

  • work with UserForms
  • customize UserForms
  • program a form
  • create actions to track changes in macros
  • use macros in formulas
  • use macros to format text
  • use macros to calculate formatted values
  • use macros to export charts
  • Knowledge Check: Working with Macros