Working with Macros
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 UserFormscustomize UserFormsprogram a formcreate actions to track changes in macros
-
use macros in formulasuse macros to format textuse macros to calculate formatted valuesuse macros to export charts
IN THIS COURSE
-
1.Creating a form5m 50sUP NEXT
-
2.Customizing a form6m 40s
-
3.Programming a form5m 9s
-
4.Tracking changes with macros4m 9s
-
5.Using macros in formulas3m 24s
-
6.Formatting data with macros4m 31s
-
7.Calculating formatted values with macros3m 32s
-
8.Exporting charts with macros3m 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.