Microsoft Excel VBA Intermediate

Microsoft Applications

Find out more

Download PDF copy

Course Code: XLL6

Duration: 1 Day

Course Aims:

This course is aimed at people who wish to improve on their existing basic knowledge of VBA and enhance their knowledge and appreciation of the concepts, tools and techniques of VBA programming.

Course Pre-requisites:

Students who wish to attend this course need to have significant experience and ability at understanding and using Excel advanced functionality and have attended the Microsoft Excel VBA Introduction course.

Course Objectives:

On completion of this course delegates will be able to:

Course Content:

Introduction and Objectives

Using the "For" Loop

Adding Simple Interactivity to Macros

Exploring the Range Object

Variables and Arrays

User Defined Functions

Testing and Debugging code

Action planning

Review of Programme

Download PDF copy

Excel Frequently Asked Questions


Dedicated Courses

Virtual - £795 per day for up to 8 delegates

Onsite - £845 per day for up to 10 delegates

Public Schedule Courses - N/A


Onsite prices are for courses in London. For other locations, trainer expenses will apply.

All prices displayed are exclusive of VAT.

Apply for this course

Leave us your email address and phone number and one of our team will be in touch to find out a bit more about you and discuss next steps.

Thank you, we'll get in touch
Oops! Something went wrong while submitting the form. Please try again or give us a call.