Working with Macros in Excel 2019 for Windows

Excel 2019 (Windows)    |    Expert
  • 8 Videos | 36m 48s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Likes 77 Likes 77
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • Playable
    1. 
    Creating a form in Excel 2019 for Windows
    5m 50s
    UP NEXT
  • Playable
    2. 
    Customizing a form in Excel 2019 for Windows
    6m 40s
  • Locked
    3. 
    Programming a form in Excel 2019 for Windows
    5m 9s
  • Locked
    4. 
    Tracking changes with macros in Excel 2019 for Windows
    4m 9s
  • Locked
    5. 
    Using macros in formulas in Excel 2019 for Windows
    3m 24s
  • Locked
    6. 
    Formatting data with macros in Excel 2019 for Windows
    4m 31s
  • Locked
    7. 
    Calculating formatted values with macros in Excel 2019 for Windows
    3m 32s
  • Locked
    8. 
    Exporting charts with macros in Excel 2019 for Windows
    3m 33s

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

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 231 Likes 231  
Likes 1 Likes 1