Microsoft Excel Visual Basic, 2-Day Online Training Course

* 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