- Courses
- Microsoft Excel
- Excel VBA Advanced
Microsoft Excel VBA Advanced Training Courses
Excel VBA Advanced
Build complete, professional Excel tools with VBA. This two-day advanced course covers class modules, events, advanced user forms and automating other Office applications, so you can deliver solutions other people rely on.
Not sure this is the right level? Compare all Microsoft Excel training courses.
- 2 days
- Virtual or on-site
- Private team training
Trusted by teams at
Course overview
This course is for VBA developers who already write working code and now build tools for other people to use. The focus is on design: making tools that are reliable, easy to use and easy to support.
You work with class modules and events to make workbooks respond intelligently, build user forms with validation and dynamic controls, and automate Outlook and Word from Excel to send emails and generate documents. You also learn to read external data and protect and distribute your finished tools.
The two days are built around a realistic project, so you see how the techniques fit together into one tool, from the first user form to a version ready to hand over.
Who it's for
- Experienced VBA developers building tools for colleagues
- Analysts who own business-critical macro-enabled workbooks
- Power users automating work across Excel, Outlook and Word
What you need before you start
- Completion of Excel VBA Intermediate, or solid experience writing VBA procedures, loops and error handling
What you'll learn
What you will be able to do by the end of the course.
- Use workbook, worksheet and application events to respond to users
- Create class modules and custom objects
- Build advanced user forms with validation and dynamic controls
- Automate Outlook and Word from Excel
- Read and write external data, including text, CSV and other workbooks
- Protect, version and distribute VBA tools and add-ins
- Plan and structure a complete VBA solution
Course outline
6 modules across 2 days.
1Events4 topics+
- Workbook and worksheet events
- Application-level events
- Control events safely with EnableEvents
- Common event-driven patterns
2Class Modules4 topics+
- Why use class modules
- Create properties and methods
- Build collections of custom objects
- Handle events with WithEvents
3Advanced User Forms4 topics+
- Dynamic lists and dependent controls
- Validate input as the user types
- Multi-page forms and wizards
- Pass data between forms and code
4Automating Other Office Applications4 topics+
- Early and late binding
- Create and send email with Outlook
- Generate Word documents from Excel data
- Tidy up application objects reliably
5External Data3 topics+
- Read and write text and CSV files
- Query other workbooks without opening them visibly
- Use Power Query refresh from VBA
6Delivering a Tool4 topics+
- Create an Excel add-in
- Custom ribbon buttons for your macros
- Protect code and worksheets
- Version, test and hand over a tool
Get a quote
Run Excel VBA Advanced for your team
Delivered for your organisation alone, on a date you choose, online or at your offices.
Or call 0333 305 8855
What happens next
- 1We reply with available dates and a price for your team
- 2You pick a date that suits your team — we work around you
- 3We tailor the examples and exercises to the work your team does
- 4We confirm the delivery details and next steps in writing
Booked with a 100% money-back guarantee
Every course we run is covered. Book with confidence — if it isn’t right, you aren’t left out of pocket.
Why Future Savvy
Practical training, backed properly
Rated 4.72/5
From 696 reviews by learners and clients.
Money-back guarantee
A 100% money-back guarantee, for peace of mind.
Up to six learners
Small enough that every delegate gets trainer time on their own work.
Trainers who do the job
Practitioners who use these tools on real work, not career instructors.
Support after the course
Email your trainer when you hit something back at your desk.
What delegates say
Independently verified reviews, alongside quotes collected from delegates after their course.
I had a good experience with this Microsoft Excel training course! Mark the trainer was exceptionally knowledgeable, patient, and engaging, taking the time to explain complex functions and formulas in a way that was easy to understand. The pace of the class was well-managed, and there was plenty of opportunity to ask questions without feeling rushed. I left the session feeling much more confident, efficient, and equipped with time-saving shortcuts. Highly recommended for anyone looking to upgrade their spreadsheet skills!
good value for money, I understood notions that were very not clear to me. Thanks to Mark.
Very good communication and an excellent tutor.
Very happy with Mark's training ethos and training he provided.
Excellent course and really well presented. Starting from basic knowledge the course guided you through step by step and was well paced for all.
Really enjoyed the course. Tutor was knowledgeable, friendly and gave real-world, practical advice to get the most out of the training.
The trainer really tailored the course to our needs, encouraged us to ask questions, and was knowledgeable and really helpful.
The trainer was very patient and did not mind having to explain things a few times to make sure we were all on the same page, was very helpful for someone like myself who sometimes misses details on the first go around
Excellent trainer, the format of the training was fantastic and I got a lot from the course.
This was, by far, one of the best training courses I have had the pleasure of attending. The trainer was extremely knowledgeable and delivered a great course!
This was the first time I have joined an excel course and I found it very informative and very helpful.
I liked how the trainer tailored the training around what our needs and roles are.
A great pace for somebody just starting and never an issue with questions, and always had a good way of answering.
From knowing nothing to what I know now and in less than a day I would highly recommend as it was extremely useful, and has made my understanding of MP a 100x better. Thank you the trainer for the great lesson!
Excellent course, definitely the best 'power' course I have attended. The trainer was enthusiastic about the material and kept it relevant to our needs
The trainer was really knowledgeable and extremely helpful in helping us to build our own reports.
It was very productive as a working session. I learnt a lot.
His careful delivery of the course really made the difference not only in its usefulness but in how well we, as learners, will retain and apply this new information.
Verified reviews are published on our Reviews.io profile, where anyone can read every one of them.
Frequently asked questions
What level should I be at before attending?+
You should be confident writing procedures with loops, arrays and error handling. Excel VBA Intermediate covers this foundation.
Does the course cover automating Outlook and Word?+
Yes. You build code that sends emails through Outlook and generates Word documents from Excel data.
Can we bring an existing tool to improve?+
Yes. For private courses we can use your existing workbook as the project, with sensitive data removed.
How is the course delivered?+
Live with an instructor over two days, in a virtual classroom or at your offices.
Should we also consider Power Automate or Office Scripts?+
They suit some automations well, particularly in the cloud. Our Power Automate courses cover flows, and your instructor can help you decide which tool fits each task.
Training where your team works
Microsoft Excel training by location
See local delivery details, nearby course options and practical information for your area.
