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
Tue, 3 Nov, 9am - Wed, 4 Nov, 4:30pm AEDT + 1 date
Microsoft Power BI DAX Essentials, Training Course in Sydney
Sydney, North Sydney NSW, Australia
Tue, 3 Nov, 5pm - Wed, 4 Nov, 12:30am EST + 14 dates
Microsoft Power BI Essentials, Online Training Course
Online Event
Tue, 3 Nov, 5pm - Wed, 4 Nov, 12:30am EST + 6 dates
Microsoft Power BI Report Design, Online Training Course
Online Event
Wed, 4 Nov, 9am - Thu, 5 Nov, 4:30pm AEDT + 1 date
Microsoft Power BI Advanced, 2-Day Training Course in Melbourne
Melbourne, Melbourne VIC, Australia
Tue, 3 Nov, 5pm - Wed, 4 Nov, 12:30am EST + 5 dates
Microsoft Excel for Beginners, 1-Day Online Training Course
Online Event
Wed, 4 Nov, 9am - 4:30pm AEDT
Microsoft Excel Advanced, 1-Day Training Course in Sydney
Sydney, North Sydney NSW, Australia
Wed, 4 Nov, 5pm - Fri, 6 Nov, 12:30am EST + 3 dates
Microsoft Power BI Advanced, 2-Day Online Training Course
Online Event
Wed, 4 Nov, 5pm - Thu, 5 Nov, 12:30am EST + 4 dates
Microsoft Excel Intermediate, 1-Day Online Training Course
Online Event
Wed, 4 Nov, 5:30pm - 7:30pm EST + 2 dates
Enhance Productivity with Copilot, 2-Hour Online Short Course
Online Event
Thu, 5 Nov, 10am - Sat, 7 Nov, 5:30pm AEDT + 1 date
Microsoft Power BI DAX Essentials, Training Course in Melbourne
Melbourne, Melbourne VIC, Australia
Wed, 4 Nov, 10pm - Thu, 5 Nov, 12am EST + 1 date
SharePoint Document Management Masterclass, 2-Hour Online Short Course
Online Event
Thu, 5 Nov, 5pm - Fri, 6 Nov, 12:30am EST + 9 dates
Microsoft Excel Advanced, 1-Day Online Training Course
Online Event