Using macros in Excel 365

IN THIS COURSE

• 1.  Overview: Using macros in Excel 365
  51s
  This video outlines the key content covered in this Microsoft 365: Using macros in Excel 365 course, including how to create and customize a form, use macros in formulas, and how to format data with macros. FREE ACCESS
• 2.  Creating a form
  3m 43s
  The VBA editor in Excel 365 enables you to insert and modify UserForms. A UserForm object is a window or dialog box that makes up part of an application's user interface. In this video, you will explore how to insert, format, and remove UserForms in Excel 365. FREE ACCESS
• 3.  Customizing a form
  4m 44s
  Once you've inserted your UserForm and its objects, you can start customizing the form to suit your needs. For instance, you can resize the form, change the color, and modify the text alignment. In this video, you will explore how to customize a UserForm in Excel 365. FREE ACCESS
• 4.  Programming a form
  4m 41s
  User-defined forms allow you to easily add data entries to your Excel 365 worksheet. You can even program a form to support data input or to save data entries automatically. In this video, you will discover how to program a form to perform actions in Excel 365. FREE ACCESS
• 5.  Tracking changes with macros
  3m 46s
  To keep track of data entries, you can program a form to create actions that automatically insert the date and time alongside your form entries. This lets you keep a record of changes in real-time. In this video, you will explore how to create macro actions that track changes in Excel 365. FREE ACCESS
• 6.  Using macros in formulas
  3m 6s
  To ensure data accuracy, macros can be used within formulas to execute functions in an Excel 365 worksheet. In this video, you will explore how to insert a macro function as a formula in Excel 365. FREE ACCESS
• 7.  Formatting data with macros
  4m 7s
  With macros, formatting your worksheet data has never been quicker. You can use macros to quickly change the text formatting, such as changing text to uppercase or title case. This is useful, as you only need to run a macro once to apply all the relevant formatting changes. In this video, you will explore how to create macros to format data in Excel 365. FREE ACCESS
• 8.  Calculating formatted values with macros
  3m 14s
  If you have specific values that you want to calculate, you can use macros to do so. With macros in Excel 365, you can create a procedure that calculates specifically formatted values in a worksheet. In this video, you will explore how to calculate formatted values with macros in Excel 365. FREE ACCESS
• 9.  Exporting charts with macros
  2m 57s
  Whether you frequently export charts in Excel 365 or would like to make the process of doing so easier, you can use macros to export and save your charts. In this video, you will explore how to export charts using macros in Excel 365. FREE ACCESS