SWATukvantis

Return to pass home page | About pass | Request A Brochure | Contact Us | Sitemap   
     

Excel Macros (VBA) Course Outline

Overview and Objectives:
This 2-day course has been specially designed for advanced user who wants to make use of the more powerful features of Excel made available by VBA. This course explores VBA language and delegates will be encouraged to write programs to ensure that future editing, amending and updating can be carried out with the minimum of effort.

Who should attend:
Existing Excel power users who wish to utilize the VBA to develop more sophisticated applications.
Delegate numbers are restricted to 8, to ensure personal attention from the trainer.

Course prerequisites
 Excel users who are confident in their use of the commands, functions and simple Macros gained by prior attendance on an "Excel Advanced" course or via user experience.

Structure:
PC for every delegate.

Duration: 2 days

Fee: £410 + VAT per delegate (Discounts)

Location: All courses are held in Central London

Dates 2010
January  28/29
February  -
March  1/2, 29/30
April  19/20
May  -
June  1/2
July  1/2
August  26/27
September  27/28
October  28/29
November  29/30
December  -

See also:
 Excel Introduction
Excel Intermediate
Excel Advanced
Excel Expert
Excel Half-Day Courses

Course Details:

  • Introduction to Macros

  • Editing Macros

  • The Range Object

  • Workbooks and Sheets

  • Objects, Properties and Methods

  • Variables and Constants 

  • Control Structures

  • Controls, Dialogue Boxes and Forms

  • Storing Information

  • Toolbars and Display

  • Debugging and Error Trapping

  • Worksheet and Workbook Events 

  • Function Procedures

  • Add-in Applications

  • Appendix - Naming Conventions

IN-DEPTH COURSE DETAILS

CLICK HERE to request a quotation, or fill out the form below to book this course. 

"Excellent.10 out of 10! I would recommend to anyone"
David G – Glaxo Smithkline

"Generally enjoyable and well structured. I will book with pass again"
Michelle F – Universal Music

 

Would you like us to assess your current level of ability in Excel?
Simply fill out this short questionnaire, submit your contact details and a member of the client service team will advise you on the most suitable course.

To book on this course please complete the form below, and a member of the client service team will contact you shortly to confirm your booking.

(* required fields)

Name *
Company *

Address *
Position
Telephone No. *
Email *
Name of Delegate *
Course Title
Version:
Your preferred date *
How did you hear about us?

  

Terms:
A full refund (less 20% administration charge) will be made for cancellations received in writing or by email not less than 15 days prior to the course. Cancellations after this time are charged at the full fee or Block Places treated as utilised.

 

Pass Training, London. Computer training, Accountancy training, Auditing and taxation courses, personal Development, and Business Development training courses in London UK
SWATUK Block 2, Angel Square, London, EC1V 1NY (UK)
Tel: 020 7843 1281 Fax: 01752 725725
 Email: info@pass.co.uk