This class is for students who want to take ICDL exams or for IGCSE students. It has plenty of examples and real life case studies so it can be good for a number of classes. We will cover a great deal of functions and ways to apply these functions.

Insert cell(s), row(s) and column(s), delete cell(s), row(s) and column(s), merge cells

Create formulae using cell references

Replicate formulae using absolute and relative cell references where appropriate Use arithmetic operators in formulae including add, subtract, multiply, divide, indices

Use named cells and named ranges

Use functions including sum, average, maximum, minimum, integer, rounding, counting, LOOKUP, VLOOKUP, HLOOKUP, XLOOKUP, IF Use external data sources within functions Use nested functions.

Formulae and functions The difference between a formula and a function

Order of operations

The order in which mathematical operations are performed including the use brackets to make sure that formulae work Cell referencing

Characteristics and use of absolute and relative cell referencing

Candidates should be able to: Sort data Notes and Guidance Using a single criterion, or multiple criteria sort data into ascending or descending order Search and select data Using a single criterion, or multiple criteria, select subsets of data Perform searches using a variety of operators including AND, OR, NOT, >, <, =,>=, <=, <> Perform searches using wildcards