Instructor-led training - vba training
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

Microsoft Partner

Learning & Performance Institute - Accredited Training Provider

How to book

Live 12+ month schedule

On-site / Closed company:

60 second quote

Need help or advice?

Enter your name/number and we will call you back

We'll call during UK business hours

Name:
Number:

VBA Training (Excel VBA Advanced course) - London and UK wideExcel 2003

VBA Advanced course - London & UK Wide

2 days from £275 List price £650

Instructor-led / Microsoft qualified trainers

Courses never cancelled: Guaranteed

Course rating:
4.8 stars - based on 1636 reviews

Benefits

Upon completion of the course delegates will have a good understanding of Object Orientated Programming as practised in Excel, together with the ability to interact with other office applications. In addition, the course also covers importing data from database applications such as Access, and manipulating and presenting the data.
VBA Advanced for Excel Training

878 Excel events in the next 12 months, live dates & pricing here


Who is this course for?

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 more advanced programming techniques.

Prerequisites

Attendance of our Microsoft Excel VBA course, or equivalent knowledge.

Including the understanding of the following:

  • Variable types
  • Using object variables to represent worksheets and workbooks
  • Using count based and conditional based loops
  • If-else-end if and select case statements
  • With blocks
  • Using range and cells objects

Objectives

Upon completion of the course delegates will have a good understanding of Object Orientated Programming as practised in Excel, together with the ability to interact with other office applications. In addition, the course also covers importing data from database applications such as Access, and manipulating and presenting the data.

Course Syllabus

Further Excel Object Model

The Range object
The Current Region object
Workbooks and worksheets collections
Chart object
List object

Arrays

Dynamic arrays
Array optimisation
Multidimensional arrays
Arrays and objects

Object Oriented Programming (OOP)

Classes and objects
creating new objects
creating new classes
Error handling

Good programming techniques

Recursive programming
Using optional arguments
Best Practice for Excel Programming

Further Object Orientated Programming

Destroying objects
Default property and method
Working with collections

Advanced Procedures, parameters, variables

Passing parameters by reference and by value
Optional and default parameters
Passing an array of arguments to a procedure
Using enumerations
User-defined Type
Implicit and explicit conversions

Linking with Office

Connecting to other Office applications
Working with other Office applications

Importing from Access using ADO

Understanding Active-X data objects
The Connection string
Manipulating data

Macro Security

How macro security works
Digitally signing macros
Excel VBA Intro Intermediate 2 day course Onsite/Closed Quote
Date Location Places
available		 Book Next place rate (£) List
price
Pay by
Card		 Pay by
Invoice
Thu 27 + Fri 28 Jun 2013 Limehouse 6 Book now £550 £560£650
Mon 8 + Tue 9 Jul 2013 Bloomsbury 4 Book now £625 £635£650
Mon 15 + Tue 16 Jul 2013 Southwark 2 Book now £630 £640£650
Wed 24 + Thu 25 Jul 2013 Limehouse 5 Book now £575 £585£650
Tue 6 + Wed 7 Aug 2013 Southwark 7 Book now £492 £502£650
Tue 13 + Wed 14 Aug 2013 Limehouse 9 Book now £380 £390£650
Tue 20 + Wed 21 Aug 2013 Bloomsbury 7 Book now £485 £495£650
Tue 27 + Wed 28 Aug 2013 Southwark 9 Book now £380 £390£650
Wed 4 + Thu 5 Sep 2013 Limehouse 9 Book now £360 £370£650
Tue 17 + Wed 18 Sep 2013 Limehouse 9 Book now £360 £370£650
Tue 24 + Wed 25 Sep 2013 Southwark 10 Book now £650 £650£650
Thu 26 + Fri 27 Sep 2013 Bloomsbury 9 Book now £360 £370£650
Mon 30 Sep + Tue 1 Oct 2013 Bloomsbury 9 Book now £360 £370£650
Mon 7 + Tue 8 Oct 2013 Southwark 10 Book now £650 £650£650
Mon 14 + Tue 15 Oct 2013 Limehouse 9 Book now £330 £340£650
Thu 17 + Fri 18 Oct 2013 Bloomsbury 10 Book now £650 £650£650
Mon 21 + Tue 22 Oct 2013 Southwark 9 Book now £330 £340£650
Thu 24 + Fri 25 Oct 2013 Southwark 10 Book now £650 £650£650
Mon 28 + Tue 29 Oct 2013 Bloomsbury 9 Book now £330 £340£650
Tue 5 + Wed 6 Nov 2013 Limehouse 10 Book now £650 £650£650
Thu 14 + Fri 15 Nov 2013 Bloomsbury 10 Book now £275 £285£650
Mon 18 + Tue 19 Nov 2013 Limehouse 10 Book now £650 £650£650
Wed 20 + Thu 21 Nov 2013 Southwark 10 Book now £275 £285£650
Tue 26 + Wed 27 Nov 2013 Bloomsbury 10 Book now £650 £650£650
Mon 2 + Tue 3 Dec 2013 Limehouse 9 Book now £330 £340£650
Thu 5 + Fri 6 Dec 2013 Southwark 10 Book now £650 £650£650
Tue 10 + Wed 11 Dec 2013 Bloomsbury 10 Book now £275 £285£650
Thu 12 + Fri 13 Dec 2013 Southwark 10 Book now £650 £650£650
Tue 17 + Wed 18 Dec 2013 Bloomsbury 10 Book now £275 £285£650
Thu 2 + Fri 3 Jan 2014 Bloomsbury 10 Book now £650 £650£650
Mon 13 + Tue 14 Jan 2014 Limehouse 10 Book now £275 £285£650
Mon 13 + Tue 14 Jan 2014 Limehouse 10 Book now £650 £650£650
Tue 14 + Wed 15 Jan 2014 Southwark 10 Book now £275 £285£650
Wed 15 + Thu 16 Jan 2014 Limehouse 10 Book now £650 £650£650
Thu 16 + Fri 17 Jan 2014 Bloomsbury 10 Book now £275 £285£650
Wed 22 + Thu 23 Jan 2014 Bloomsbury 10 Book now £650 £650£650
Wed 29 + Thu 30 Jan 2014 Limehouse 10 Book now £275 £285£650
Mon 3 + Tue 4 Feb 2014 Southwark 10 Book now £650 £650£650
Thu 6 + Fri 7 Feb 2014 Bloomsbury 10 Book now £275 £285£650
Wed 12 + Thu 13 Feb 2014 Limehouse 10 Book now £650 £650£650
Wed 19 + Thu 20 Feb 2014 Southwark 10 Book now £275 £285£650
Tue 25 + Wed 26 Feb 2014 Limehouse 10 Book now £650 £650£650
Mon 3 + Tue 4 Mar 2014 Bloomsbury 10 Book now £275 £285£650
Thu 6 + Fri 7 Mar 2014 Limehouse 10 Book now £650 £650£650
Tue 11 + Wed 12 Mar 2014 Southwark 10 Book now £275 £285£650
Thu 13 + Fri 14 Mar 2014 Bloomsbury 10 Book now £650 £650£650
Thu 20 + Fri 21 Mar 2014 Limehouse 10 Book now £275 £285£650
Wed 2 + Thu 3 Apr 2014 Limehouse 10 Book now £650 £650£650
Tue 15 + Wed 16 Apr 2014 Southwark 10 Book now £275 £285£650
Wed 16 + Thu 17 Apr 2014 Bloomsbury 10 Book now £650 £650£650
Wed 23 + Thu 24 Apr 2014 Limehouse 10 Book now £275 £285£650
Wed 30 Apr + Thu 1 May 2014 Bloomsbury 10 Book now £650 £650£650
Thu 8 + Fri 9 May 2014 Limehouse 10 Book now £275 £285£650
Thu 15 + Fri 16 May 2014 Southwark 10 Book now £650 £650£650
Thu 22 + Fri 23 May 2014 Bloomsbury 10 Book now £275 £285£650
Wed 28 + Thu 29 May 2014 Limehouse 10 Book now £650 £650£650
Wed 4 + Thu 5 Jun 2014 Southwark 10 Book now £275 £285£650
Thu 5 + Fri 6 Jun 2014 Southwark 10 Book now £650 £650£650
Wed 11 + Thu 12 Jun 2014 Bloomsbury 10 Book now £275 £285£650
Thu 12 + Fri 13 Jun 2014 Southwark 10 Book now £650 £650£650
Mon 16 + Tue 17 Jun 2014 Bloomsbury 10 Book now £275 £285£650
Thu 19 + Fri 20 Jun 2014 Bloomsbury 10 Book now £650 £650£650
Thu 26 + Fri 27 Jun 2014 Limehouse 10 Book now £275 £285£650
Mon 30 Jun + Tue 1 Jul 2014 Bloomsbury 10 Book now £275 £285£650
Mon 7 + Tue 8 Jul 2014 Southwark 10 Book now £650 £650£650
Mon 14 + Tue 15 Jul 2014 Bloomsbury 10 Book now £275 £285£650
Thu 17 + Fri 18 Jul 2014 Limehouse 10 Book now £650 £650£650
Mon 21 + Tue 22 Jul 2014 Southwark 10 Book now £275 £285£650
Thu 24 + Fri 25 Jul 2014 Bloomsbury 10 Book now £650 £650£650
Wed 30 + Thu 31 Jul 2014 Limehouse 10 Book now £275 £285£650
Thu 31 Jul + Fri 1 Aug 2014 Limehouse 10 Book now £650 £650£650
Tue 5 + Wed 6 Aug 2014 Southwark 10 Book now £275 £285£650
Thu 7 + Fri 8 Aug 2014 Bloomsbury 10 Book now £650 £650£650
Tue 12 + Wed 13 Aug 2014 Limehouse 10 Book now £275 £285£650
Thu 14 + Fri 15 Aug 2014 Southwark 10 Book now £650 £650£650
Tue 19 + Wed 20 Aug 2014 Bloomsbury 10 Book now £275 £285£650
Thu 21 + Fri 22 Aug 2014 Limehouse 10 Book now £650 £650£650
Tue 26 + Wed 27 Aug 2014 Southwark 10 Book now £275 £285£650

What you get

Training room

Training is held in our modern, comfortable, air-conditioned suites

Modern-spec IT, fully networked with internet access

"What do I get on the day?"

Learning tools
Breaks and TimingsBreaks and timing

Courses start at 9:30am.
Please aim to be with us for 9:15am.
Joining information (how to get to our venues)
In-course handbookIn-course handbook

Contains unit objectives, exercises and space to write notes
RefreshmentsRefreshments

Available throughout the day:

  • Hot beverages
  • Clean, filtered water
  • Biscuits
Reference materialReference material

Available online. 100+ pages with step-by-step instructions
LunchLunch

Lunch is provided at a local restaurant or pub. Browse the sample menus:
24 months forum access24 months access to Microsoft trainers

Your questions answered by Microsoft qualified trainers online.

Training Formats & Services

Some reasons why thousands of businesses trust us

Transparent quality control
Live 12 month schedule/bookings
Courses never cancelled: Guaranteed
Reschedule in seconds
Industry leading pricing model
Online quote
24 months training support

About us

Testimonials

The King's Fund
Management Accountanr
John Axon
Excel VBA Intro Intermediate
I had a clear idea of what I wanted from the 2 days training and the trainer exceeded my expectations. Many thanks!!
Norfolk Constabulary
Analyst
Kyriacos Constantinou
Excel VBA Intro Intermediate
The course was very imformative and pitched at just the right level. It will really help with my day to day report running.
EnterpriseMouchel
Senior Estimator
Andi Clark
Excel VBA Intro Intermediate
Superb course, will be booking in to do advanced once I've had a little time to soak up this course.

More testimonials

Some of our clients:

London 2012 Special Olympics Great Britain Transport for London
13 delegates 19 delegates 35 delegates
92% would
recommend us		 100% would
recommend us		 85% would
recommend us
BBC Virgin Media Television Ricoh Europe plc
17 delegates 19 delegates 12 delegates
100% would
recommend us		 100% would
recommend us		 100% would
recommend us
UK Sport Legal & General Commonwealth Bank of Australia
29 delegates 25 delegates 49 delegates
100% would
recommend us		 100% would
recommend us		 100% would
recommend us
Monsoon Accessorize Ltd Open University Close Brothers Group plc
13 delegates 12 delegates 114 delegates
100% would
recommend us		 100% would
recommend us		 94% would
recommend us
Westmill foods Al Jazeera International Ltd IOM
56 delegates 17 delegates 85 delegates
96% would
recommend us		 100% would
recommend us		 100% would
recommend us
Accor Group Ladbrokes plc British Sky Broadcasting Ltd
28 delegates 28 delegates 14 delegates
100% would
recommend us		 100% would
recommend us		 100% would
recommend us
London Stock Exchange BP plc Shell UK Ltd
15 delegates 86 delegates 86 delegates
100% would
recommend us		 100% would
recommend us		 98% would
recommend us
Rabobank Vue Entertainment Metropolitan Police
54 delegates 15 delegates 121 delegates
100% would
recommend us		 100% would
recommend us		 100% would
recommend us

Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Facebook · Twitter · Google+ · LinkedIn · Pinterest

© 2013 Best STL. All Rights Reserved. A Microsoft software training company. infomst
All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy & cookie policy

Resources