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.
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
ust Accountancy Jobs has negotiated a special discount of 20%, for candidates if you apply via our website link below:-
