- Courses
- Microsoft Excel
- Excel VBA Introduction
Microsoft Excel VBA Introduction Training Courses
Excel VBA Introduction
This 2-day hands-on Excel VBA course helps you take control of your spreadsheets by using automation and custom forms. Gain the practical skills to streamline repetitive tasks, boost productivity, and confidently create dynamic applications—all backed by the guidance of experienced instructors.
- 2 days
- Virtual or on-site
- Private team training
Trusted by teams at
Course overview
Get ready to take your Excel applications to the next level by harnessing the power of the VBA language.
This Future Savvy instructor-led Excel VBA course helps you gain more control over your spreadsheets by using VBA. You'll discover how to develop more dynamic Excel applications and automate tasks to save time and reduce errors. Our trainers guide you through both introductory concepts and advanced topics, ensuring practical learning for each delegate.
You’ll learn how to work with key VBA objects and techniques that grant better access to workbooks, worksheets, and custom automation solutions in Excel.
This hands-on course helps you create automated spreadsheets and tackle repetitive tasks so you can focus on what really matters. You'll be able to record and run macros, develop custom forms, and reliably manage code—building confidence in your Excel skills.
All with our 100% Money-Back Guarantee and Unlimited Email Support.
Who it's for
- Data analysts and report builders using Excel
- Finance and operations professionals automating spreadsheets
- Power users progressing from Excel Advanced to VBA
What you need before you start
- Proficient Excel knowledge
- Comfort with formulas and data manipulation
What you'll learn
What you will be able to do by the end of the course.
- Record and edit macros for task automation in Excel
- Write basic VBA procedures using variables and control structures
- Reference workbooks, worksheets, and ranges using the object model
- Create and validate user forms with controls and events
- Debug and troubleshoot VBA code with integrated tools
- Implement structured error handling to manage runtime issues
Course outline
8 modules across 2 days.
1Getting Started9 topics+
- Introducing Visual Basic for Applications
- Displaying the Developer Tab
- Recording a Macro
- Saving a Macro-Enabled Workbook
- Running a Macro
- Editing a Macro in the Visual Basic Editor
- Understanding the Development Environment
- Using Visual Basic Help
- Understanding Macro Security
2Working with Procedures and Functions9 topics+
- Understanding Modules
- Creating a Standard Module
- Understanding Procedures
- Creating a Sub Procedure
- Calling Procedures
- Using the Immediate Window to Call Procedures
- Creating a Function Procedure
- Naming Procedures
- Working with the Code Editor
3Understanding Objects8 topics+
- Understanding Objects
- Navigating the Excel Object Hierarchy
- Understanding Collections
- Using the Object Browser
- Working with Properties
- Using the With Statement
- Working with Methods
- Creating an Event Procedure
4Using Expressions, Variables, and Intrinsic Functions9 topics+
- Understanding Expressions and Statements
- Declaring Variables
- Understanding Data Types
- Working with Variable Scope
- Using Intrinsic Functions
- Using Intrinsic Constants
- Using Message Boxes
- Using Input Boxes
- Declaring and Using Object Variables
5Controlling Program Execution7 topics+
- Understanding Control-of-Flow Structures
- Using the If...End If Decision Structures
- Using the Select Case...End Select Structure
- Using the Do...Loop Structure
- Using the For...To...Next Structure
- Using the For Each...Next Structure
- Guidelines for use of Control-of-Flow Structures
6Working with Forms and Controls10 topics+
- Understanding UserForms
- Using the Toolbox
- Working with UserForm Properties, Events,and Methods
- Understanding Controls
- Setting Control Properties in the Properties Window
- Working with Control Appearance
- Setting the Tab Order
- Populating a Control
- Adding Code to Controls
- Launching a Form in Code
7Debugging the Code6 topics+
- Understanding Errors
- Using Debugging Tools
- Setting Breakpoints
- Stepping through Code
- Using Break Mode during Run mode
- Determining the Value of Expressions
8Handling Errors6 topics+
- Understanding Error Handling
- Understanding VBA's Error Trapping Options
- Trapping Errors with the On Error Statement
- Understanding the Err Object
- Writing an Error-Handling Routine
- Working with Inline Error Handling
Get a quote
Run Excel VBA Introduction 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
Who is this Excel VBA Introduction course suitable for?+
This course is designed for proficient Excel users such as analysts, finance and operations professionals, and power users looking to take the next step into automation and customising spreadsheets using VBA.
Do I need prior programming experience to attend?+
No prior programming experience is necessary. This course introduces VBA concepts from the ground up. All you need is confidence with formulas, data manipulation, and intermediate or advanced Excel features.
What will I be able to automate after completing this course?+
You'll be able to automate repetitive Excel tasks, create and edit macros, build simple user forms, and manage your code so you can work faster, with fewer errors and greater reliability.
Is this course hands-on or lecture-based?+
The Excel VBA Introduction course is very much hands-on. Expect plenty of practical exercises, guided demonstrations, and opportunities to apply skills in real scenarios with support from our experienced instructors.
What support is available after the course?+
Delegates receive unlimited email support following the course, as well as access to comprehensive course materials. And of course, our 100% money-back guarantee is there for complete confidence.
Does this course cover error handling and debugging in VBA?+
Yes, we include modules on structured error handling, debugging practice using Excel’s built-in tools, and guidance on troubleshooting VBA code effectively.
Can I bring my own Excel files to practise during the course?+
Absolutely. You are encouraged to bring along challenging spreadsheets or typical tasks for practice, so you can immediately relate what you learn to your everyday work.
What version of Excel is used for training?+
The course is delivered using the latest supported version of Microsoft Excel for Windows. If you have any specific requirements around versions, please let us know before you attend.
Training where your team works
Microsoft Excel training by location
See local delivery details, nearby course options and practical information for your area.
