Excel VBA courses London & UK

Excel Training Courses

Testimonials

Some feedback from courses in the last 18 months:

A very useful and beneficial course. Thoroughly enjoyed it and will put knowledge to good use at work.

Jane Ferguson
AB Mauri (UK) Ltd
Excel VBA Intro Intermediate

This course was very useful as an introduction to VBA. I look forward to working with it more and coming to an advanced course soon

Emma Stewart
RAP UK
Excel VBA Intro Intermediate

Very well presented, paced right, useful tips, an enjoyable experience

Paul Huntley
Defence Equipment & Support
Excel VBA Intro Intermediate

Microsoft Excel 2000 VBA Intro Intermediate

Microsoft Excel 2 day instructor-led. Courses never cancelled: Guaranteed. From £275 (list price £495)

Training formats available

on a public schedule at one of our London training venues
on-site at your company office UK wide
closed group at one of our London training venues
near-site at a location close to you
bespoke one-to-one basis
tailored training courses to your requirements

Who is this training course suitable for?

Highly experienced and trained users of Microsoft Excel who manage very large and variable amounts of data, or teams, and want to be able to program unique features and functions to improve the accessibility and usability of their data.

Prerequisites

Mastering Microsoft Excel or completion of our Microsoft Excel Advanced course are the basic requirements for this course.

Benefits

On completion of the course the learner will have covered the fundamentals of this sophisticated application. Initially instructed in working with procedures and functions, understanding objects, using expressions, variables and intrinsic functions, they will progress to controlling program execution, working with forms and controls and working with the PivotTable object. With the inclusion of modules on debugging code, handling errors, the delegate should be equipped to ensure minimal downtime while building and effecting the program.

Course Syllabus

Introducing Visual Basic
Overview of Visual Basic for Applications
Examining the development environment
Visual Basic help
Closing the editor

Using Procedures and Functions
Understanding and creating modules
Examining procedures
Making a sub procedure
Calling procedures and using the immediate window
Function procedures
Naming a procedure
Using the code editor

Examining Objects
Introducing objects
Understanding the Excel object hierarchy
Examining collections
The object browser
How to work with properties
The with statement
Understanding methods
Designing an event procedure

Expressions, Variables and Intrinsic Functions
Examining expressions and statements
How to declare variables
Examining data types
How to work with variable scope
Creating with intrinsic functions
Examining constants
Creating with intrinsic constants
Creating with message boxes
Creating with input boxes
How to declare and use object variables

Mastering Program Execution
Explaining control-of-flow structures
Adapting boolean expressions
Inputting the if...end if decision structures
Inputting the select case...end select structure
Inputting the do...loop structure
Inputting the for...next structure
Inputting the for each...next structure
Mapping the use of control-of-flow structures

Using Forms and Controls
Examining UserForms
How to use the toolbox
Understanding UserForm properties, events and methods
Explaining controls
Determining control properties in the properties window
How to work with the label control
How to work with the text box control
How to work with the command button control
How to work with the combo box control
How to work with the frame control
How to work with option button controls
How to work with control appearance
Designating the tab order
How to populate a control
Incrementing code to controls
Uploading a form in code

Harnessing the PivotTable Object
Examining PivotTables
Designing a PivotTable
How to work with the PivotTable wizard method
How to work with PivotFields
Directing a procedure to a custom toolbar

Debugging Code
Explaining errors
Uses of debugging tools
How to set breakpoints
Staging through code
How to use break mode during run mode
Analysing the value of expressions

Error Handling
Examining error handling
Explaining VBA's error trapping options
Using the on error statement to trap errors
Examining the error object
Creating an error handling routine
Building with inline error handling

Public Schedule - Pricing and Availability

Version	Date	Location	Places available	Book	Next place rate (£)		List price
Excel VBA Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice	List price
2003	Wed 8 + Thu 9 Sep 2010	Southwark	6		£475	£480	£495
2003	Tue 21 + Wed 22 Sep 2010	Southwark	4		£495	£495	£495
2007	Wed 29 + Thu 30 Sep 2010	Bloomsbury	3		£490	£495	£495
2003	Mon 4 + Tue 5 Oct 2010	Southwark	8		£450	£455	£495
2003	Tue 12 + Wed 13 Oct 2010	Bloomsbury	9		£345	£350	£495
2007	Tue 19 + Wed 20 Oct 2010	Bloomsbury	6		£485	£490	£495
2003	Thu 21 + Fri 22 Oct 2010	Southwark	7		£450	£455	£495
2003	Tue 2 + Wed 3 Nov 2010	Bloomsbury	7		£450	£455	£495
2003	Thu 11 + Fri 12 Nov 2010	Southwark	8		£450	£455	£495
2007	Thu 11 + Fri 12 Nov 2010	Bloomsbury	8		£450	£455	£495
2007	Mon 22 + Tue 23 Nov 2010	Bloomsbury	0	FULL			£495
2003	Thu 25 + Fri 26 Nov 2010	Southwark	9		£345	£350	£495
2007	Thu 2 + Fri 3 Dec 2010	Bloomsbury	9		£345	£350	£495
2003	Thu 9 + Fri 10 Dec 2010	Bloomsbury	10		£275	£280	£495
2007	Wed 15 + Thu 16 Dec 2010	Bloomsbury	8		£345	£350	£495
2003	Wed 22 + Thu 23 Dec 2010	Bloomsbury	10		£275	£280	£495
2007	Mon 10 + Tue 11 Jan 2011	Bloomsbury	9		£345	£350	£495
2003	Tue 11 + Wed 12 Jan 2011	Southwark	10		£275	£280	£495
2003	Thu 20 + Fri 21 Jan 2011	Southwark	10		£275	£280	£495
2007	Thu 10 + Fri 11 Feb 2011	Bloomsbury	10		£275	£280	£495
2003	Thu 17 + Fri 18 Feb 2011	Bloomsbury	10		£275	£280	£495
2003	Wed 16 + Thu 17 Mar 2011	Bloomsbury	10		£275	£280	£495
2007	Thu 17 + Fri 18 Mar 2011	Bloomsbury	10		£275	£280	£495
2003	Mon 28 + Tue 29 Mar 2011	Bloomsbury	10		£275	£280	£495
2007	Tue 5 + Wed 6 Apr 2011	Bloomsbury	10		£275	£280	£495
2003	Wed 6 + Thu 7 Apr 2011	Southwark	10		£275	£280	£495
2003	Wed 20 + Thu 21 Apr 2011	Bloomsbury	10		£275	£280	£495
2007	Wed 27 + Thu 28 Apr 2011	Bloomsbury	10		£275	£280	£495
2003	Thu 5 + Fri 6 May 2011	Southwark	10		£275	£280	£495
2003	Thu 26 + Fri 27 May 2011	Bloomsbury	10		£275	£280	£495
2007	Mon 6 + Tue 7 Jun 2011	Bloomsbury	10		£275	£280	£495
2003	Thu 16 + Fri 17 Jun 2011	Southwark	10		£275	£280	£495
2003	Tue 5 + Wed 6 Jul 2011	Bloomsbury	10		£275	£280	£495
2007	Tue 12 + Wed 13 Jul 2011	Bloomsbury	10		£275	£280	£495
2003	Thu 14 + Fri 15 Jul 2011	Southwark	10		£275	£280	£495
2003	Mon 18 + Tue 19 Jul 2011	Bloomsbury	10		£275	£280	£495
2003	Wed 27 + Thu 28 Jul 2011	Southwark	10		£275	£280	£495
2007	Mon 8 + Tue 9 Aug 2011	Bloomsbury	10		£275	£280	£495
2003	Wed 10 + Thu 11 Aug 2011	Southwark	10		£275	£280	£495
2003	Wed 24 + Thu 25 Aug 2011	Bloomsbury	10		£275	£280	£495
2003	Wed 7 + Thu 8 Sep 2011	Southwark	10		£275	£280	£495
2003	Tue 20 + Wed 21 Sep 2011	Southwark	10		£275	£280	£495
2007	Wed 28 + Thu 29 Sep 2011	Bloomsbury	10		£275	£280	£495

"What do I get on the day?"

Microsoft qualified trainers with industry relevant experience
Modern air conditioned training suite, flat screen PC's, 1 per delegate
Lunch provided in a comfortable and relaxed setting
Comprehensive course material and files to take away
What do I get on the day? - More information

What is Microsoft Excel?

Microsoft Excel is a popular computer program that allows you to create and edit spreadsheets. These are used to store information in columns and rows that can then be organised and/or processed. Spreadsheets are designed to work well with numbers but often include text.

Excel VBA Course London

If you are looking for a VBA Excel course London, we provide Excel VBA courses for all versions of Microsoft Excel. Our Excel VBA training course London can be held in our 5 London training venues. We also provide course Excel training VBA London.