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.

Get immediate access to the entire library!

Annual Membership

$ 197 _{/per year}

This is an annual membership to SimonSezIT.com with access to all online training courses. You will be charged again when your membership expires. You can cancel at any time.

Monthly Membership

$ 25 _{/per month}

This is a monthly membership to SimonSezIT.com with access to all online training courses. You will be charged each month. You can cancel at any time.

Related courses

What people are saying

""I enjoyed the logical structure of course. It helps beginners to follow easily."

CHARLENEE HUYNH

"I would definitely recommend this course. I have learned excel before, and I sincerely learned more this time around. I'm now confident when I say “I know excel”. Of course, I'm no professional, but I know much more. "

JESSICA MARTINEZ

"It's clear, the voice over is understandable, I can speed up or slow down at will, the course materials were offered immediately, including how to acquire the program."

CHRISTOPHER BORON

"I thought this course was really well laid out and very in-depth. I have never used Microsoft Project before and I feel I have learned so much by doing this course. Also, it gave me a flavor for other more advanced operations as well."

THEVUTHASAN SENTHURAN