Using macros in Excel 365

Excel Microsoft 365 (2021)    |    Expert
  • 9 videos | 31m 10s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.2 of 123 users Rating 4.2 of 123 users (123)
If you are using your Excel worksheet to input data, you can create forms to quickly fill out your worksheets. With the VBA editor, you can insert, edit, and customize your forms to make inputting data easier for your users. Excel 365 also makes it possible to use macros within formulas to format text, perform calculations, and even export charts to easily share or present the data to others. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this using macros in excel 365 course
    Insert, format, and remove userforms in excel 365
    Customize a userform in excel 365
    Program a form to perform actions in excel 365
    Create macro actions that track changes in excel 365
  • Insert a macro function as a formula in excel 365
    Create macros to format data in excel 365
    Calculate formatted values with macros in excel 365
    Export charts using macros in excel 365

IN THIS COURSE

  • 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
  • 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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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

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.

YOU MIGHT ALSO LIKE

Rating 4.5 of 25 users Rating 4.5 of 25 users (25)
Rating 4.6 of 416 users Rating 4.6 of 416 users (416)
Rating 4.6 of 385 users Rating 4.6 of 385 users (385)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 310 users Rating 4.5 of 310 users (310)
Rating 4.6 of 1009 users Rating 4.6 of 1009 users (1009)
Rating 4.4 of 163 users Rating 4.4 of 163 users (163)