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. Conveniently situated in Bloomsbury Square, we're close to several tube and mainline rail stations.

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 weekly. This is be submitted as an email attachment 2 days 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. 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

Excel BVA in easy steps

Ed Robinson, who 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.

When do the Excel VBA Courses run?

10 x 2.5 hour lessons = 25 hours total.

Usually Tuesday Evenings 6-30-9pm. Day times to be arranged

A Thursday evening class is sometimes scheduled.

Next start times:
Tuesday March 25th 2008.
Tuesday June 10th 2008.

What do the courses cover?

Topics covered on this course are:

Total cost: £650

Payment may be made in full in advance but a £50 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

Full time consecutive day courses are not encouraged.

Ten morning sessions over a two week period can be arranged but it is absolutely essential and part of the requirement that a student is able to revise and complete the exercises in the afternoon (or evening).

(It is also possible (and probably desirable!) to extend these 10 sessions over a longer time period.)

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. Please phone.

Cost: £1250



Financial Modeling by Simon Benninga
This is an excellent reference
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!

 

 

 

 

Call us now on 0207 580 1113 to book your place