Working with Macros in Excel
Excel Microsoft 365 (Windows)
| Expert
- 8 Videos | 36m 40s
- Includes Assessment
- Earns a Badge
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 for Office 365 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
-
insert, format and remover UserFormscustomize a form's size, color and alignmentprogram a form to perform actionscreate actions to track changes in macros
-
insert a macro function as a formulaformat text using macroscalculate formatted values with macrosexport charts using macros
IN THIS COURSE
-
1.Creating a form6m 10sUP NEXT
-
2.Customizing a form5m 53s
-
3.Programming a form5m 16s
-
4.Tracking changes with macros4m 31s
-
5.Using macros in formulas3m 5s
-
6.Formatting data with macros4m 40s
-
7.Calculating formatted values with macros3m 25s
-
8.Exporting charts with macros3m 40s
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.