Successful candidates will be able to:

• Apply advanced formatting options such as conditional formatting and customised number formatting and handle worksheets.
• Use functions such as those associated with logical, statistical, financial and mathematical operations.
• Create charts and apply advanced chart formatting.
• Work with tables and lists to analyse, filter and sort data.
• Create and use scenarios.
• Validate and audit spreadsheet data.
• Enhance productivity by working with named cell ranges and macros.
• Use linking, embedding and importing features to integrate data.
• Compare and merge spreadsheets.
• Apply spreadsheet security features.