| |
| Course Duration |
1 Day |
| Aim of Course |
On completion of this course, delegates will be able to record simple macros, edit Visual basic Code and build procedures, which interact with the user. |
| Target Audience |
Delegates should have a good working knowledge of Excel or have attended an Excel Expert Course. Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA should attend. |
| Structure of Course |
The course will concentrate on practical learning. Delegates will be shown techniques and will then have the chance to use these skills by working through exercises.
|
| Training Facilities |
Training will take place in one of 4 fully equipped training
suites delivered by professional lecturers. Up to date multimedia and
interactive software/smartboards. Free on-line back-up support after
training.
|
|
|
- Record a macro in Excel
-
Edit a macro
-
Knowledge of programming
-
Functions and procedures
-
Object oriented programming
-
Logic functions of Excel
-
Use of Inputbox and Msgbox
-
Use of variables
-
If..Then..Else statements
-
Do..Until loops
-
Create and modify user forms
-
Create your own functions
-
Create add-ins
|
