Microsoft Excel Visual Basic | Online | Mon 11 Jan – Tue 12 Jan 2027
$900 (excl. GST)
Microsoft Excel Visual Basic — Advanced level, 2 Days, Online. Starts Mon 11 Jan 2027.
* 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
Combined with some well built labs, and it makes it easy to navigate the mess that can be SharePoint
I give 3grow a solid 5/7, would recommend!
I've tried 3 of the popular google results for Microsoft Training courses. All of these felt like a very rote course. so much so that the instructors couldn't answer questions outside of the scripted exercises.
Attending 3Grow was the diamond in the rough for this market. Russ had the most knowledge and human-interface of M365, particularly sharepoint.
3Grow is the only M365 training provider in will recommend.
I will definitely be attending more training and have recommend other from the company to attend relevant training sessions.
As Australia’s only Microsoft 365-specialist training provider, at 3grow we take great pride in delivering quality Microsoft 365 training courses and workshops.
Our courses are designed to meet the needs of all involved in the full Microsoft 365 spectrum, from end users to developers and IT administrators, offering course across SharePoint, Power Apps, Power Automate, Microsoft Teams, Power BI, and more.
The public courses listed on Humanitix are ideal for organisations looking to upskill up-to 4 attendees; for larger groups or to find out how we can deliver a customised training program, get in touch via learn@3grow.net