Payment plans

How does it work?

  • Reserve your order today and pay over time in regular, automatic payments.
  • You’ll receive your tickets and items once the final payment is complete.
  • No credit checks or third-party accounts - just simple, secure, automatic payments using your saved card.

Microsoft Excel Visual Basic, 2-Day Online Training Course

Share

 · 
Online Event

Add to calendar

 

Description

* Please note that this is an online course, delivered remotely by a live instructor through Zoom *

Course Code: EXLVBA

Duration: 2 Days

Overview

During this 2 day course, instructors will teach participants to use the VBA Editor, understand the Excel object model, write code and use a range of common programming techniques. Students will learn to create a variety of macros, customise menus and forms, work with user-defined functions, command procedures and variables, and automate advanced procedures.

Audience

This course is intended for proficient Microsoft Excel users who wish to learn how to automate standard features and develop programs in VBA.

Prerequisites

This course assumes the student has completed Excel Advanced course, or have equivalent skills. Participants should have extensive experience designing and creating workbooks and have a good working knowledge of formulas, ranges, functions and multiple workbooks.

Module List

  • Module 1: Understanding Excel VBA
  • Module 2: Starting with Excel VBA
  • Module 3: Procedures
  • Module 4: Using Variables
  • Module 5: Functions in VBA
  • Module 6: Using Excel Objects
  • Module 7: Programming Techniques
  • Module 8: Creating Custom Forms
  • Module 9: Programming UserForms
  • Module 10: Automatic Startup
  • Module 11: Error Handling

Click here for the full 'Excel Visual Basic' course outline 

Powered by

Tickets for good, not greed Humanitix dedicates 100% of profits from booking fees to charity

Register

Register

Register

Register

Online Event

More events from this host

Thu, 19 Nov, 5pm - Fri, 20 Nov, 12:30am EST  + 8 dates
Microsoft Power BI Essentials, Online Training Course
Online Event
Thu, 19 Nov, 5pm - Fri, 20 Nov, 12:30am EST  + 5 dates
Microsoft Excel Advanced, 1-Day Online Training Course
Online Event
Mon, 23 Nov, 9am - Tue, 24 Nov, 4:30pm AEDT 
Microsoft Power BI DAX Essentials, Training Course in Melbourne
Melbourne, Melbourne VIC, Australia
Sun, 22 Nov, 5pm - Mon, 23 Nov, 12:30am EST 
Microsoft Excel Intermediate, 1-Day Online Training Course
Online Event
Mon, 23 Nov, 9am - 4:30pm AEDT 
Microsoft Word for Beginners, 1-Day Training Course in Melbourne
Melbourne, Melbourne VIC, Australia
Mon, 23 Nov, 9am - 4:30pm AEDT 
Microsoft Word for Beginners, 1-Day Training Course in Sydney
Sydney, North Sydney NSW, Australia
Sun, 22 Nov, 5:30pm - 7:30pm EST  + 1 date
Supercharging your Power Automate Approvals, 2-Hour Online Short Course
Online Event
Mon, 23 Nov, 9:30am - Thu, 26 Nov, 5pm ACST  + 2 dates
SharePoint Online for Power Users, 4-Day Training Course in Darwin
Darwin, Darwin City NT, Australia
Mon, 23 Nov, 9:30am - Tue, 24 Nov, 5pm ACST  + 2 dates
SharePoint Online for End Users, 2-Day Training Course in Darwin
Darwin, Darwin City NT, Australia
Sun, 22 Nov, 10pm - Mon, 23 Nov, 12am EST  + 2 dates
Creating Agents with Copilot Studio, 2-Hour Online Short Course
Online Event
Mon, 23 Nov, 5pm - Tue, 24 Nov, 12:30am EST  + 1 date
Microsoft Excel for Beginners, 1-Day Online Training Course
Online Event
Tue, 24 Nov, 9am - 4:30pm AEDT 
Microsoft Word Intermediate, 1-Day Training Course in Melbourne
Melbourne, Melbourne VIC, Australia