Microsoft Excel VBA Advanced Course
The Microsoft Excel VBA Advanced course moves beyond straightforward macros and procedures to explore techniques for creating more sophisticated and maintainable Excel solutions.
Participants will develop their ability to structure VBA code, control how procedures behave and create solutions capable of responding to different situations and user actions. Advanced techniques can be used to automate complex processes, reduce repetitive work and create Excel applications that are easier for other people to use.
The course is particularly relevant to experienced Excel users who already create and edit VBA code and now need to tackle more demanding automation projects. Practical exercises allow participants to apply advanced programming techniques within Excel rather than simply learning VBA concepts in isolation.
Participants who are not yet comfortable writing and modifying VBA procedures should consider attending Microsoft Excel VBA Introduction and Microsoft Excel VBA Intermediate before progressing to this course.
Not sure which Excel course is right for you?
Take our free Excel Skills Assessment and receive an instant recommendation based on your current Excel knowledge and experience.
Need a quick explanation of an Excel term? Browse our free Excel Glossary.
Course Schedule
.svg){kind=small}
Course Code: EXCEL7
Duration: 1 day
Course Aims
The Microsoft Excel VBA Advanced course is designed to take your VBA expertise to the highest level. You will master advanced techniques, tools, and best practices to become a proficient VBA developer. This course will empower you to tackle the most intricate Excel automation challenges.
Our Microsoft Excel course is delivered using the latest version available through Microsoft 365. This ensures that our demonstrations include the most up-to-date features and functions. While many of the concepts and techniques covered are applicable to earlier versions of Excel, there may be some differences in the user interface and available features. If you are using an older version of Excel, our trainers are happy to provide guidance on how to access similar functionalities within your version.
Learning Objectives
In this course, you will:
- Dive deep into VBA's most advanced components and their applications.
- Develop complex, multi-step VBA solutions to automate even the most challenging Excel tasks.
- Create custom VBA functions and user interfaces for professional-grade Excel applications.
- Utilise advanced programming concepts, including advanced error handling, user-defined classes, and advanced optimization techniques.
Target Audience
This course is suitable for experienced VBA users who have completed the Excel VBA Intermediate course or have equivalent VBA knowledge. It is ideal for professionals seeking to become VBA experts and tackle the most demanding Excel automation projects.
Course Content
1. Review of Intermediate topics
2. Advanced form design
3. User-defined classes and objects
4. Use of nested loops
5. Use of ADO to read and manipulate data in an Access database
More Excel training: Explore the complete Excel training pathway, including core, data analysis and VBA courses.
Public Schedule
Private Virtual Training (Teams / Zoom)
£1,295 + VAT per day for up to 8 delegates (≈ £162 per person)
Private Onsite Training (at your offices)
Same day rate as Private Virtual, plus trainer travel expenses (confirmed in your quote)
Note
All prices exclude VAT at 20%.
VAT registration number: 450 4347 14
You may also like...
Learn to use Microsoft Planner to create plans, organise and assign tasks, track progress and collaborate effectively with colleagues.
.svg){kind=small}
Half day
Learn Excel Power Query to import, clean, transform, merge and reshape data, then load repeatable queries for reporting and analysis.
Half day
Master advanced Excel functions, XLOOKUP, dynamic arrays, What-If Analysis, PivotTables and Power Pivot for more powerful reporting and data modelling.
1 day
.png){kind=small}
