ICDL Advanced Spreadsheet (Excel)
Certification Test Goals
This module sets out advanced skills that can be used to produce sophisticated reports, to perform complex mathematical and statistical calculations, and to improve productivity using a spreadsheet application.
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 spread sheet data.
Enhance productivity by working with named cell ranges and macros.
Use linking, embedding and importing features to integrate data.
Compare and merge spread sheets. Apply spread sheet security features.