ICDL Management Spreadsheets (Monavalley)

Understand advanced formatting options, including conditional formatting and customised formatting.

Recognise which functions to use in formulas, and troubleshoot errors.

Identify the correct chart to display a specific data set, and create or edit such a chart.

Know how to analyse, validate, audit, and protect data.

Understand time-saving features such as linking data, paste special, filters, and macros.