Excel VBA Advanced

Course summary
2 days
441 GBP excl. VAT
Next available date: 19/03/2020 09:30 - London
Open / Scheduled
STL courses

Excel VBA Advanced

Courses never cancelled. Restaurant lunch. Last minute rescheduling. 24 month delegate support forum. And more... Upon completion of the course delegates will have a good understanding of the major components of VBA.; Delegates will expand their reach by being able to use VBA to communicate with other Office applications, such as Word.; In addition, the course also covers working with data from database applications such as Access, and manipulating and presenting the data.

Suitability - Who should attend?

This course is aimed at individuals with a basic grounding in Excel VBA and an advanced knowledge of Microsoft Excel, who wish to develop their skills with introduce more sophisticated automation into their workflows.

Training Course Content

The Excel Object Model

Exploring the Range object in detail
The versatile CurrentRegion object
Working with collections of Workbooks and Worksheets
Manipulating Charts through VBA
Manipulating PivotTables through VBA


Efficient variable storage with arrays
Array optimisation
Dynamic arrays
The Array function

Triggers and Events

Running macros automatically
Executing macros on a timer
Associating macros with other Workbook events

Advanced Parameters

Passing parameters by reference and by value

Working with Text Files

Importing text files
Exporting text files
Using the FileStream object

Linking with Office

Connecting to other Office applications
Working with other Office applications

Linking to data sources using ADO

Understanding ActiveX Data Objects
Using Excel to communicate with other data sources
Understanding the connection string
Adding, reading, modifying and deleting data


How macro security works
Password protecting your code
Distributing macros via an Add-In

Appendix: Classes and Objects

Working with Class Modules


List price £699 per delegate. Promotional rates apply: see event listings for current prices. On-site training also available: Contact us.

Be Inspired! Watch the Video


Election Analysis Excel Dashboard

Best STL

Using an Excel Dashboard to analyse and visually display May 2015 UK General Election Poll data from the web.

Provider: STL

STL - Microsoft Training

STL - Helping businesses deliver productivity and efficiency gains

Learning solutions from leadership and management training programmes to business intelligence and applications training. London based with a global reach....

Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Excel VBA Advanced.

  Contact the provider

  Get more information

  Register your interest

Customer Outreach Award


We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Contact information for STL


Greater London
STL, 2nd Floor, Cruising Association House
E14 8BT 1 Northey Street

 Show phone number

Reviews by course attendees

Average rating 4.5

Based on 406 reviews

Louise Cooper; Reward Analyst
Most useful topic: Arrays
Luke Butcher; Commercial Finance Manager
Most useful topic: Arrays (special cells; current region)
Michael Costello; Business Analyst
The course was excellent; but a little too face and advanced for my level of knowledge. Having done the beginning and intermediate; I wasn't fluent in all the things I needed to know; but I was helped wherever I needed help by my trainer.

Similar Courses

Request information

Find out more about this Excel VBA Advanced course - simply fill out your details:

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!


Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here