Preloader spinner

Introduction to Excel Macros and VBA Course

Instructor-led · Live online public dates · Private online or onsite for teams
EXCEL5
An icon of a clock
Duration:
1 day
PUBLIC COURSE
£225 per delegate
PRIVATE ONLINE

£1,295 for up to 10 delegates

‍

‍

‍

‍

PRIVATE ONSITE

£1,295 for up to 10 delegates, plus trainer expenses

Enquire about private training
VAT applied where applicable.
Instructor-led · Live online public dates · Private online or onsite for teams

Our Introduction to Excel Macros and VBA course is designed for experienced Excel users who want to automate repetitive tasks, create macros and start writing VBA code with confidence. This live, instructor-led Microsoft Excel VBA training course introduces Visual Basic for Applications and shows you how to use macros, macro-enabled workbooks and the Excel VBA environment to improve the way you work with spreadsheets.

You can join one of our upcoming public online Excel VBA Introduction course dates or arrange a private session for your team, delivered online via Microsoft Teams or onsite at your office. The course includes practical exercises covering the macro recorder, relative addressing, VBA subroutines and functions, objects, variables, conditional statements, loops, error handling and debugging.

Not sure which Excel course is right for you?

Take our free Excel Skills Assessment and receive an instant recommendation based on your current Excel knowledge and experience.

Need a quick explanation of an Excel term? Browse our free Excel Glossary.

Image of laptop displaying an image containing the words Microsoft Excel

Course Schedule

17
Dec 2026
Duration:

1 day

An icon of a clock

9:30am - 4:30pm (UK Time)

An icon representing a location

Online Live

Price:
Discounted Price:

£225 + VAT

23
Feb 2027
Duration:

1 day

An icon of a clock

9:30am - 4:30pm (UK Time)

An icon representing a location

Online Live

Price:
Discounted Price:

£225 + VAT

Course Code: EXCEL5

Duration: 1 day

‍

Overview

VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks so they can be performed faster, more consistently, and with less effort than performing them manually.

This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimise and debug your code.

 

Learning Objectives

In this course, you will develop and deploy VBA modules to solve business problems. You will:

  • Explain how macros and VBA can be used to automate repetitive Excel tasks
  • Record, run, edit and manage macros
  • Understand the difference between absolute and relative references when recording macros
  • Assigning shortcut keys, Objects and buttons to macros
  • Identify general components of VBA and their appropriate use in solving business solutions
  • Record VBA macros to automate repetitive tasks
  • Write VBA code to create VBA subroutines and functions
  • Use various programming elements to solve problems through code, including variables, objects, conditional statements, and loops
  • Eliminate, avoid, or handle errors in VBA code, and optimise its performance

‍

Target Audience

This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom functions to streamline worksheet formulas and make worksheets easier to support, maintain, and understand.

 

Prerequisites

To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables.

‍

Excel Learning Pathway

‍

Course Content

 

1- LESSON 1: RECORDING A MACRO

  • Topic A: Use the Macro Recorder to Create a VBA Macro
  • Topic B: Record a Macro with Relative Addressing
  • Topic C: Assign Shortcut keys, Objects and buttons
  • Topic D: Delete Macros and Modules
  • Topic E: Identify Strategies for Using the Macro Recorder

‍

2- LESSON 2: USING VBA TO SOLVE BUSINESS PROBLEMS

  • Topic A: Use Macros to Automate Tasks in Excel
  • Topic B: Identify Components of Macro-Enabled Workbooks
  • Topic C: Configure the Excel VBA Environment

‍

3 - LESSON 3: WRITING VBA CODE DIRECTLY

  • Topic A: Write VBA Code
  • Topic B: Discover Objects You Can Use
  • Topic C: Create a Custom Function

‍

4 - LESSON 4: SOLVING PROBLEMS THROUGH CODE

  • Topic A: Make Decisions in Code
  • Topic B: Work with Variables
  • Topic C: Perform Repetitive Tasks

‍

5 - LESSON 5: IMPROVING YOUR VBA CODE

  • Topic A: Debug VBA Errors
  • Topic B: Deal with Errors
  • Topic C: Improve Macro Performance

‍

Related Courses

Client Testimonials

“It gave me a great introduction to VBA, an awareness of what it can do, and now I am comfortable exploring and learning more.”

“The course met all objectives well, and I am confident in my ability to complete those tasks now.”

“I have a much better understanding of how the code works.”

‍

More Excel training: Explore the complete Excel training pathway, including core, data analysis and VBA courses.

Course at a Glance

Duration
1 day
Delivery
Instructor-led · Live online public dates · Private online or onsite for teams
Public course price
£225 + VAT
RRP
Private virtual training

£1,295 for up to 10 delegates

‍

‍

‍

‍

Private onsite training

£1,295 for up to 10 delegates, plus trainer expenses

VAT applied where applicable.
Course code / standard
EXCEL5
Exam / assessment
Materials
Skill level
Advanced
Certificate
Yes
Maximum class size
12
Delivered by
ExperTrain
17
Dec 2026
Duration:

1 day

An icon of a clock

9:30am - 4:30pm (UK Time)

An icon representing a location

Online Live

Price:
Discounted Price:

£225 + VAT

23
Feb 2027
Duration:

1 day

An icon of a clock

9:30am - 4:30pm (UK Time)

An icon representing a location

Online Live

Price:
Discounted Price:

£225 + VAT

ENQUIRE or request a booking

You may also like...

Microsoft Planner Basic

Learn to use Microsoft Planner to create plans, organise and assign tasks, track progress and collaborate effectively with colleagues.

Microsoft Excel Power Query

Learn Excel Power Query to import, clean, transform, merge and reshape data, then load repeatable queries for reporting and analysis.

Microsoft Excel Advanced Functions & Data Modelling

Master advanced Excel functions, XLOOKUP, dynamic arrays, What-If Analysis, PivotTables and Power Pivot for more powerful reporting and data modelling.

COURSE ENQUIRY

Interested in this course?

Request a place on an upcoming course, ask about private training for your team or simply send us a question. There’s no obligation and we’ll respond within one working day.

No-obligation enquiriesFriendly adviceResponse within one working day
CourseCurrent course

Scheduled course booking

Select the course date and number of delegates. You can add another date if you would like to split delegates across different sessions.

+ Add another date

Total delegates: 0

Private training details

Thank you!

We’ve received your enquiry and will respond within one working day.

If you haven’t received our reply by then, please check your junk or spam folder for messages from an @expertrain.co.uk address.
Oops! Something went wrong while submitting the form.

Join our mailing list

Receive details on our new courses and special offers

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.