+44 (0) 2080 049141info@londonittraining.co.uk

LONDON IT TRAINING

Find your next course

Explore our training courses by subject, skill or certification.

All courses

Classroom · Live online · Training for teamsFind the right course for your next step.
  1. Home
  2. »
  3. Excel VBA Programming
Instructor-led training
Excel VBA Programming Training in London and Live Online

Excel VBA Programming

Automate repeatable Excel tasks with VBA. Work with the Excel object model, procedures, ranges, data validation and error handling to build maintainable workbook tools.

Request Course Information
Price:
Price on request

Contact us for current fees, dates and exam arrangements.

Beginner to intermediate

Be comfortable using Excel worksheets, formulas and common workbook features.

5 days to complete
Available online
& in class

Select your preferred method

Course overview
Course dates
  • In Classroom
  • Live Virtual
  • 1 - 1 Training
  • Corporate Training
  • Onsite Training
Introduction
Automate repeatable Excel tasks with VBA. Work with the Excel object model, procedures, ranges, data validation and error handling to build maintainable workbook tools.


This instructor-led course combines clear explanations with guided exercises and practical scenarios. Work through examples relevant to the subject, review alternative approaches and practise checking your results rather than relying on a demonstration alone.
You will develop a structured approach to implementation, troubleshooting and documentation. The trainer can adapt examples to the agreed learning needs and available training environment. Confirm the course duration, software or lab requirements, delivery arrangements and fees with London IT Training before booking.
This is professional development training. It does not automatically award a third-party vendor certification.
What the course covers
Flexible Ways to Learn

Study your way with flexible learning options designed to fit around your schedule.

Small Groups

With small groups of students, our instructors can work closely with each student

Flexible Class Schedules

Our class schedules are flexible on weekdays, weekend or evening to suit your schedule.

Experienced Instructors

Our instructors follow a modified and personalised approach to engage students during class

Hi-Tech lab Facilities

Lab arrangements vary by course. Confirm access and equipment requirements before booking.

Prerequisites
What you’ll gain

Apply vba environment in a practical course exercise.

Apply programming fundamentals in a practical course exercise.

Apply excel object model in a practical course exercise.

Apply data processing in a practical course exercise.

Develop skills for your next step
Relevant career pathways
Technical Practitioner:

Apply the course skills to relevant technical tasks.

Technical Consultant:

Assess requirements and recommend practical implementation choices.

Syllabus

Course context and practical foundations
Review the course objectives and relevant concepts. Set up a suitable training environment, identify a realistic example and agree how to validate the results.

Use the editor, record simple macros and understand workbook file types. Review macro security and trusted execution.

Write procedures, variables, conditions and loops. Use clear names and organise reusable routines.

Work with workbooks, worksheets, ranges and cells. Qualify object references and avoid unintended changes to the wrong workbook.

Read, validate and transform worksheet data. Use arrays and suitable structures to improve reliability and efficiency.

Create understandable inputs, prompts and forms where appropriate. Validate data and provide useful feedback.

Use breakpoints, error handling and meaningful checks. Document assumptions, protect source data and plan safe distribution.

Complete an integrated exercise using sample data or an isolated training environment. Test the result, document decisions and troubleshooting steps, and identify improvements and next learning objectives.

1
2
3
4
5
6
7

FAQs

Who is this course for?
Automate repeatable Excel tasks with VBA. Work with the Excel object model, procedures, ranges, data validation and error handling to build maintainable workbook tools.

Be comfortable using Excel worksheets, formulas and common workbook features. No prior VBA programming experience is required. Confirm access to desktop Excel with VBA support and appropriate macro permissions.

VBA environment; Programming fundamentals; Excel object model; Data processing; User interaction; Debugging and maintenance.

No. This is professional development training. It does not automatically award a third-party vendor certification.

Contact London IT Training to discuss classroom, live online and corporate delivery arrangements.

Contact the training team for current duration, available dates, fees and software or lab requirements. Do not assume that licences, materials or examination fees are included.

Need help choosing the right course?

Talk to one of our advisers about dates, delivery options and certification routes. We’ll call you back within 1 working day.

LONDON IT TRAINING

Let’s plan
your next step.

Tell us what you would like to learn.

  • Course guidance
  • Dates and delivery
  • Training for teams

Your details are used to respond to your enquiry. Privacy Policy