Advanced Excel

Familiarise yourself with the advanced concepts of Excel and learn how to use Excel for high-powered spreadsheet modelling. Prior attendance on the Intermediate Excel course or an in-depth knowledge of Excel is required.

What will I get out of it ?
• knowledge of the more powerful features of Excel
• ability to create more efficient spreadsheets including automating and customising workbooks.

Key features
• custom formatting
• importing and exporting data
• templates and add-ins
• working with multiple workbooks
• look-up and reference functions
• working with named ranges
• working with toolbars
• using macros.

Dates and location
9 January       8 July
22 January      22 July
11 February     5 August
25 February     19 August
11 March        9 September
25 March        17 September
8 April         7 October
22 April        21 October
7 May           4 November
28 May          18 November
10 June         3 December
24 June         17 December

Please note all sessions run from 09.30 to 16.30 and are held in London

NB This course uses Microsoft software versions 2000-2003. Please ask about training in version 2007