Microsoft Excel Advanced
This 1 day Microsoft Excel advanced course is designed for those that need to automate aspects of Excel's functionality with the use of Macros. Computer programming skills will be aquired during this course so a very good level of computer literacy is needed together with a good grasp of the Excel themes covered in the Beginner's and Interemdiate Excel courses.
The outline is only a suggestion and can be tailored to your business needs. To accompany the instructor lead training, each delegate will receive manuals and practice, step-by-step exercises. This will provide an excellent source of information and on-going self study once the training has been completed. Alternatively a more complete self study package can be purchased from our e-learning catalogue.
What is a Macro?
Naming a macro
Editing a recorded macro using using VBA
Relative vs absolute recording mode
Running a Macro
Automatically on workbook opening/closing
Introduction to VBA
Navigating the VB editor
Copying code between macros
Calling macros in a separate procedure
User defined functions
Select Case structures
This Training Course is offered "in house" at the following locations:
Guide Price: £450 per group of 8 delegates
|Category:||Advanced Microsoft Excel|