| 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. |
