VBA Intermediate Training

Loading the player ...

VBA Intermediate Training

DURATION: 4h 33m
VIDEOS: 37
LEVEL: Advanced

READY TO GET STARTED WITH SIMON SEZ IT?

Get immediate access to the entire library!

Description
Course Resources

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.

WHAT YOU GET

Certificate of Completion

Earn a certificate each time you complete a course.
Showcase your commitment to continuous growth and professional development.
Impress potential employers.
Enhance your professional profile.
Available in PDF format to Download or Print.

INSTRUCTOR

Philip Trick

Meet Philip Trick, a seasoned consulting actuary with over a decade of experience who has turned Excel and VBA into his tools of mastery. Philip's journey into the world of data and analytics began with his economics studies in school. Little did he know that this foundation would pave the way for a remarkable career. Starting as an actuarial student consultant, Philip swiftly realized that Excel held the keys to success in his field. To excel in his role, he delved deep into the inner workings of Excel, mastering its every function and formula. But Philip didn't stop there. He discovered the transformative power of VBA, a tool that allowed him to streamline processes and make complex tasks remarkably simple. Philip's expertise goes beyond the confines of his own work. He's a trusted authority who occasionally collaborates with Microsoft's Dev Team, sharing insights on enhancing Excel for users worldwide. With a wealth of experience integrating business information with management analytics, Philip is the go-to expert for turning data into actionable insights. Whether you're a novice looking to unlock Excel's potential or a seasoned professional seeking to optimize your workflows with VBA, Philip Trick is your guide to mastering the art of data-driven decision-making. Join him on a journey where Excel and VBA become your allies in achieving excellence in the world of actuarial science and beyond.

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.

What Our customers say

With over 1,000,000 learners we have achieved an average rating of 4.5 out of 5 stars.

4.5 /5

See more reviews

This has already helped me set up my project better and gives me the confidence that I’ll be able to keep tracking the project using the software.

Ann Lauzau

Enrolling in Simon Sez IT’s Microsoft Project for beginner course really helped me become proficient with Microsoft Project and project management. I now think more critically with my projects.

Patrick Loyola

I actually came to your courses because I want to master the IT aspects of project management. The course was very detailed. I will be recommending this course to other aspiring PMPs.

Frank Uchegbu

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

Charlenee Huynh

I have always used Excel at work, but because I learned to use it on my own, I had never been able to make use of all the possibilities that the software offers. I have learned a lot thanks to...

Blanca Esteban

Simon Sez IT has trained me how to use Microsoft Project to create and manage my own projects in just 2 days. Exactly the training I was looking for! Its been an amazing experience would recommend to anyone who wishes...

Haroon Riaz

I enrolled in Simon Sez IT to use the Microsoft Excel for beginners course. I enjoyed every bit of the course and easy to understand and the pattern of teaching was top-notch. I will recommend this course to others including...

Umar Abdulqadir

VIDEO LED, HIGH DEFINITION TRAINING

EXCERCISE FILES INCLUDED

1,000,000+ STUDENTS AROUND THE WORLD

UNCONDITIONAL, 30 DAY MONEY BACK GUARANTEE

VIEWABLE ON PC AND MAC DEVICES

ACCESS THIS COURSE AND OVER 170 OTHERS

Choose Plan

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