QMplus - The Online Learning Environment of Queen Mary University of London

This module will provide you with sufficient skills required by any “analyst” type of position across industry. The module will be taught by a qualified actuary with over 15 years of financial industry experience across the City and Canary Wharf.

There will be a heavy focus on Excel spreadsheet model building – including model design, reusability, documentation, validation and the three S’s of spreadsheets (Speed, Size and Simplicity)

The fundamentals of programming will be introduced through theory: Variable declaration, Error handling, Loops, Logic and Object-oriented programming.

The practical aspects of coding will be through Visual Basic for Applications – the single most employable language in the City and Canary Wharf. We will focus heavily on the three C’s of Coding (Commented, Concise and Clean).

As analytics requires data -  the course will first introduce SQL and Microsoft Access to ensure that participants are comfortable with basic database techniques.

More advanced programming may be taught including:  the Excel object model, ActiveX Data connections and embedded SQL.