Excel VBA courses London & UK

Testimonials

Some feedback from recent courses:

"All aspects of the course were covered very well."
Leon P, TCS
[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."
Jono M, JPMorgan
[Excel VBA Intro Intermediate]

"Training very high standard."
Jason R, DWP
[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
Using Macros
Using Visual Basic editor to edit macros
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	2009 Jul 6 Mon + 7 Tue	Southwark	0	FULL
2003	2009 Jul 20 Mon + 21 Tue	Southwark	0	FULL
2003	2009 Aug 4 Tue + 5 Wed	Southwark	6	book now	£475	£485
2007	2009 Aug 10 Mon + 11 Tue	Bloomsbury	3	book now	£490	£495
2003	2009 Aug 20 Thu + 21 Fri	Southwark	3	book now	£495	£495
2003	2009 Aug 27 Thu + 28 Fri	Bayswater	0	FULL
2007	2009 Sep 17 Thu + 18 Fri	Bloomsbury	6	book now	£485	£490
2003	2009 Oct 1 Thu + 2 Fri	Southwark	9	book now	£345	£399
2007	2009 Oct 15 Thu + 16 Fri	Bloomsbury	8	book now	£345	£425
2003	2009 Oct 19 Mon + 20 Tue	Southwark	8	book now	£450	£485
2003	2009 Oct 29 Thu + 30 Fri	Southwark	10	book now	£275	£399
2003	2009 Nov 18 Wed + 19 Thu	Southwark	10	book now	£275	£399
2007	2009 Nov 23 Mon + 24 Tue	Bloomsbury	10	book now	£275	£399
2003	2009 Dec 3 Thu + 4 Fri	Southwark	9	book now	£345	£399
2007	2009 Dec 7 Mon + 8 Tue	Bloomsbury	10	book now	£325	£415
2007	2010 Jan 11 Mon + 12 Tue	Bloomsbury	10	book now	£275	£399
2003	2010 Jan 21 Thu + 22 Fri	Southwark	10	book now	£275	£399
2007	2010 Feb 4 Thu + 5 Fri	Bloomsbury	10	book now	£275	£399
2003	2010 Feb 18 Thu + 19 Fri	Southwark	10	book now	£275	£399
2007	2010 Mar 11 Thu + 12 Fri	Bloomsbury	10	book now	£325	£415
2003	2010 Mar 18 Thu + 19 Fri	Southwark	10	book now	£275	£399

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