Working with Macros in Excel 2019 for Windows

Excel 2019 (Windows)    |    Expert
  • 8 videos | 36m 48s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.4 of 91 users Rating 4.4 of 91 users (91)
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

  • 5m 50s
    The VBA editor in Excel 2019 enables you insert and modify UserForms. A UserForm object is a window or dialog box that makes up part of an application's user interface. See how to add a UserForm, insert UserForm objects and remove UserForm's or objects you no longer need. FREE ACCESS
  • 6m 40s
    Once you've inserted your UserForm and objects, you can start customizing the form to suit your needs. See how to resize the form, change the color and modify the text alignment with Excel 2019. FREE ACCESS
  • Locked
    3.  Programming a form in Excel 2019 for Windows
    5m 9s
    With forms you can add data entries into your Excel 2019 worksheet easily. See how to program a form to perform actions such as data entry, saving entries or cancelling actions. FREE ACCESS
  • Locked
    4.  Tracking changes with macros in Excel 2019 for Windows
    4m 9s
    In order to keep track of data entries, you can create actions to automatically insert the date and time alongside your form entries. See how to create macro actions and track changes in real-time with Excel 2019. FREE ACCESS
  • Locked
    5.  Using macros in formulas in Excel 2019 for Windows
    3m 24s
    You can use macros within formulas to execute functions in your Excel worksheet. See how to insert and test a formula containing a macro with Excel 2019. FREE ACCESS
  • Locked
    6.  Formatting data with macros in Excel 2019 for Windows
    4m 31s
    If you need to format your text, you can use macros to quickly change your text formatting, such as changing text to upper or proper case. See how to create macros to format text and run those macros in your worksheet in Excel 2019. FREE ACCESS
  • Locked
    7.  Calculating formatted values with macros in Excel 2019 for Windows
    3m 32s
    If you have specific values that you need to calculate in a list, you can use macros to find those values. See how to create a procedure and calculate values for specifically formatted values in your Excel 2019 worksheet. FREE ACCESS
  • Locked
    8.  Exporting charts with macros in Excel 2019 for Windows
    3m 33s
    If you frequently need to export your charts in Excel, you can create and run macros to export and save your charts. See how to create a macro to easily export your charts in Excel 2019. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 4.5 of 547 users Rating 4.5 of 547 users (547)
Rating 4.5 of 1588 users Rating 4.5 of 1588 users (1588)
Rating 4.2 of 123 users Rating 4.2 of 123 users (123)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 1052 users Rating 4.5 of 1052 users (1052)
Rating 4.4 of 250 users Rating 4.4 of 250 users (250)
Rating 4.4 of 1076 users Rating 4.4 of 1076 users (1076)