Instructor-led training - London course in Excel
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:

Excel course in London - VBA for Excel trainingExcel 2003

VBA Intro Intermediate 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

  • At the end of the course the delegate will have covered the fundamentals of VBA, including working with procedures and functions, understanding objects, using expressions, variables and intrinsic functions.
  • They will have mastered how to control program execution, working with forms and controls, working with the PivotTable object.
  • Finally the course also includes modules on debugging code, handling errors to ensure minimal downtime while building and effecting the program.
VBA for Excel Training

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


Who is this course for?

Advanced users of Microsoft Excel responsible for very large and variable amounts of data, or teams, who want to learn how to program features and functions to improve the accessibility and usability of their data.

Prerequisites

A high proficiency of Microsoft Excel is essential,
or completion of our Microsoft Excel Advanced course.

Objectives

  • At the end of the course the delegate will have covered the fundamentals of VBA, including working with procedures and functions, understanding objects, using expressions, variables and intrinsic functions.
  • They will have mastered how to control program execution, working with forms and controls, working with the PivotTable object.
  • Finally the course also includes modules on debugging code, handling errors to ensure minimal downtime while building and effecting the program.

Course Syllabus

Getting Started

Introducing Visual Basic for Applications
Understanding the development environment
Using Visual Basic help
Closing the Visual Basic editor

Working with Procedures and Functions

Understanding modules
Creating a standard module
Understanding procedures
Creating a sub procedure
Calling procedures
Using the immediate window to call procedures
Creating a function procedure
Naming procedures
Working with the code editor

Understanding Objects

Understanding objects
Navigating the Excel object hierarchy
Understanding collections
Using the object browser
Working with properties
Using the with statement
Working with methods
Creating an event procedure

Using Expressions, Variables and Intrinsic Functions

Understanding expressions and statements
Declaring variables
Understanding data types
Working with variable scope
Using intrinsic functions
Understanding constants
Using intrinsic constants
Using message boxes
Using input boxes
Declaring and using object variables

Controlling Program Execution

Understanding control-of-flow structures
Working with boolean expressions
Using the if...end if decision structures
Using the select case...end select structure
Using the do...loop structure
Using the for...next structure
Using the for each...next structure
Guidelines for use of control-of-flow structures

Working with Forms and Controls

Understanding UserForms
Using the toolbox
Working with UserForm properties, events and methods
Understanding controls
Setting control properties in the properties window
Working with the label control
Working with the text box control
Working with the command button control
Working with the combo box control
Working with the frame control
Working with option button controls
Working with control appearance
Setting the tab order
Populating a control
Adding code to controls
Launching a form in code

Working with the PivotTable Object

Understanding PivotTables
Creating a PivotTable
Working with the PivotTable wizard method
Working with PivotFields
Assigning a procedure to a custom toolbar

Debugging Code

Understanding errors
Using debugging tools
Setting breakpoints
Stepping through code
Using break mode during run mode
Determining the value of expressions

Handling Errors

Understanding error handling
Understanding VBA's error trapping options
Trapping errors with the on error statement
Understanding the error object
Writing an error handling routine
Working with inline error handling

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 23 + Fri 24 May 2013 Bloomsbury 1 Book now £635 £645£650
Wed 5 + Thu 6 Jun 2013 Southwark 3 Book now £635 £645£650
Wed 12 + Thu 13 Jun 2013 Bloomsbury 5 Book now £575 £585£650
Mon 17 + Tue 18 Jun 2013 Bloomsbury 4 Book now £615 £625£650
Thu 27 + Fri 28 Jun 2013 Limehouse 7 Book now £497 £507£650
Mon 8 + Tue 9 Jul 2013 Bloomsbury 7 Book now £492 £502£650
Mon 15 + Tue 16 Jul 2013 Southwark 7 Book now £497 £507£650
Wed 24 + Thu 25 Jul 2013 Limehouse 6 Book now £520 £530£650
Tue 6 + Wed 7 Aug 2013 Southwark 9 Book now £360 £370£650
Tue 13 + Wed 14 Aug 2013 Limehouse 9 Book now £360 £370£650
Tue 20 + Wed 21 Aug 2013 Bloomsbury 7 Book now £480 £490£650
Thu 22 + Fri 23 Aug 2013 Limehouse 10 Book now £650 £650£650
Tue 27 + Wed 28 Aug 2013 Southwark 10 Book now £285 £295£650
Thu 29 + Fri 30 Aug 2013 Limehouse 10 Book now £650 £650£650
Wed 4 + Thu 5 Sep 2013 Limehouse 9 Book now £360 £370£650
Tue 10 + Wed 11 Sep 2013 Bloomsbury 10 Book now £650 £650£650
Tue 17 + Wed 18 Sep 2013 Limehouse 10 Book now £275 £285£650
Wed 18 + Thu 19 Sep 2013 Bloomsbury 10 Book now £275 £285£650
Mon 23 + Tue 24 Sep 2013 Southwark 10 Book now £650 £650£650
Mon 30 Sep + Tue 1 Oct 2013 Bloomsbury 10 Book now £275 £285£650
Mon 7 + Tue 8 Oct 2013 Southwark 10 Book now £650 £650£650
Mon 14 + Tue 15 Oct 2013 Limehouse 10 Book now £275 £285£650
Thu 17 + Fri 18 Oct 2013 Limehouse 10 Book now £650 £650£650
Mon 21 + Tue 22 Oct 2013 Southwark 10 Book now £275 £285£650
Thu 24 + Fri 25 Oct 2013 Southwark 10 Book now £650 £650£650
Mon 28 + Tue 29 Oct 2013 Bloomsbury 10 Book now £275 £285£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
Thu 14 + Fri 15 Nov 2013 Limehouse 10 Book now £650 £650£650
Wed 20 + Thu 21 Nov 2013 Southwark 10 Book now £275 £285£650
Mon 25 + Tue 26 Nov 2013 Southwark 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 Bloomsbury 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
Mon 13 + Tue 14 Jan 2014 Limehouse 10 Book now £275 £285£650
Tue 14 + Wed 15 Jan 2014 Limehouse 10 Book now £650 £650£650
Tue 14 + Wed 15 Jan 2014 Southwark 10 Book now £275 £285£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 Bloomsbury 10 Book now £650 £650£650
Wed 19 + Thu 20 Feb 2014 Southwark 10 Book now £275 £285£650
Mon 3 + Tue 4 Mar 2014 Limehouse 10 Book now £650 £650£650
Mon 3 + Tue 4 Mar 2014 Bloomsbury 10 Book now £275 £285£650
Tue 11 + Wed 12 Mar 2014 Southwark 10 Book now £275 £285£650
Thu 20 + Fri 21 Mar 2014 Limehouse 10 Book now £275 £285£650
Tue 15 + Wed 16 Apr 2014 Southwark 10 Book now £275 £285£650
Wed 23 + Thu 24 Apr 2014 Limehouse 10 Book now £275 £285£650
Thu 8 + Fri 9 May 2014 Limehouse 10 Book now £275 £285£650
Thu 22 + Fri 23 May 2014 Bloomsbury 10 Book now £275 £285£650
Wed 4 + Thu 5 Jun 2014 Southwark 10 Book now £275 £285£650
Wed 11 + Thu 12 Jun 2014 Bloomsbury 10 Book now £275 £285£650
Mon 16 + Tue 17 Jun 2014 Bloomsbury 10 Book now £275 £285£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 14 + Tue 15 Jul 2014 Bloomsbury 10 Book now £275 £285£650
Mon 21 + Tue 22 Jul 2014 Southwark 10 Book now £275 £285£650
Wed 30 + Thu 31 Jul 2014 Limehouse 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

Testimonials

Hilton Hotels
Revenue Analyst
Laura McParland
Excel VBA Intro Intermediate
Great course aided by the fact we had a great trainer. Really helpful, understanding, enthusiastic.
Defence Equipment & Support
Julian Swift
Excel VBA Intro Intermediate
This was a good course to introduce an Excel user to Excel VBA. The trainer was knowledgeable, enthusiastic and very helpful. Presentation of the course was particularly good.
JPMorgan
Jono M
Excel VBA Intro Intermediate
A very good experience. I will recommend to many friends... Trainer covered everything I was interested in learning. The course was very well paced and very informative.

More testimonials

Some of our clients:

London 2012 Special Olympics Great Britain Ricoh Europe plc
13 delegates 19 delegates 12 delegates
92% would
recommend us
100% would
recommend us
100% would
recommend us
BBC UK Sport Virgin Media Television
17 delegates 29 delegates 19 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
Transport for London Lloyds Banking Group British Sky Broadcasting Ltd
35 delegates 124 delegates 14 delegates
85% would
recommend us
97% would
recommend us
100% would
recommend us
Nord Anglia Education Open University Shell UK Ltd
61 delegates 12 delegates 86 delegates
98% would
recommend us
100% would
recommend us
98% would
recommend us
Monsoon Accessorize Ltd Ocado Betfair
13 delegates 27 delegates 15 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
Ladbrokes plc The Roof Gardens Fred Perry
28 delegates 18 delegates 53 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
KPMG LLP (UK) Close Brothers Group plc EasyJet
29 delegates 114 delegates 16 delegates
100% would
recommend us
94% would
recommend us
100% would
recommend us
Cancer Research UK LOVEFiLM International Ltd. Legal & General
16 delegates 61 delegates 25 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