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?
Command macros
Function macros
Recorded macros
Written macros



Good Practise
Good practise
Naming a macro
Macro security
Macro storage
Editing a recorded macro using using VBA
Relative vs absolute recording mode



Running a Macro
Shortcut keys
Macro button
Custom Toolbar
Custom Menu
Automatically on workbook opening/closing



Introduction to VBA
Navigating the VB editor
Creating procedures
Copying code between macros
Calling macros in a separate procedure
User defined functions
Userforms
Message boxes
Input Boxes
IF structures
Select Case structures



Brighton

Guide Price: £450 per group of 8 delegates

Delivery: In house
Category: Advanced Microsoft Excel