Working with Macros in Excel 2019 for Windows
Excel 2019 (Windows)
| Expert
- 8 videos | 36m 48s
- Includes Assessment
- Earns a Badge
- CPE
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 50sThe 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 40sOnce 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
-
3. Programming a form in Excel 2019 for Windows5m 9sWith 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
-
4. Tracking changes with macros in Excel 2019 for Windows4m 9sIn 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
-
5. Using macros in formulas in Excel 2019 for Windows3m 24sYou 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
-
6. Formatting data with macros in Excel 2019 for Windows4m 31sIf 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
-
7. Calculating formatted values with macros in Excel 2019 for Windows3m 32sIf 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
-
8. Exporting charts with macros in Excel 2019 for Windows3m 33sIf 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.
