ECDL Spreadsheet Advanced – Evenings
The aim of this programme is to provide the trainees with the skills, competence and related
knowledge in the ECDL Excel Advanced Module 4 Syllabus to effectively operate Microsoft Excel
Advanced.
Topics covered in this Module: Advanced Editing & Manipulating of Data, Handle Data,
Advanced Functions, Formulas & Mathematical Ops, Using Analysis/Audit Tools & Techniques
and using Special Tools
Target Award
ICS SKILLS Advanced Spreadsheets (ICDL) – ICDL-16
Start Date: 28-10-2025 Hours/week: 06 Hrs 00 Mins Duration: 5 weeks
Course participants must have successfully completed ECDL/ICDL
Age Requirements
Applicants must have reached the current statutory school leaving age.
Learning Aptitude
Good numerical and literacy skills are essential. Good written and verbal communications skills are desirable
Previous Experience
Successful completion of ECDL/ICDL
| Module | Award | Body |
|---|---|---|
| Ecdl Spreadsheet Advanced – Evening | Advanced Spreadsheets (ECDL) (ECDLAM4) | ICS SKILLS |
1- Apply advanced formatting options such as conditional formatting and customised number formatting and handle worksheets.
2- Use functions such as those associated with logical, statistical, financial and mathematical operations.
3- Create charts and apply advanced chart formatting features.
4- Work with tables and lists to analyse, filter and sort data.
5- Create and use scenarios.
6- Validate and audit spreadsheet data.
7- Enhance productivity by working with named cell ranges, macros and templates.
8- Use linking, embedding and importing features to integrate data.
9- Collaborate on and review spreadsheets. Apply spreadsheet security features.