Course Aims:
This course is aimed at people who already have a very good knowledge of Excel VBA and who wish to improve on this to create more effective, interactive and user friendly procedures, and extend the reach of their VBA code into areas outside of the Excel application.
Course Pre-requisites:
Students who wish to attend this course need to have significant experience and ability at understanding and using Excel advanced functionality and have attended the Microsoft Excel Level 5 and Level 6 courses.
Course Objectives:
On completion of this course delegates will be able to:
Course Content:
Introduction and Objectives
Error Handling & Trapping
Event Procedures
Custom User Forms and Form Controls
Working with Object Variables
Working with Charts
Working with Pivot Tables
Interacting with Other Office Applications
Action planning
Review of Programme
Related Courses
Access Advanced
Access VBA
WWP Training Limited can also create this course for you on arrangement either at your workplace or at one of their locations.