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.

Expert teaching in Excel VBA

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: 6.30pm -9.00 pm
Tue 19th September 2023 (10 lessons)
Cost £750

Daytime: 10am -12.30pm
Tue 19th September 2023 (10 lessons)
Cost £850

Remote Evening Course: 6.30pm -9.00 pm
Tue 19th September 2023 (10 lessons)
Cost £750

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

Writing and Editing Code
Branching and Looping
The Excel Object Model
The Range Object
The WorkSheets Collection
Arrays
WorkSheet Events
WorkBook Events
User Defined Functions
To Record and Run a Macro
WorkSheet Functions
ActiveX Controls
UserForms
Date and Time functions.
Interacting With Other Office Applications (Automation).
Collections
API (Application Programming Interface) intro
XML intro.
Saving data to file
Accessing the Internet and retrieving data.
AddIns
Using DLLs intro
Sending email - plain and html.
Charts

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

Online Courses

Individual with possible initial face to face. 10 sessions total.

Using TeamViewer and WhatsApp (as well as YouTubes, Manuals etc.)

Please phone for more details

Commence anytime.

Cost £800

Private Tuition

£75 per hr

Certificate

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

In-House Training

Number : Cost
3 :£3,600
4 :£4,050
5 :£4,400
6: £4,650
7 :£4,800
8 :£4,900

Please note that the timing of sessions is critical. It is strongly recommended consideration is given for attendees to have time to revise and perform coursework - which is allocated after every session. These timings can be discussed according to individual client availability and needs.

VBA Consultancy

£60 per hr