VBA Intermediate
course

VBA Intermediate

This course is designed for advanced Excel users who already use VBA to automate frequently performed tasks in Excel and would like to learn more advanced features and options for utilising VBA.

Simon Sez IT
Updated Jul 11, 2025

What you'll learn

  • Identify and interpret different Excel file types for efficient data handling.
  • Apply advanced parameter definitions for precise and flexible VBA coding.
  • Develop custom objects using the new keyword and define practical class examples.
  • Tailor the Excel interface through UI modifications for enhanced user experience.
  • Understand and apply external references, including Office Libraries and the ADODB Library.
  • Apply pre-defined events and parameters for responsive and interactive Excel applications.
  • Design and code userforms, enhancing your ability to create user-friendly interfaces.
Course Description

Power through more advanced features for getting the most from Visual Basic for Applications (VBA) with this intermediate, learner-friendly course. you'll build on your VBA skill set with techniques to supercharge Excel and make it do what you need it to do. You will dive into more advanced procedures and macros for automating complex and time-consuming Excel tasks. Begin your journey with a detailed but easy-to-grasp discussion of more advanced VBA language, before going on to event patterns, custom objects, references, libraries and more.

By the end of this learning journey, you'll have a lot more power to fully customize VBA to do some pretty miraculous things, including making VBA work seamlessly through those massive Excel tasks. This course provides intermediate-level training you need for advanced abilities with VBA.