Essentials · Foundations

The Worksheet

4 lessons and 56 marked steps, with a workbook to open in Excel alongside. Your first two lessons on LogicExcel are free with a free account; after that every lesson opens with the All-Access Pass.

1. 1. Workbook, worksheet, cell: how Excel stores what you seeAll-Access Pass

   Distinguish the stored value from the displayed value, explain why they differ, and predict which one a formula uses.

   14 marked steps

2. 2. Entering, editing and filling dataAll-Access Pass

   Enter and amend data efficiently, extend series with AutoFill, and fill a selection or a column without dragging.

   14 marked steps

3. 3. Data types: text, number, date, booleanAll-Access Pass

   Identify how a value is stored, recognise numbers held as text, and convert between them deliberately.

   14 marked steps

4. 4. Navigating and selecting at speedAll-Access Pass

   Move and select across large sheets with the keyboard, jump to a named range, and select scattered cells to act on them at once.

   14 marked steps

Finished Foundations? Sit the Foundations exam for its certificate.