Working with macros in Excel 365 (2024)

Excel 365 (2024)    |    Expert
  • 12 videos | 52m 51s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Macros in Excel 365 help you automate tasks, create custom functions, and enhance your productivity. In this course, discover how to use Visual Basic for Applications (VBA) to its full potential, transforming your Excel 365 experience and significantly boosting your efficiency. First, learn how to work with modules, insert procedures, and write effective VBA code. Explore the use of variables and constants to make your code flexible and robust. Gain a solid understanding of Excel objects, enabling you to manipulate workbooks, worksheets, and ranges with precision. Next, discover how to use operators and conditions to control the flow of your programs. Also, learn how to create and handle events to make your applications responsive to user actions. In addition, see how to design and program UserForms to create interactive forms for data input. Finally, learn how to address error management, ensuring that your macros run smoothly and efficiently. Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this working with macros in excel 365 (2024) course
    Create, edit and remove modules
    Insert procedures into macro modules
    Write code in visual basic
    Declare variables and insert constants
    Insert objects and create object collections
  • Use arithmetic, comparison, and logical operators in vba code
    Write conditional statements with if and select case in vba code
    Create events to rename a worksheet and to set up reminders
    Insert, format and remove userforms
    Program a form to perform actions
    Manage and correct macro errors

IN THIS COURSE

  • 51s
    This video outlines the key content covered in this Working with macros in Excel 365 (2024) course, including how to work with modules, create procedures and create and program forms. FREE ACCESS
  • 3m 48s
    In the Visual Basic editor, macros are stored within project component modules. In this video, learn how to add and rename modules to start coding in Excel 365. FREE ACCESS
  • Locked
    3.  Inserting procedures in Excel 365
    4m 38s
    In Excel 365, modules are used to store procedures. Discover how to use the Visual Basic editor to manually insert procedures, or use the Insert tool to quickly add public and private procedures to your modules. FREE ACCESS
  • Locked
    4.  Writing code in Visual Basic for Excel 365
    5m 15s
    With Visual Basic in Excel 365, learn how to write code from scratch. Discover how to add properties, methods, and comments. Additionally, learn how to edit code formatting by using the available editing tools. FREE ACCESS
  • Locked
    5.  Using variables and constants in Excel 365
    4m 22s
    When creating macros in Excel 365, it's important to know how to declare and assign variables. In this video, also discover how to insert constants to save time when writing code in Visual Basic. FREE ACCESS
  • Locked
    6.  Using objects in Excel 365
    4m 27s
    Visual Basic works with an object model program. Learn how to easily insert objects, browse the object library, and create object collections in Excel 365. FREE ACCESS
  • Locked
    7.  Using operators in Excel 365
    4m 48s
    In VBA macros, operators allow you to perform calculations and evaluate conditions. In this video, you will see how to use arithmetic operators to perform calculations. You will also learn how to evaluate and combine conditions using comparison and logical operators. FREE ACCESS
  • Locked
    8.  Writing conditional statements in Excel 365
    5m 30s
    Conditional statements are crucial for creating responsive and intelligent Excel macros. In this video, we’ll explore the power of conditional statements in VBA. You’ll learn how to use If... Then... Else... and Select Case statements to control the flow of your macros based on different conditions. FREE ACCESS
  • Locked
    9.  Creating events in Excel 365
    5m 7s
    Event procedures enable interactions with objects. Learn how to rename spreadsheets and create reminders using the event procedures available in Excel 365. FREE ACCESS
  • Locked
    10.  Creating a form in Excel 365
    4m 57s
    The VBA editor in Excel 365 provides tools to insert and modify UserForms. A UserForm object is a window or dialog box that forms part of an application's user interface. Learn how to add a UserForm, insert UserForm objects, and remove UserForms or objects that are no longer needed. FREE ACCESS
  • Locked
    11.  Programming a form in Excel 365
    3m 44s
    Forms allow for easy data entry in an Excel 365 worksheet. Learn how to program a form to perform actions such as data entry, saving entries, or canceling actions. FREE ACCESS
  • Locked
    12.  Managing macro errors in Excel 365
    5m 25s
    There are three types of errors that can occur in macros: syntax, runtime, and logic errors. Discover how to identify and correct macro errors 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

Course Managing macros in Excel 365
Rating 4.4 of 163 users Rating 4.4 of 163 users (163)
Course Troubleshooting common issues in Excel 365
Rating 4.6 of 190 users Rating 4.6 of 190 users (190)
Book Excel 2021 / Microsoft 365 Programming By Example