Professional Training
4.6 (492 Reviews)

Excel VBA Advanced

STL, In London (+21 locations)
Length
1 day
Price
380 - 460 GBP excl. VAT
Next course start
5 September, 2024 (+46 start dates)
Course delivery
Classroom, Virtual Classroom
Length
1 day
Price
380 - 460 GBP excl. VAT
Next course start
5 September, 2024 (+46 start dates)
Course delivery
Classroom, Virtual Classroom
Leave your details so the provider can get in touch

Excel VBA Advanced

STL courses

  • 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 and Outlook
  • The course will give the delegates a good understanding of how arrays can be used to handle large datasets, optimising VBA codes and execution speed.

What to expect

  • Courses never cancelled .
  • Restaurant lunch .
  • Last minute rescheduling .
  • 24 month delegate support forum .
  • Face-to-Face and Virtual Instructor led .
  • And more... .

Upcoming start dates

Choose between 46 start dates

5 September, 2024

  • Virtual Classroom
  • Online
  • English

12 September, 2024

  • Classroom
  • London
  • English

10 October, 2024

  • Virtual Classroom
  • Online
  • English

18 October, 2024

  • Classroom
  • London
  • English

14 November, 2024

  • Virtual Classroom
  • Online
  • English

25 November, 2024

  • Classroom
  • London
  • English

19 December, 2024

  • Virtual Classroom
  • Online
  • English

2 January, 2025

  • Classroom
  • London
  • English

23 January, 2025

  • Virtual Classroom
  • Online
  • English

6 February, 2025

  • Classroom
  • London
  • English

27 February, 2025

  • Virtual Classroom
  • Online
  • English

14 March, 2025

  • Classroom
  • London
  • English

3 April, 2025

  • Virtual Classroom
  • Online
  • English

22 April, 2025

  • Classroom
  • London
  • English

8 May, 2025

  • Virtual Classroom
  • Online
  • English

29 May, 2025

  • Classroom
  • London
  • English

12 June, 2025

  • Virtual Classroom
  • Online
  • English

4 July, 2025

  • Classroom
  • London
  • English

17 July, 2025

  • Virtual Classroom
  • Online
  • English

11 August, 2025

  • Classroom
  • London
  • English

21 August, 2025

  • Virtual Classroom
  • Online
  • English

17 September, 2025

  • Classroom
  • London
  • English

26 September, 2025

  • Virtual Classroom
  • Online
  • English

Enquire for more information

  • Classroom
  • Aberdeen
  • English

Enquire for more information

  • Classroom
  • Bedford
  • English

Enquire for more information

  • Classroom
  • Belfast
  • English

Enquire for more information

  • Classroom
  • Birmingham
  • English

Enquire for more information

  • Classroom
  • Bristol
  • English

Enquire for more information

  • Classroom
  • Burnley
  • English

Enquire for more information

  • Classroom
  • Cardiff
  • English

Enquire for more information

  • Classroom
  • Edinburgh
  • English

Enquire for more information

  • Classroom
  • Edinburgh
  • English

Enquire for more information

  • Classroom
  • Glasgow
  • English

Enquire for more information

  • Classroom
  • Leeds
  • English

Enquire for more information

  • Classroom
  • Leicester
  • English

Enquire for more information

  • Classroom
  • Liverpool
  • English

Enquire for more information

  • Classroom
  • London
  • English

Enquire for more information

  • Classroom
  • Manchester
  • English

Enquire for more information

  • Classroom
  • Newport
  • English

Enquire for more information

  • Classroom
  • Nottingham
  • English

Enquire for more information

  • Classroom
  • Portsmouth
  • English

Enquire for more information

  • Classroom
  • Sheffield
  • English

Enquire for more information

  • Classroom
  • Southampton
  • English

Enquire for more information

  • Classroom
  • Sunderland
  • English

Enquire for more information

  • Classroom
  • Wolverhampton
  • English

Enquire for more information

  • Virtual Classroom
  • Online
  • English

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

Arrays

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

PivotTables and Charts

Manipulating Charts through VBA
Manipulating PivotTables through VBA

Linking with Office

Connecting to other Office applications
Working with other Office application

Expenses



List price £699, promotional rates available. STL are the only company to offer a dynamic pricing and availability model, updated live on our site, daily on this portal. Closed group training options available (at your offices, UK wide/International or our London Venues). Contact us below.

Request information - obligation free

Contact course provider

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

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Customer Outreach Award

customer-outreach-badge-2019

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.

Reviews by course attendees

Average rating 4.6

Based on 492 reviews.
Reviews are published according to our review policy.
Write a review!
5/5
Helen Corporate Development & Strategy Associate (M&A)
01 Nov 2023

Thank you Jens; a fantastic course; I really appreciate the tailored approach and helpfulness.

5/5
Matt
04 Jan 2023
5/5
Florian
16 Dec 2022

My course was originally set to be in person but due to the rail strikes was moved to be virtual. Despite the distance the course felt really welcoming and engaging. Jens is an ...

Show more
STL
1 Northey Street, 2nd Floor, CA House
E14 8BT London

STL

Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...

Read more and show all courses with this provider

Ads