VBA Training

Microsoft Excel 2003 VBA Advanced - London and UK Wide

VBA Advanced for Excel Training

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

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?

This course is aimed at individuals with a basic grounding in Excel VBA and an advanced knowledge of Microsoft Excel, who wish to develop their skills with more advanced programming techniques.

Prerequisites

Attendance of our Microsoft Excel VBA course, or equivalent knowledge.

Including the understanding of the following:

Variable types
Using object variables to represent worksheets and workbooks
Using count based and conditional based loops
If-else-end if and select case statements
With blocks
Using range and cells objects

Benefits

Upon completion of the course delegates will have a good understanding of Object Orientated Programming as practiced in Excel, together with the ability to interact with other office applications. In addition, the course also covers importing data from database applications such as Access, and manipulating and presenting the data.

Course Syllabus

Further Excel Object Model
The Range object
The Current Region object
Workbooks and worksheets collections
Chart object
List object

Arrays
Dynamic arrays
Array optimisation
Multidimensional arrays
Arrays and objects

Object Oriented Programming (OOP)
Classes and objects
creating new objects
creating new classes
Error handling

Good programming techniques
Recursive programming
Using optional arguments
Best Practice for Excel Programming

Further Object Orientated Programming
Destroying objects
Default property and method
Working with collections

Advanced Procedures, parameters, variables
Passing parameters by reference and by value
Optional and default parameters
Passing an array of arguments to a procedure
Using enumerations
User-defined Type
Implicit and explicit conversions

Linking with Office
Connecting to other Office applications
Working with other Office applications

Importing from Access using ADO
Understanding Active-X data objects
The Connection string
Manipulating data

Macro Security
How macro security works
Digitally signing macros

Public Schedule - Pricing and Availability

Version	Date	Location	Places available	Book	Next place rate (£)
Excel VBA Advanced 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Wed 17 + Thu 18 Mar 2010	Southwark	1		£545	£550
2003	Tue 4 + Wed 5 May 2010	Southwark	8		£475	£500
2003	Mon 26 + Tue 27 Jul 2010	Bloomsbury	8		£475	£500
2003	Wed 1 + Thu 2 Sep 2010	Southwark	10		£272	£272
2003	Wed 27 + Thu 28 Oct 2010	Southwark	10		£272	£272
2003	Wed 8 + Thu 9 Dec 2010	Bloomsbury	10		£272	£272

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