VBA Intermediate Training

Loading the player ...

Description
Course Resources

VBA Intermediate Training

DURATION: 4.33 hours
VIDEOS: 37
LEVEL: Advanced

You’ve completed the beginner course in VBA – or you’ve used VBA in your personal life or at work. Now challenge yourself with the next logical step. Intermediate VBA is the learner friendly course that steps you through powerful, more advanced features and possibilities of making VBA do what you need it to.

In this course, you will learn:

Learn advanced methods for automating tedious Excel jobs.
How to write and implement Excel events.
Discover how to modify a variety of standard behaviors, such as double clicking, opening files and saving files.
Learn how to design and implement specialized classes of objects.
Discover how to customize the right click menu within cell ranges.
Learn external libraries, and how you can extend VBA’s capabilities beyond standard Excel options.
How to modify the Excel user interface, including the “Ribbon” and context menus to interact with your VBA code.
Test your knowledge with an online quiz and Certificate of Completion.

Course Format

This is a video-led training course. You can preview some videos in the pane above. This course is suitable for Windows or Mac users.

VBA Intermediate Training

The course support files consist of a single .ZIP file. You will need to download VBA Intermediate Training exercise Files.zip file to your PC or Mac (the file are not compatible with a mobile device) and unzip the file. Once unzipped, all of the exercise/example files will reside in one folder.