ICDL Spreadsheets (ICDL)
ICDL Spreadsheets
More study resources
Cheat sheet
Keep the key ideas within reach.
ExploreKey terms
Get comfortable with the vocabulary.
ExploreStudy plan
Give each week a clear focus.
ExploreCommon mistakes
Understand the traps and how to avoid them.
ExploreCase studies
Put your knowledge to work in context.
ExploreExam-day guide
Prepare for the day ahead.
ExploreAbout this exam
ICDL Spreadsheets is one of the modules within ICDL CORE, the programme ICDL describes as "Core digital skills for employability and productivity." It certifies that a candidate can work confidently with spreadsheet software - opening and saving files, entering and editing data, building formulas and functions, applying formatting, producing charts and preparing sheets for printing or sharing. Because it is a core rather than a professional module, it suits students, job-seekers, public-sector employees and anyone who needs a recognised, vendor-neutral proof of everyday spreadsheet competence alongside word processing and other core skills. ICDL states that its certification is available in more than 100 countries through a network of more than 20,000 testing centres, so the module is delivered through accredited centres rather than as a single global online test. Preparation should be hands-on: work through each skill area in a real spreadsheet application, practising cell references, relative versus absolute addressing, common functions, number and conditional formatting, chart selection and print setup. The published skill domains - using the application, cells, managing worksheets, formulas and functions, formatting, charts and preparing outputs - make a useful revision checklist, and the largest weighting sits with formulas and functions, so budget the most practice time there. Confirm test format, duration, fees and retake rules with your local accredited centre, as these are set locally and are not published in the sources reviewed here.
What you'll study
About ICDL Spreadsheets preparation
Is ICDL Spreadsheets the same as ECDL Spreadsheets?
Yes in practice. ECDL is the older name for the same certification family; ICDL notes that "ICDL Foundation, ICDL, ECDL and related logos are registered business names and/or trademarks of ICDL Foundation." Syllabus and test content are set by the same organisation, so study material labelled either way covers the same skills.
What does the exam actually test?
Practical spreadsheet skills across seven areas: using the application, working with cells, managing worksheets, formulas and functions, formatting, charts, and preparing outputs. Formulas and functions carry the heaviest weighting, so expect the most tasks there. It is a hands-on test of doing tasks in the software, not a theory paper.
How long is the test and what score do I need to pass?
Those values are not stated in the sources reviewed for this page, so we do not publish figures. Test duration and the pass mark are set by ICDL and applied by your accredited test centre. Ask your centre directly before booking so you can plan your time and know your target.
How much does it cost and can I retake it?
Fees and retake rules are not published in the sources reviewed here and vary by country and test centre. Contact your local accredited centre for the current price, what is included, and the conditions and cost of a retake. Do not rely on figures quoted for other countries or older syllabus versions.
Do I need to memorise function names?
You need to use common functions correctly rather than recite a list. Practise entering functions with the correct argument order, and know the difference between relative and absolute references when a formula is copied. Being able to build a working SUM, AVERAGE, IF or COUNT-style formula from a written instruction is the realistic requirement.
What is the best study order?
Follow the skill order: application basics and file handling, then cell entry and editing, worksheet management, formulas and functions, formatting, charts, and finally print and output preparation. Spend the largest share of time on formulas and functions, since that domain carries the heaviest weighting in the published profile.
Where do candidates usually lose marks?
The recurring problems are formula errors - wrong cell references after copying, missing arguments, text instead of calculated values - plus incomplete formatting and charts that use the wrong data range or chart type. Printing tasks are also commonly rushed: failing to set orientation, scaling or print area before finishing.
Can I take it online or do I have to go to a centre?
ICDL states its certification is delivered through a network of accredited testing centres, so the normal route is to register with a centre near you. ICDL's site includes a tool to locate a test centre in your region. Ask that centre whether remote or on-site testing is offered for this module.
How should I prepare in the final week?
Do timed, hands-on practice on a full spreadsheet task rather than rereading notes. Build a small dataset, then calculate totals with formulas, apply number and conditional formatting, insert a chart, and set up a print layout. Repeat until each step is automatic without checking help.