This VBA and Excel course will unlock the power of coding in Excel. Learn how to create dynamic macros to automate repetitive tasks, streamline data processing, and enhance productivity.
Dive into the world of Visual Basic for Applications (VBA) and gain the skills to write custom code that extend Excel's functionality. Discover the art of coding with VBA as you build interactive applications, manipulate data, and control Excel objects.
This course will equip you with the knowledge and tools to harness the full potential of VBA in Excel.
If attending an online course you must have a licensed copy of any software required and access to a suitable computer.
You'll need to have attended our Excel Advanced course or have equivalent working knowledge before joining this class.
Course leader is an experienced industry expert
Displaying the Developer Tab
Recording and running a Macro
Macro-Enabled Workbooks
Using the Visual Basic Editor
The Development Environment
Understanding Macro Security
Understanding Modules
Understanding Procedures
Calling Procedures
Creating a Function Procedure
Working with the Code Editor
Objects and Collections
Working with Properties
Using the With Statement
Creating an Event Procedure
Understanding Expressions and Statements
Declaring Variables
Understanding Data Types
Using Intrinsic Functions
Understanding Constants
Declaring and using Object Variables
Control-of-Flow Structures
Working with Boolean Expressions
Different types of Control-of-Flow structures
Guidelines for use of Control-of-Flow Structures
Working with UserForm Properties, Events and Methods
Working with different Controls
SettingControl Appearance
Populating a Control
Adding Code to Controls
Launching a Form in Code
Understanding Error Handling
Writing an Error-Handling Routine
Working with Inline Error Handling
Professionals who wish to develop skills for their current role and companies who believe in developing their talent.
People seeking opportunities which require new skills. Industry relevant training for those pursuing a new role.
Certified courses for those who have earned their theoretical stripes, but need to prove capability to future employers.
Learn face-to-face with expert mentors in a dynamic setting that inspires growth and confidence.
Join remotely with expert mentors in real time — flexible, interactive learning that fits your lifestyle.
Upskill your team together. Build your team and develop consistency, and collective confidence.
Define your direction with purpose, aligning your learning journey to personal and career goals.
Gain practical insight from real-world experts who bring clarity, confidence, and momentum to your growth.
Your certificate of attendance is proof of progress — benchmarking your skills and commitment to growth.