Excel VBA courses London & UK

Testimonials

Some feedback from courses in the last 18 months:

Course was very useful, informative and delivered well.

Tatiana Konovalova
WaterAid
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 good. The material is suitable for what I want to accomplish. The trainer is very good at explaining the material in an easy to understand manner.

Joyce Grigorey
CMAI
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 (£)
Excel VBA Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Mon 22 + Tue 23 Mar 2010	Bloomsbury	0	FULL
2007	Tue 6 + Wed 7 Apr 2010	Bloomsbury	4		£470	£475
2003	Wed 7 + Thu 8 Apr 2010	Southwark	7		£445	£450
2007	Thu 15 + Fri 16 Apr 2010	Bloomsbury	0	FULL
2003	Wed 21 + Thu 22 Apr 2010	Bloomsbury	7		£445	£450
2007	Wed 28 + Thu 29 Apr 2010	Bloomsbury	6		£445	£450
2003	Thu 6 + Fri 7 May 2010	Southwark	7		£445	£450
2007	Thu 13 + Fri 14 May 2010	Bloomsbury	0	FULL
2003	Thu 27 + Fri 28 May 2010	Bloomsbury	9		£345	£350
2007	Mon 7 + Tue 8 Jun 2010	Bloomsbury	8		£445	£450
2003	Thu 17 + Fri 18 Jun 2010	Southwark	9		£345	£350
2003	Tue 6 + Wed 7 Jul 2010	Bloomsbury	9		£345	£350
2007	Tue 13 + Wed 14 Jul 2010	Bloomsbury	9		£345	£350
2003	Thu 15 + Fri 16 Jul 2010	Southwark	8		£445	£450
2003	Wed 28 + Thu 29 Jul 2010	Southwark	9		£345	£350
2007	Mon 9 + Tue 10 Aug 2010	Bloomsbury	10		£275	£280
2003	Wed 11 + Thu 12 Aug 2010	Southwark	10		£275	£280
2003	Wed 25 + Thu 26 Aug 2010	Bloomsbury	10		£275	£280
2007	Thu 2 + Fri 3 Sep 2010	Bloomsbury	10		£275	£280
2003	Wed 8 + Thu 9 Sep 2010	Southwark	9		£345	£350
2003	Tue 21 + Wed 22 Sep 2010	Southwark	10		£275	£280
2007	Wed 29 + Thu 30 Sep 2010	Bloomsbury	9		£345	£350
2003	Mon 4 + Tue 5 Oct 2010	Southwark	10		£275	£280
2003	Tue 12 + Wed 13 Oct 2010	Bloomsbury	10		£275	£280
2007	Tue 19 + Wed 20 Oct 2010	Bloomsbury	10		£275	£280
2003	Thu 21 + Fri 22 Oct 2010	Southwark	10		£275	£280
2003	Tue 2 + Wed 3 Nov 2010	Bloomsbury	10		£275	£280
2003	Thu 11 + Fri 12 Nov 2010	Southwark	10		£275	£280
2007	Thu 11 + Fri 12 Nov 2010	Bloomsbury	10		£275	£280
2007	Mon 22 + Tue 23 Nov 2010	Bloomsbury	0	FULL
2003	Thu 25 + Fri 26 Nov 2010	Southwark	10		£275	£280
2007	Thu 2 + Fri 3 Dec 2010	Bloomsbury	10		£275	£280
2003	Thu 9 + Fri 10 Dec 2010	Bloomsbury	10		£275	£280
2007	Wed 15 + Thu 16 Dec 2010	Bloomsbury	10		£275	£280
2003	Wed 22 + Thu 23 Dec 2010	Bloomsbury	10		£275	£280

"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.