ICDL Spreadsheets (ICDL) study plan

Build formulas using arithmetic operators and confirm operator precedence by hand-checking three sample results

Write formulas with relative, absolute and mixed references and predict what changes when each is copied across or down

Apply SUM, AVERAGE, MIN, MAX and COUNT to contiguous and non-contiguous ranges

Introduce intentional #DIV/0!, #REF! and #NAME? errors and repair each one

Use the formula bar to inspect and edit nested expressions rather than retyping them

Write IF formulas with nested conditions and combine them with AND/OR

Build COUNTIF, SUMIF and AVERAGEIF formulas using both text and numeric criteria

Round and format results with ROUND and fixed decimal places

Apply currency, percentage, date and comma number formats to the correct data types

Apply fonts, borders and fill colours consistently across a data table

Merge and centre headings, wrap long text, and set row heights and column widths to fit content

Apply and modify cell styles and a document theme

Create at least three conditional formatting rules including a data bar and a text-based highlight

Copy formatting with Format Painter and deliberately clear formats from a range without deleting content

Align, indent and rotate text to make a header row readable

Enter, edit and select cell ranges using keyboard and mouse, including non-adjacent selections

Use Paste Special to paste values only, transpose a block, and apply an arithmetic operation on paste

Insert and delete rows, columns and cells without corrupting surrounding formulas

Use Find and Replace and the Go To tool to jump to and update specific cells

Insert, rename, move, copy and delete worksheets, and apply a colour to sheet tabs

Configure the application: user name, default file location, autosave interval and default font

Use the help facility, zoom controls and ribbon display options to solve a lookup task

Build 3-D references that summarise the same cell across multiple worksheets

Copy a worksheet between two open workbooks and refresh the dependent formulas

Freeze panes and split a window to keep headings visible while navigating a long list

Create column, bar, line and pie charts from selected data ranges using both the ribbon and a keyboard route

Select the chart type that fits a given data story and justify the choice in one sentence

Add and edit chart titles, axis titles, legends and data labels

Move, resize and delete charts, and reposition one onto its own sheet

Change a chart's source range and switch rows and columns to redraw it

Set page orientation, paper size, margins and scaling to fit a sheet on a target page count

Insert headers and footers containing page numbers, the current date and the file name

Define a print area and set repeating print titles for a header row

Preview page breaks and adjust them so no table splits awkwardly

Export a sheet to PDF and print only a selected range

Complete a timed 45-question mock covering all seven domains in one sitting

Re-drill the two domains with the lowest mock scores using targeted practice tasks

Compile a one-page personal error log naming each mistake and the correct action

Demonstrate 20 common operations from memory without using menus

Retake a second timed mock and compare domain scores against the first attempt