Working with Macros

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

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
    5m 50s
    UP NEXT
  • Playable
    2. 
    Customizing a form
    6m 40s
  • Locked
    3. 
    Programming a form
    5m 9s
  • Locked
    4. 
    Tracking changes with macros
    4m 9s
  • Locked
    5. 
    Using macros in formulas
    3m 24s
  • Locked
    6. 
    Formatting data with macros
    4m 31s
  • Locked
    7. 
    Calculating formatted values with macros
    3m 32s
  • Locked
    8. 
    Exporting charts with macros
    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

Likes 53 Likes 53  
Likes 23 Likes 23  
Likes 67 Likes 67  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SOLID & GRASP
Likes 3218 Likes 3218  
COURSE Managing Data
Likes 25 Likes 25