Excel VBA Courses in London
Latest News: see Day Courses below:
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:
Tuesday June 22nd 2010
(With class concensus an August break may be taken.)
Tuesday September 7th 2010
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 £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
A day course is to commence April 26 2010
This will run for 5 complete days as follows
June: Mon 21 Wed 23 Fri 25 Mon 28 Wed 30
Following Start Date:
September: Mon 20 Wed 22 Fri 24 Mon 27 Wed 29
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.
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.
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!