Working with Macros in Excel Microsoft 365 for Windows
Excel
| 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 userforms
Customize a form's size, color and alignment
Program a form to perform actions
Create actions to track changes in macros -
Insert a macro function as a formula
Format text using macros
Calculate formatted values with macros
Export charts using macros
IN THIS COURSE
-
6m 10sThe VBA editor in Excel for Office 365 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 object you no longer need. FREE ACCESS
-
5m 53sOnce 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 for Office 365. FREE ACCESS
-
3. Programming a form in Excel Microsoft 365 for Windows5m 16sWith forms you can add data entries into your Excel for Office 365 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 Microsoft 365 for Windows4m 31sIn 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 for Office 365. FREE ACCESS
-
5. Using macros in formulas in Excel Microsoft 365 for Windows3m 5sYou can use macros within formulas to execute functions in your Excel worksheet. See how to insert and test a formula containing a macro function in Excel for Office 365. FREE ACCESS
-
6. Formatting data with macros in Excel Microsoft 365 for Windows4m 40sIf 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 for Office 365. FREE ACCESS
-
7. Calculating formatted values with macros in Excel Microsoft 365 for Windows3m 25sIf 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 for Office 365 worksheet. FREE ACCESS
-
8. Exporting charts with macros in Excel Microsoft 365 for Windows3m 40sIf you frequently need to export your charts in Excel, you can create and run macros to export and save you charts. See how to create a macro to easily export your charts in Excel for Office 365. 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.
