Users who need to be able to exploit the full potential of Excel to build powerful spreadsheets, including a wide array of  formulae and functions and who also need to use Excel modelling tools to report on results.

By the end of the course users will be able to create sophisticated spreadsheets, which include complex functions.  They will be able to utilise analysis tools to summarise and extract data, use pivot tables, scenarios, database functions and auditing tools. The use of macros will facilitate the automation of tasks.

A thorough grounding in building multiple sheet workbooks which include functions, such as Min, Max, Average and simple Ifs. Users should also be able to create simple charts and use filter and sorting options.