Microsoft Excel Visual Basic, 2-Day Online Training Course
·
Online Event
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
Powered by
Tickets for good, not greed Humanitix dedicates 100% of profits from booking fees to charity
Register
Register
Register
Register
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















