Tues

Excel VBA Courses in London

The Excel spreadsheet provides an ideal interface to learn a programming language - Excel VBA.

The evening course is held once a week. This provides plenty of time between to perform the class exercise which must be emailed - usually by the Sunday 8 pm. (Since making this course component compulsory, the class standard has risen almost unrecognizably). It is very difficult - almost impossible - to achieve a satisfactory level without this practice of 4-5 hrs per week after ever session.

The daytime class is more demanding. The classes are usually held every morning on 10 consecutive mornings. The afternoons and/or evenings MUST be spent revising the morning's material. The exercises must be submitted before the commencement of the next day's lesson. It ought to be realized that a trainer who may have 30 or more years of acquired programming knowledge is attempting to impart this expertise in only a matter of weeks. It can be done and is done but only by those who make a strong commitment to outside revision. Programming can take years to learn, indeed the learning process never stops. Having said all that, it is possible to write some useful and practical code after about 3 sessions! Taking a 2-week course like this is feasible so long as the attendee understands the amount of extra work required on his or her part. In our experience, consecutive day courses without time for recap simply faze a student and are not encouraged at Kensington College.

Only under exceptional circumstances should a lesson be missed or postponed.

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 simple interface to learn with .....BUT... not without practice.

Participants are actively encouraged to bring along any spreadsheet material that they may be using and wish to automate using VBA.

A recent introduaction of YouTube videos to accompany the course has proved to be very helpful.

Expert teaching in Excel VBA

Excel BVA in easy steps

Ed Robinson, the author of the best-selling book, Excel VBA in easy steps (which is provided) has devised the course.

When do the Excel VBA Courses run?

10 x 2.5 hour lessons = 25 hours total.

Start Dates:

Evening:

Tue 14 November 2017 (With mutually agreed xmas break) 6-30 - 9pm

1. Tue 14th Nov
2. Tue 21st Nov
3. Tue 28th Nov: Ed
4. Tue 5th Dec: Ed
5. Wed 20th Dec (with class consensus)
6. Wed 27th Dec (with class consensus)
7. Wed 3rd Jan (with class consensus)
8. Wed 10th Jan
9. Tue 16th Jan
10. Tue 23rd Jan
Tue 29th Jan and following tues depending on above.
Please note that this class will be restricted to 4 persons.

Wed 24 January 2018 (for 10 consecutive weds). 6-30 - 9pm

Day times:

Jan 22 2018 : For 10 mornings.

Afternoons should be spent revising/practising and performing the daily exercise.

What does the course cover?
Topics covered on this course are:

Total cost
Evening : 700
Daytime: £750

 

Individual Courses

Can be arranged to suit. Please phone to arrange times.
These can be tailored depending on student experience.
The basic course is fully covered in a slightly shorter period of time.

10 sessions of 2 hrs.

Cost: £1450

Private Tuition

£75 per hr

Certificate

A certificate is awarded upon reasonably completing and submitting coursework throughout the course.

 

VBA and intro to FM (Financial Modelling)

VBA/FM Class are now available. Largely based upon:Financial Modeling by Simon Benninga This is also a very interesting and excellent reference for interested students for further reading.
Excel VBA and financial modeling go hand in hand.

Duration Three 2 hour sessions. Cost : £300

Previous knowledge. VBA. Preferably having attended our VBA course.
Content: To include PV and IRR. Matrices. Amortization. Bond Pricing. Option Pricing (including Black Scholes). Protfolio Optimization.

These sessions are much of an an overview and a demonstration of how VBA is applied to FM. For example how writing VBA code to raise a matrix to a power is utilized in bond pricing or how a user defined function can be written in VBA and used to calculate the BS option price directly on a spreadsheet.

 

 

 

 

 

 

0207 402 8098

mobile: 07956 390909

info@kensingtoncollege.co.uk




Call us on


0207 402 8098

info@kensingtoncollege.co.uk



 

 

 

(