Excel Training - Advanced

Excel training for those who want to get the most out of Excel with automation. This training builds on the skills leant on our intermediate Excel course, and is intended for participants who frequently use Excel to analyse complex data sources. The course is very practical based. It focuses on automation and introduces the participant to visual basic for applications. The participant will design new worksheets from an existing worksheets using visual basic and learn how to modify the user interface to the spreadsheet using forms.

Course content:

Macros
An introduction to Visual Basic
Control structures
Conditional formatting
Creating forms and Dialog boxes
Scenarios

Course duration 1 day.

Course Prerequisites. The course assumes the participant will have already completed the level two course above or is at an equivalent level.