Microsoft VBA Training Courses
MICROSOFT VBA TRAINING COURSES are fully CPD Accredited and designed for beginners who want to learn Automation secrets in Excel or Access VBA. It will help you to create macros to automatically generate customised charts, reports and other data processing functions.
- Only Microsoft Approved Courseware and Exercise Files
- Choice of 15 training locations, Virtual or Onsite
- Complimentary 12 Months Post-Course Support
- 100% Money-Back Guarantee & Price Match Guarantee
Microsoft Excel VBA Introduction Course
Master the programming language VBA to go beyond advanced Excel use by recording and running Macros, creating Modules, and writing Procedures.
- Starting with Visual Basic for Applications
- Macro Running in Excel
- Macro Editing & Security
- Procedures, Functions & Code Editors
- Objects, Collections & Methods
Microsoft Excel VBA Advanced Course
Take your VBA programming further by mastering control structures, developing user forms, debugging code, handling errors, and automating advanced tasks.
- Expression, Variable & Intrinsic Functions
- Program’s Execution Control
- Forms & Controls
- PivotTable Objects
- Code Debugging & Errors Handling
Over 700 clients choose to train with Infero
What’s Included
Choose the Right Course
Who is the Excel VBA Introduction training course for and what does it cover?
This one-day Excel VBA Programming Introduction course introduces experienced Excel users to writing and editing Macros. No prior programming experience is required.
In this Excel VBA course you will:
- Acquire foundational skills in Visual Basic for Applications (VBA): including displaying the Developer tab, recording and running macros, understanding the development environment, and managing macro security.
- Master procedures, functions, and objects: by understanding modules, creating procedures, navigating the Excel object hierarchy, working with collections, properties, methods, and event procedures.
- Develop proficiency in VBA programming: through naming procedures, calling procedures, using the Immediate window, and working with the code editor effectively.
Who is the Excel VBA Advanced training course for?
This 2 day Excel VBA Programming Advanced course introduces advanced Excel users to the process of working with control structures, developing user forms to accept or display data, validating data entry in user forms, debugging and handling errors in code, and automating advanced tasks.
The Visual Basic training requires prior knowledge of Excel and basics of VBA programming. While familiarity with PivotTables may be helpful, it is not essential.
In this Excel VBA course you will:
- Advance your coding skills with VBA logic and data handling: declare and manage variables, apply data types, work with intrinsic functions and constants, and control program execution using decision-making and looping structures.
- Design and manage interactive UserForms: build custom forms, configure controls and properties, write event-driven code, and enhance interactivity with buttons, combo boxes, and option groups.
- Enhance automation with advanced VBA tools: programmatically control PivotTables, use debugging features to identify and fix issues, and implement robust error handling techniques for reliable, professional code.
Don’t know which level you need?
Enquire Now for a free Microsoft VBA Assessment
Choose the Right Course Format
We offer our Microsoft VBA training courses in both remote (online) and in-person formats to suit your needs.
Classroom
Experience the benefits of face-to-face Microsoft VBA training in our classroom sessions, where you can engage directly with expert instructors and like-minded peers. Enjoy a focused, distraction-free environment at our training centres that encourages hands-on practice, and offers instant feedback, helping you deepen your understanding and develop your skills effectively.
Onsite
Bring expert training to your team with our onsite option, offering unmatched convenience and considerable cost savings. Maximise productivity with tailored content delivered at your location, minimising travel expenses and time away from work, while ensuring focused and impactful learning for your team.
Virtual
Our virtual VBA courses deliver the same comprehensive content as our in-person sessions, ensuring a consistent, high-quality learning experience. Delivered live via the secure Webex platform, these courses offer interactive participation, real-time feedback, and direct access to expert trainers—just like a physical classroom. Plus, we keep our virtual class sizes small to guarantee personalised attention.
No matter which format you choose, we are committed to delivering you with the best VBA training possible, tailored to help you and your team master VBA efficiently and effectively.
Bespoke Tailored Training for Individuals or Corporates
Whether you’re an individual looking to boost your VBA skills or a company aiming to upskill your team, we offer tailored VBA training solutions designed to drive success at every level.
You can choose to learn virtually, at our training facility or onsite at your office, with sessions available as one-to-one or group training.
For in-person training, our expert trainers can travel to your location, offering a more convenient, cost-efficient on-site learning experience – a popular choice for corporate clients. Our on-site courses are not only competitively priced, but they also help organisations save money by reducing travel, overtime and accommodation costs.
To ensure your VBA course aligns perfectly with your learning objectives, we offer a free course tailoring consultation. During this consultation, we assess your current skill level, identify your goals, and outline the key topics that will benefit you most. We then adapt the VBA course content accordingly to ensure a truly effective training experience.
By tailoring our VBA courses to your specific needs, we help individuals and teams gain the skills and confidence to harness VBA’s full potential in everyday work.
Testimonials
Gerard Cahill Commercial Accountant from Capital One
Graham Wright Management Accountant from Mosaic Fulfilment Solutions
Sheila Bano-Hernandez Evidence Analyst from Valpak Ltd
Rob Carmichael Senior Market Research Manager from Vision Express
Jason Programme Assistant from Nottingham CityCare Partnership
Neville Mellors Project Consultant from PMP Recruitment
From Skills Assessment to Post Course Support
Success from the Start
Our approach begins with a free pre-course skills assessment to fully understand your current abilities and training needs, helping you choose the right VBA course.
This initial evaluation enables us to tailor the VBA course content specifically to address your skill gaps and learning objectives, setting you up for success from the very beginning.
As a Microsoft Partner and a registered provider with the UK Register of Learning Providers, we are committed to delivering high-quality, industry-recognised training you can trust.
Learning in Action
Our courseware is designed to reflect real-life work situations, making your learning experience practical, relevant, and immediately applicable.
Each VBA course covers key objectives aligned with the official Microsoft Certification exams, giving you the confidence to pursue recognised qualifications.
All of our first-class Training Specialists have a minimum of 10 years’ training experience, ensuring expert guidance throughout.
Our training methodology emphasises hands-on learning, combining trainer-led demonstrations with interactive exercises to reinforce skills and maximise retention.
With small class sizes, our trainers are able to provide personalised feedback, closely monitor your progress, and effectively support individual learning needs.
Finishing Touches
At the end of each course, you’ll receive digital course materials and exercises so you can review the content whenever you need to.
We invite all participants to complete a course feedback form, which we review to ensure the highest quality of training.
You can trust our proven track record:
- 1000s of happy clients
- 97% of learners recommend us
- 99% apply their new skills in the workplace
Our commitment doesn’t end when the course does — we offer 12 months of free post-course support, giving you access to our expert trainers to help apply your newly acquired skills in real-world situations.
With our 100% Money Back Guarantee you simply have nothing to lose.
What is Microsoft VBA?
Microsoft VBA (Visual Basic for Applications) is a programming language embedded in individual Microsoft applications like Access, Excel, PowerPoint and Word. It enables the creation of user-defined functions and automates various computer processes and calculations, similar to Visual Basic.
VBA allows users to create macros or small programs within applications, providing additional customisation beyond standard features. It is user-intuitive, making it accessible to individuals with little or no programming knowledge.
With VBA, users can manage customer lists, create invoices, develop charts, analyse data, and perform budgeting and forecasting tasks. It also controls various features within host applications, such as Excel, including manipulation of toolbars, menus, dialog boxes, and customised user forms.
Our Microsoft VBA Courses
Our Microsoft VBA Training Courses are designed for advanced users to build custom solutions and automate tasks. The skills learned in each Visual Basic course are applicable across all Microsoft Hosting Applications: Access, Excel, Outlook, PowerPoint, and Word.
Each Visual Basic course is delivered through a combination of trainer demonstrations, hands-on exercises, and interactive support. Our VBA courses cover all MS Office versions from 2007 to 2024, addressing all aspects and differences.
Whether you’re a beginner or an advanced Excel or Access user, we offer different VBA courses tailored to your requirements.
Whether you’re looking to streamline repetitive tasks, build custom functions, or develop user-friendly tools, taking the time to learn VBA can significantly boost your efficiency and open up new possibilities in data handling and reporting.
Microsoft VBA Certification
Upon successful completion of any of our Microsoft VBA training courses – whether Introduction or Advanced you will receive a Certificate of Completion.
You are also eligible to receive a CPD Certificate and points, demonstrating your commitment to professional development through our Visual Basic for Applications (VBA) courses.
Please note that Microsoft does not currently offer a specific Visual Basic for Applications (VBA) certification. However, if you’re interested in gaining an official Microsoft credential, you may pursue the Microsoft Office Specialist (MOS) certification. By passing the relevant exams, you can earn MOS Associate or MOS Expert.
Top Microsoft VBA FAQs
Can the Training be customised to our organisation’s requirements?
What are the Course Timings?
- Start: 09:00am
- Morning break: 11:00am
- Lunch: 01:00pm
- Afternoon break: 03:00pm
- Finish: 05:00pm
This schedule applies to all 1-day, 2-day, and 3-day courses, whether delivered virtually, in the classroom, or on-site. For on-site training or larger group bookings, start and finish times can be adjusted to suit your organisation’s needs. To discuss a customised schedule, call us on 0115 958 6699 or complete our Request a Quote form and a member of our team will be in touch.
Can Training be delivered at our workplace?
Yes — we can deliver training directly at your workplace. Whether you require one-to-one sessions, group training, or fully bespoke on-site courses, we tailor the content and delivery to meet your organisation’s specific needs.
To arrange workplace training, call us on 0115 958 6699 or complete our Request a Quote form, and a member of our team will be in touch to discuss your requirements.
How is the Course structured?
Do I need any equipment for training?
For classroom training you typically don’t need to bring any equipment, unless we specifically advise otherwise. All necessary resources will be provided at our training centre.
For virtual training you will need a computer or laptop with the full version of the software relevant to your course. We also strongly recommend using a second screen, such as a tablet or smartphone, so you can complete exercises on your main device while viewing the virtual whiteboard or trainer’s screen on the second.
How do I know which level is right for me?
If you are unsure which course level best matches your current skills, we're here to help. Simply give us a call on 0115 958 6699, and one of our expert trainers or course advisors will guide you in choosing the most suitable training level for your needs.
How experienced are your tutors?
We pride ourselves on delivering high-quality training—something made possible by our exceptional team of tutors. All our trainers have extensive practical experience, specialist knowledge, and a strong background in teaching and training. Their expertise ensures that every course is engaging, relevant, and effective.
We’re happy to provide tutor profiles and references upon request—just get in touch.
Is there ongoing support after completing the course?
Absolutely! After completing your training, you’ll receive a range of post-course support materials, allowing you to revisit the content at your own pace. In addition, we offer 12 months of support, so you can ask questions, seek clarification, or get guidance as you apply your new skills in real-world situations.
We're committed to helping you continue your learning journey long after the course ends.
Will I receive a certificate upon completion?
Training Venues
Nottingham Training Centre
Nottingham, NG1 6LG
Birmingham Training Centre
Birmingham, B5 4DY
Bristol Training Centre
Bristol, BS1 5EH
Leeds Training Centre
Leeds, LS1 1PJ
Leicester Training Centre
Leicester, LE1 1RE
Liverpool Training Centre
Exchange Flags
Liverpool, L2 3PF
London Training Centre
8 Duncannon Street
London, WC2N 4JF
Manchester Training Centre
Manchester, M1 3DT
Milton Keynes Training Centre
Oldbrook
Milton Keynes, MK6 2TG
Sheffield Training Centre
Sheffield, S1 2EA
Accreditations & Memberships
