microsoft excel vba courses in london
Home   About us   Contact   T & Cs   Search   Sitemap   News   Room Hire   Links  
Tutor Led Courses | Open Course Schedule  
[Back]
[Up]
[Next]
 Course Options
 
Open Public Courses
Tutor led public courses which are scheduled on a regular basis at our SE1 London training centre.

Company Specific Courses
Company specific courses are available for organisations that have several employees who all need training at the same time or the course required is not part of our normal Open Public Course schedule.  .
These closed courses are ideal where tailoring of the standard course content is required. When compared to the Open Public Course option, they typically provide cost benefits when there are three or more employees who need training simultaneously.
Courses can be run on-site if suitable facilities exist or at our SE1 London training centre.

One-On-One Mentoring -  Personal Coaching
Ideal for individual delegates who have a specific requirement from the software or where previous knowledge makes group training inappropriate. The pace and the content of the course can then be adjusted to the individuals exact needs.
 
Floor - Walking
Where attendance on a course may not be considered appropriate, our trainers will visit clients offices on an ad-hoc or regular basis, resolving  individual issues on a case by case basis - delivering quick training sessions on the "front line" at the desk.

 Other Options
In addition to classroom based courses, we also offer a substantial range of computer (CBT) and web (WBT) based training  courses. C/WBT are alternative education methods for those individuals looking for perhaps a cheaper alternative to traditional instructor led (ILT) training.

 
 
Institute of IT Training Logo ECDL Logo

 
 Overview
  This 2-day course is for competent users who wish to use Excel extensively and enhance their working knowledge of the program by learning how to automate tasks in Microsoft Excel through the use of Visual Basic for Applications language.
 

Delivered as a Workshop, with the emphasis on hands-on-experience, the principle objective of the course is to provide delegates with the confidence, knowledge and practical experience to be able to automate tasks in Excel for rapid numerical analysis & presentation of information. Delegates will learn how by using macros they can create flexible solutions that can be used by colleagues with limited knowledge of Excel.

 Course Prerequisites
  Delegates require a good understanding of the features detailed in our primary (Foundation – Intermediate – Advanced) courses. Good keyboard skills are essential.
 

The Workshop is intended as a natural progression from our primary Excel courses.

 Course Content
  At this level every course is fine tuned to the needs of the group, but a course outline would typically include:
  Recording Macros
  Running your Procedure
  The Visual Basic Editor
  Editing your VBA code
  Writing Procedures
  Looping
  Using Message Boxes, Input Boxes and UserForms
  Using Variables
  On Action Procedures
  Controlling the Worksheet
  Using Named ranges
  Handling Errors
  Handling Arrays
  Creating Custom Functions and add-Ins
  Consolidation Exercises
    There will usually be time at the end of the course for delegates to consolidate their newly acquired skills by creating procedures from scratch. Delegates are actively encouraged to use this time to develop procedures that will automate tasks in their own files. If this is not convenient, exercises can be set by the trainer.

All course contents are subject to change with prior notice.
 ILT Course Options Available
  Company Specific Course Request a Quote
  One-On-One Course Request a Quote

View a printer friendly version of this page in a new window - excel vba courses in london - excel vba courses - excel visual basic training

 View a printer friendly version of this page in a new window

[Tutor Led Courses] [Open Course Schedule]
 

  
© 1988 - 2008 Computer Literacy. All rights reserved                                                                                                                                                         
microsoft excel vba courses in london - excel vba courses - excel visual basic training -microsoft excel vba courses in london - excel vba courses - excel visual basic training - microsoft excel vba courses in london