RESIDENTIAL COURSES - ABOUT - TRAVEL LINKS - EXCEL VBA

Excel VBA One Week Residential Course

This course is suitable for experienced Excel users and offers in-depth coverage of Excel VBA programming and application development.

The course comprises:

Day 1: Introduction - Overview of VBA, introduction to key VBA programming techniques, manipulation of range object.

Days 2-3: Intermediate - Excel object model, creation of functions, use of dialogue boxes and forms, workbook and worksheet objects.

Days 4-5: Advanced - Designing applications, handling events, pivot tables, charts and drawings, custom menus, file manipulation, class modules.