Instructor-led training - vba training

verified by visa - mastercard securecode

about microsoft training company london uk

Add to favourites

Printable version

Email this page

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Customer account

At a glance

New booking

Choose courses

Enquiries

Information

Pricing and availability Excel VBA Advanced Forum Hints and tips Location/map/parking Search

Training

Public schedule On-site training Closed company E-Learning

Pricing

Public schedule On-site training Closed company E-Learning

VBA Training

Pricing and Availability

· Live online schedule with current pricing

Excel Training Courses

· Excel 2007 Introduction
· Excel 2007 Intermediate
· Excel 2007 Advanced
· Excel 2007 VBA
· Upgrade to Office 2007

· Excel 2003 Introduction
· Excel 2003 Intermediate
· Excel 2003 Advanced
· Excel 2003 VBA
· Excel 2003 VBA Advanced

· Excel 2002 XP Introduction
· Excel 2002 XP Intermediate
· Excel 2002 XP Advanced
· Excel 2002 XP VBA

· Excel 2000 Introduction
· Excel 2000 Intermediate
· Excel 2000 Advanced
· Excel 2000 VBA

· Excel 97 Introduction
· Excel 97 Intermediate
· Excel 97 Advanced

· Excel Training On-site UK
· Excel Consulting Services
· Microsoft Excel Training
· Excel Tips, Tools and Resources

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.

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
Timer
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
Exporting to Word
Linking with Outlook

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	Card	Invoice
2003	2008 Oct 2 Thu + 3 Fri	Bloomsbury	5	book now	£475	£535
2003	2008 Nov 6 Thu + 7 Fri	Bloomsbury	4	book now	£525	£535
2003	2008 Dec 15 Mon + 16 Tue	Bloomsbury	7	book now	£272	£272
2003	2009 Jan 15 Thu + 16 Fri	Bloomsbury	7	book now	£272	£272
2003	2009 Feb 19 Thu + 20 Fri	Bloomsbury	8	book now	£272	£272
2003	2009 Mar 26 Thu + 27 Fri	Bloomsbury	8	book now	£272	£272
2003	2009 Apr 29 Wed + 30 Thu	Bloomsbury	8	book now	£272	£272
2003	2009 May 27 Wed + 28 Thu	Bloomsbury	8	book now	£75	£240
2003	2009 Jun 24 Wed + 25 Thu	Bloomsbury	8	book now	£272	£272
2003	2009 Jul 23 Thu + 24 Fri	Bloomsbury	8	book now	£272	£272
Full Schedule: See all 12 Excel VBA Advanced course dates. Bookings currently available until 24th September 2009.

"What do I get on the day?"

Microsoft certified 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.