This advanced course equips delegates with the expertise to develop sophisticated, customised solutions within Excel using Visual Basic for Applications (VBA), enabling the automation of complex workflows, enhancement of user interaction, and integration with external data sources. By mastering advanced programming concepts, delegates will be able to create dynamic interfaces, optimise data handling, and extend Excel’s functionality to meet specific business needs, significantly improving efficiency and accuracy in data analysis and reporting. The course is essential for professionals seeking to elevate their Excel skills beyond basic automation, empowering them to build robust, scalable applications that drive productivity and innovation in data-driven environments.
Take your Excel skills to the next level with Advanced VBA and start building fully customised, professional-grade solutions. This course goes beyond basic automation, teaching you how to create dynamic user interfaces, respond to real-time events, and develop powerful tools using object-oriented programming. You’ll learn to design intelligent forms, customise the Excel ribbon, integrate data from multiple sources, and automate complex reporting with charts and pivot tables. By the end, you won’t just be using Excel, you’ll be engineering scalable, high-performance applications that can streamline workflows, enhance user experience, and support advanced business operations. contact us at lets-talk at e q v dot co dot uk
Counts towards 12 CPD Hours 2 Days Open Public & Closed Group
Please reflect on one or more of the questions below and come prepared to discuss your responses during the session.
Self-Assessment: On a scale of 1–10, how would you rate your current skill level in this subject? What factors influenced your rating?
Development Focus: Identify one specific behaviour, skill, or capability you would like to improve or develop further.
Relevant Examples: If possible, bring one or two relevant examples or scenarios from your experience that you would be willing to share with the group.
What You Will Learn
User Forms: User forms allow you to create custom interfaces for data entry and interaction within Excel. They are valuable for building user-friendly applications.
Workbook and Worksheet Events: Events in Excel trigger actions based on user interactions or changes in the workbook or worksheet. These events can automate tasks and improve user experience.
Dynamic List Items: Dynamically populating lists in user forms or worksheets enhances data validation and user input options.
Form Templates: Form templates allow you to create flexible and adaptable user forms that can change their content or appearance at runtime based on user input or conditions.
Ribbon Tabs and Toolbars: Customising the Excel ribbon with assigned macros and creating toolbars can provide quick access to frequently used functions and enhance productivity.
Menus and Add-Ins: Menus and add-ins help organise and extend Excel’s functionality by providing custom commands and features.
Class Modules: Class modules allow you to create custom objects with properties and methods, providing an object-oriented approach to VBA programming.
Data from External Files: Accessing and manipulating data from other Excel files expands data analysis and reporting capabilities.
Object Hierarchies: Understanding object hierarchies enables you to interact with other Microsoft Office applications, automating tasks and data exchange.
Data Storage in Windows Registry: Storing data in the Windows registry allows for configuration settings and data persistence between Excel sessions.
Charts in VBA: Creating charts programmatically in VBA provides control over chart design and data visualisation.
Pivot Tables: Creating and manipulating Pivot tables programmatically helps automate data analysis and reporting tasks.
Your Post-Course Challenge
Complete the further practice workbook
Apply the techniques to your own data
Counts Towards 12 CPD Hours
This course contributes 12 hours of Continuing Professional Development. Delegates can log these hours as evidence of structured learning for professional bodies and employers.
This course is designed for individuals who already have a foundational understanding of Visual Basic for Applications (VBA) and are looking to expand their skills to build advanced Excel applications. It is ideal for those aiming to automate complex workflows, create custom user interfaces, and enhance productivity through powerful VBA techniques.
This course is ideal for:
Excel power users seeking to automate repetitive tasks and create custom solutions for data management
Business analysts who want to build dynamic reporting tools and interactive dashboards
IT professionals responsible for developing Excel-based applications or add-ins for organisational use
Finance professionals looking to streamline data processing and reporting with custom VBA tools
Project managers needing to create custom forms and interfaces for team collaboration and data entry
Trainers and consultants who wish to deliver advanced VBA training or develop reusable Excel solutions
Prior experience recommended
This course assumes a basic understanding of VBA concepts and Excel functionality. Delegates should have completed an introductory VBA course or have equivalent hands-on experience to fully benefit from the advanced topics covered.
What you will take away
Delegates will leave with the confidence and practical skills to create sophisticated Excel applications, automate complex processes, and develop custom solutions tailored to their organisation’s needs. They will be equipped to build user-friendly interfaces, manipulate data from external sources, and extend Excel’s functionality through add-ins and custom toolbars.
For Groups & Teams
We can deliver this training session in several ways to suit your organisation’s needs:
Open Public Course
Join delegates from other organisations on a scheduled date
Closed Group
Exclusively for your team, using your real scenarios
In Person
Face-to-face at your premises or a venue of your choice
Virtual
Live, interactive online delivery via Teams or Zoom
One-to-One Coaching
Personalised sessions tailored entirely to you
Have two or more people to train?
You may want to consider a closed group course. Benefits include:
Cost effective for teams
Choose a date to suit you
Customise content and timings
No minimum delegate numbers
Uses your real-world scenarios
Builds shared language in your team
Contact us on [email protected] to discuss specific dates and delivery requirements.
How Our Tutor-Led Courses Are Delivered
Before the day
Delegates are given pre-work to complete before attending. This ensures everyone arrives with relevant context and real scenarios from their own experience, so learning is immediately relevant and actionable from the first minute.
On the day
Our sessions are participative and highly interactive. We don’t do “death by PowerPoint” — instead, the day includes a variety of engaging activities throughout:
Real-world casework using your scenarios
Practical hands-on exercises
Real Play (not role play) simulations
Peer learning and group discussion
Case studies and scenario work
Facilitated discussion and structured reflection
What you leave with
Participants leave with:
Practical tools — frameworks and models you can use straight away
Clear action plans — specific next steps tailored to your role
Greater confidence — built through intensive, realistic practice
Skills you can apply immediately — not theory, but techniques tested during the day
After the day
Post-session measurements and a 30-day challenge ensure that learning is embedded and behaviour change is sustained.
Key Features
Course Duration is 2 Days
Engaging tutor led event
Comprehensive course materials
Certificates of attendance
Access to Customer Portal (course bookers)
Course Guarantee
Priced per delegate for open public course
£695.00 Plus VAT
Can’t see a suitable date? Please request a date here
Payment available via all major credit cards or Invoice. All options available during the online booking process.
