Advanced Spreadsheets requires the candidate to use the spreadsheet application to produce advanced spreadsheet outputs.

The candidate shall 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 features.
• 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, macros and templates.
• Use linking, embedding and importing features to integrate data.
• Collaborate on and review spreadsheets. Apply spreadsheet security features.

Training conforms to latest ECDL Advanced Syllabus v2.  Download Advanced Module 4 full course syllabus here.

Extensive in-depth coverage of this practical module in a multi-media approach to ensure effective learning to succeed in your ECDL Advanced Certification exam.