Microsoft Excel VBA Advanced

Microsoft Applications

Find out more

Download PDF copy

Course Code: XLL7

Duration: 1 Day

Course Aims:

This course is aimed at people who already have a very good knowledge of Excel VBA and who wish to improve on this to create more effective, interactive and user-friendly procedures, and extend the reach of their VBA code into areas outside of the Excel application.

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 and Intermediate courses.

Course Objectives:

On completion of this course delegates will be able to:

Course Content:

Introduction and Objectives

Error Handling & Trapping

Event Procedures

Custom User Forms and Form Controls

Working with Object Variables

Working with Charts

Working with Pivot Tables

Interacting with Other Office Applications

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.