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.

100% Money Back Guarantee

Free Assessment

Post Course Support

On-Site prices starting from £99 pp - Great for Large Teams

£396 pp for group of 5 - Great for Small Teams (40% off)

Buy 1, 2nd colleague comes half price

Master the programming language VBA to go beyond advanced Excel use by recording and running Macros, creating Modules, and writing Procedures.

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.

Course Type

Access / Duration

Price (Excl Tax)

Virtual

1 Day

£248.00

Classroom

1 Day

£248.00

Master the programming language VBA to go beyond advanced Excel use by writing Macros, using control structures, developing user forms, and debugging code errors.

Master Visual Basic for Applications (VBA) fundamentals: including displaying the Developer tab, recording and editing macros, understanding the development environment, and managing macro security.
Learn to work with procedures, functions, and objects: creating modules, procedures, and functions, navigating the Excel object hierarchy, working with expressions, variables, intrinsic functions, and controlling program execution.
Develop proficiency in form and control management: understanding UserForms, working with controls, setting properties, populating controls, adding code, and working with PivotTable objects.

Course Type

Access / Duration

Price (Excl Tax)

Virtual

3 Days

£658.00

Classroom

3 Days

£658.00

Don’t know which level you need?

Enquire Now for a free Microsoft VBA Assessment

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.

Study Microsoft VBA courses with Infero Training

Our Microsoft VBA Training Courses are designed for advanced users to build custom solutions and automate tasks.
The skills learned in each course are applicable across all Microsoft Hosting Applications: Access, Excel, Outlook, PowerPoint, and Word.
Each 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.

VBA Certification

Upon successful completion of a Visual Basic for Application (VBA) courses, you can receive CPD Certificate and points.

Microsoft does not have a Visual Basic for Application (VBA) Certification, however, if you wish to pursue a Microsoft Certification you can take an exam to earn a Microsoft Office Specialist (MOS) certification and become MOS Associate and/or MOS Expert in Microsoft Excel.

The certification is a proof of your expertise and proficiency to work with Microsoft Excel.

Benefits of learning Microsoft VBA with us

Professional Certified Trainers
CPD Accredited training in Small Groups for Max Focus
Only Microsoft Approved Courseware and Exercise Files are used
Free Assessment of Skills prior to booking
Certificate of Completion & Complementary 12 Months Post Course Support
100% Money Back Guarantee & Price Match Guarantee
High Feedback Rate
Choice of 15 training locations, Virtually or Onsite
Bespoke Courses & Group Discounts from £99 per person

Testimonials

I completed the Advanced Excel course and found it so good that I returned to complete the VBA course. By chance both courses happened to be on a 1-1 basis and my tutor Huseyn tailored the course to my needs. The course was very hands on as most of the course involved using the info learned in class and applying it to data supplied by Infero. The workbooks provided were clearly illustrated and had a step by step guide to complete each process.

Gerard Cahill Commercial Accountant from Capital One

I found the course very informative in a good atmosphere; Samer was very helpful and is a credit to your company. While I had some knowledge of VBA the course really opened the doors for me. I have already put what I learned into good use, automating processes that in the first instance saved us thousands of pounds as we no longer needed to hire an additional member of staff in that department thanks to the time saved.

Graham Wright Management Accountant from Mosaic Fulfilment Solutions

The Microsoft Excel Programming with VBA course was great. The teacher (Samer) was patient and professional, and explained all the contents in a clear and understandable way. I noticed the effects of the course on my day to day tasks immediately, so am very happy with it.

Sheila Bano-Hernandez Evidence Analyst from Valpak Ltd

The course was extremely informative and allowed me to gain an understanding of the functions, purpose and impact VBA can have to streamlining programs and processes. The enthusiasm and genuine interest shown by the instructor contributed greatly to the engagement and overall success of the course - I would highly recommend this and any other Microsoft based courses via Infero to anyone at whichever stage of development you may be!

Rob Carmichael Senior Market Research Manager from Vision Express

The VBA course I attended with Infero Training was very informative. It provided me with a very useful skillset that I am now using in my current role for many different things. I also now have a much better understanding of current systems that are using VBA. The enthusiasm of the instructor was great and definitely contributed to the overall experience of learning VBA. I would recommend this to anyone of any level of expertise as it highlights how VBA can help in many different ways throughout many different tasks.

Jason Programme Assistant from Nottingham CityCare Partnership

Thanks to everyone at Infero Training for making my VBA course not only an informative experience, but an interesting one too, for what could have easily turned into a "Chalk and Talk" course. Samer's (the trainer) knowledge and enthusiasm for the content of the course shone through throughout the whole three days, taking what was a complete VBA novice to someone who not only understands how VBA works, but now has the ability to really impact not only my own work, but that of several different functions of the business.

Neville Mellors Project Consultant from PMP Recruitment

Our Clients

700+ clients choose to train with Infero

Chartered Institution of Railway Operators

Top Microsoft VBA FAQs

What is the schedule for the training course?

Start: 9:00am
Break: 11:00am
Lunch: 1:00pm
Break: 3:00pm
Finish: 5:00pm

The schedule for 1, 2 and 3 days training will be the same but course content will vary. Times can be changed for group and onsite to start earlier, you can ask before booking.

Can we have a course in our own workplace?

If you are interested in having a training course at your own workplace, whether it be through one-to-one sessions or group training, we offer Onsite Bespoke courses.

How is the course structured?

The course is structured to blend instructor-led tuition with hands-on exercises, reinforcing learning through practical activities. This interactive approach ensures you learn both theory and application effectively. Each module begins with a theoretical foundation followed by immediate practice to solidify your understanding. Our instructor guides you through the material, addresses any questions you have, and supervises your practical work throughout the course.

Do I need any equipment for training?

For Classroom training courses you usually don’t need any equipment, unless we specifically advise otherwise. For Live Virtual training courses you will need a computer, or laptop with full version of the software you are training in. We also strongly recommend having access to a second screen for the training course such as a tablet or phone. This will allow you to do the exercises on your primary device and see the virtual whiteboard on a secondary device.

How do I know which level is right for me?

If you are unsure about which training course level suits you best, we recommend you give us a call and one of our telephone experts or trainers will be able to advise you.

How experienced are your tutors?

Our company prides itself on the quality of our training courses, which is not possible without our exceptional trainers! Our tutors have both practical and teaching experience, and specialist knowledge. We are happy to provide references and their profiles upon request.

Is there ongoing support after completing the course?

Absolutely! Following the training course, we provide a variety of post-course support documents so you can revisit the content at your own pace, along with offering 12 months of support via email.

Will I receive a certificate upon completion?

Yes, all of our training courses come with a certificate of completion. Once you finish the course, we will email your certificate to you within 2-3 working days.