Excel VBA Courses in London

The Excel VBA programming language is alive and well within Excel! In practical terms this means that if you already have Excel itself, you don't need to go out and buy Visual Basic.

Our Excel VBA courses are designed to help you get the most out of this flexible programming language.

Excel presents a very good interface (ie the Excel worksheet) so that the VBA code can be easily be applied to practical Excel problems thus providing a means of realizing every-day programming applications.

Paradoxically, Excel VBA is more akin to VB Net's "object model" style of programming than is Visual Basic itself which means that for anyone contemplating another language (C++ as well) , Excel VBA is an ideal place to start.

Excel VBA is much used in the financial world. It is capable of performing quite complex calculations eg option pricing.

In practical terms means that Excel VBA is good for getting jobs! In the past, it has been our policy to promote VB ahead of Excel VBA, but in the light of the above Excel VBA is the recommended language.

The classes are quite formal. Instruction is given for most of the class time.

What is included in the Excel VBA courses?

The manual which accompanies the text is highly simplified.

For each 2.5 hour session, a student would be expected to practise for the same amount of time ie to completely review the previous lesson.

An exercise is given after each lesson. This is be submitted as an email attachment before the next class. This is an extremely important requirement.

Each student of course has his or her own computer in class. Ideally a student would also have his or her own computer at home with an internet connection from which the homework can be sent (in spreadsheet form). The college facilities are available on other evenings (not Fridays), afternoons and some weekends. We not only allow such practice but encourage it to the point of instistence. The importance of revising after each lesson cannot be over emphasized!

At the course completion, subject to satisfactory performance, a Kensington College certificate is awarded.

Expert teaching in Excel VBA

Ed Robinson, who usually takes the Excel VBA course, is the author of the best-selling book, Excel VBA in easy steps.

A copy of this text is provided free with the course.

Update: The book appears to be a victim of its success and is now unobtainable. A printed copy is available free of charge upon registration for the course.

When do the Excel VBA Courses run?

10 x 2.5 hour lessons = 25 hours total.

Tuesday Evenings 6-30-9pm.

Next start times:

Tues March 14th 2012:

Day times: See below.

What do the courses cover?

Topics covered on this course are:

To Edit Code
Branching and Looping
Assigning Variables
The Excel Object Model
The Range Object
The WorkSheets Collection
Arrays
WorkSheet Events
Variant Arrays
WorkBook Events
User Defined Functions
The Application Object
To Record and Run a Macro
WorkSheet Functions
The Personal WorkBook
ActiveX Controls
Project Explorer
UserForms
Excel VBA Help
Classes
Date and Time
Interacting With Other Office Applications
Collections
API (Application Programming Interface)
XML
Saving data to file
Accessing the Internet and retrieving data.
Using DLLs

Total cost: £650

Payment may be made in full in advance but a £100 deposit is acceptable with the balance to be paid after the first class ( to make sure that you are happy!)
(Individual circumstantial concession may apply.)

Day Courses

The day courses commence

Oct 17th: Mon 17 Wed 19 Fri 21 Mon 24 Wed 26

and

23 Jan 2012: Mon 23 Wed 25 Fri 27 Mon 30 Wed Feb

Cost £750

Each day will consist of 2 sessions: 10 - 12.30 and 1.30 - 4.00.

The days in between should be considered as study sessions so that essentially this is a 2-week full time course. Exercises will be set for these interim days (Tue, Thur and w/ends) . It is essential that the exercises are submitted before the commencement of the next day's lesson. Programming is not learned in a couple of days. Programming can take years to learn, indeed the learning process never stops. (Having said that, it is possible to write some useful and practical code after 3 sessions.) Taking a 2-week course like this is something of a compromise but it is feasible so long as the attendee understands the amount of extra work required on his or her part. As for the evening course, it is essential to revise. In our experience, consecutive day courses without recap can simply faze a student.

Under only very extraordinary circumstances can lessons be missed - with the exception perhaps of the very last lesson (which is really a recap of available techniques such as API's, Classes, Automation etc) for which the students would be able to return for the following class for this lesson only.

Excel VBA is probably one of the easiest programming languages to learn. (The assistance offered by the macro recorder should not be underestimated!) The Excel spreadsheet itself is an almost ideal interface to learn with .....BUT... Excel VBA cannot be learned without practising.

Individual Courses

Can be arranged to suit asap. Please phone to arrange times.

10 sesions of 2 - 2 1/2 hrs.

Cost: £1450

Financial Modeling by Simon Benninga
This is an excellent reference for interested students for further reading. (It is not part of our course.)
Of course Excel VBA and financial modeling go hand in hand.
The first half of his very readable text utilizes Excel so you can read this half whilst doing the VBA course and then read the 2nd half which utilizes VBA after you have gained some expertise in VBA!