Find Courses Find Providers Providers - Promote Your Courses About Us

Microsoft Excel Advanced

Training Courses

Would you like to see more Microsoft Excel courses?

Training course summary

Sponsored links

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.

Regions:
  • London
  • South East England
Delivery:
  • In House
Category:
Difficulty:
  • Advanced

Further Details

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

Guide price

£450 per group of 8 delegates

 

Sponsored links

Interested in this course?

 

 
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Terms of use
Website design by Brit-net