Instructor-led training - London courses VBA Excel
Microsoft Office Training

The UK's number 1 provider for
Microsoft Office training & consultancy

add this page to your favourites/bookmarksBookmark page

view a printable version of this pagePrintable version
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams Customer: Sign in
Delegate: Sign in
Trainer: Log in

Excel VBA courses London & UK

Microsoft Excel 2000 VBA Intro Intermediate

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

Training formats available

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

Excel VBA Intro Intermediate 2 day course
Version Date Location Places
available
Book Next place rate (£)
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?"

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.


Rate this page:
3.7/5 (3 votes cast)
Institute of IT Training - Accredited Training Provider Microsoft Certified Partner
microsoft office
Microsoft Office Specialist Authorised Testing Centre (MOS and MCAS)

Prodigy Platinum Learning Partner

Institute of IT Training - Accredited Training Provider Association of Computer Trainers Valid HTML 4.01 Transitional
Valid CSS Markup

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application Main information pages See also

Access courses
DreamWeaver courses
Excel courses
MS Project courses
Outlook courses
PowerPoint courses
VBA courses
Word courses
(more...)

Public scheduled courses
On-site training
Closed company courses

Training venues
Client list
FAQ
Pricing and availability
Course details / Syllabus

Access training
Dreamweaver training
Excel training
MS Project training
PowerPoint training

London Computer Training
Computer Training London
Microsoft Office training

Microsoft Access training
Microsoft Excel training
Microsoft Project training
Microsoft Outlook training
Microsoft Powerpoint training
Microsoft Word training

Time Management Course London

Interested in Access training? Please see the following pages:
Microsoft access courses · Microsoft training access course
Microsoft+access+training · Access courses in london

Training Information
Training Articles