- Courses
- Microsoft Excel
- Excel VBA Intermediate
Microsoft Excel VBA Intermediate Training Courses
Excel VBA Intermediate
Move beyond recorded macros. This two-day course teaches you to write reliable, reusable VBA that loops through data, works across workbooks and files, and handles real-world spreadsheets that change shape.
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
Excel VBA Introduction gets you writing procedures and user forms. This course is the next step: writing code that keeps working when the data grows, the sheet names change or a file is missing.
You learn to work efficiently with ranges, arrays and collections, loop through workbooks and folders, and build procedures you can reuse across projects. Each topic is tied to a practical automation, such as consolidating monthly files, cleaning imported data or producing a formatted report.
By the end of the two days you will be able to plan, write and debug VBA projects that save real time, and structure your code so colleagues can understand and maintain it.
Who it's for
- Analysts and report builders automating recurring Excel work
- Finance and operations staff who maintain macro-enabled workbooks
- Excel VBA users ready to write more robust code
What you need before you start
- Completion of Excel VBA Introduction, or equivalent experience writing simple procedures
What you'll learn
What you will be able to do by the end of the course.
- Work efficiently with ranges, the Range and Cells objects and dynamic data
- Use arrays and collections to process data quickly
- Loop through worksheets, workbooks and files in a folder
- Write reusable functions and pass arguments between procedures
- Build robust error handling and input validation
- Automate formatting, sorting, filtering and report output
- Structure and document code so it is easy to maintain
Course outline
7 modules across 2 days.
1Working with Ranges Effectively4 topics+
- Range, Cells and Offset compared
- Find the last row and column reliably
- Use CurrentRegion and UsedRange
- Work with named ranges and tables
2Loops and Decisions in Practice4 topics+
- For Each loops over cells, sheets and workbooks
- Do loops with exit conditions
- Select Case for clearer decisions
- Avoid slow cell-by-cell code
3Arrays and Collections3 topics+
- Read a range into an array and write it back
- Dynamic arrays and ReDim
- Use collections and dictionaries to group and de-duplicate
4Workbooks and Files4 topics+
- Open, save and close workbooks in code
- Loop through files in a folder
- Consolidate data from many files into one
- Use FileDialog to let users pick files
5Reusable Procedures and Functions4 topics+
- Pass arguments by value and by reference
- Write user-defined worksheet functions
- Organise code into modules
- Build a personal macro library
6Automating Reports4 topics+
- Sort, filter and format data in code
- Create and format charts with VBA
- Export sheets to PDF
- Speed up code with ScreenUpdating and Calculation settings
7Robust and Maintainable Code4 topics+
- Structured error handling patterns
- Validate inputs before processing
- Debug with breakpoints, Watch and the Locals window
- Comment and name code for others
Get a quote
Run Excel VBA Intermediate 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
Do I need to have attended Excel VBA Introduction?+
It is recommended. You should be comfortable writing simple Sub procedures, using variables and editing code in the Visual Basic Editor.
What kind of tasks will I be able to automate?+
Typical examples include combining many monthly files into one, cleaning imported data, and producing formatted reports or PDFs at the click of a button.
Can I bring my own workbooks?+
Yes. Bringing a real problem is encouraged, and private courses can be built around your own files.
How is the course delivered?+
Live with an instructor over two days, in a virtual classroom or at your offices.
What comes after this course?+
Excel VBA Advanced covers class modules, events, working with other Office applications and building complete tools for other users.
Training where your team works
Microsoft Excel training by location
See local delivery details, nearby course options and practical information for your area.
