Essentials · Foundations

Structure and Safety

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. Converting ranges to TablesAll-Access Pass

   Convert a range to a Table and name the four behaviours it gives you that a range does not, including what happens to data typed on the row beneath it.

   14 marked steps

2. 2. Data validation rulesAll-Access Pass

   Restrict what can be entered with lists, numeric limits and date ranges, write messages somebody can act on, and know what validation does not catch.

   14 marked steps

3. 3. Protecting cells and sheetsAll-Access Pass

   Lock the calculations, leave the inputs open, protect the sheet with the right actions still allowed, and explain what protection is and is not for.

   14 marked steps

4. 4. Workbook design: inputs, calculations, outputsAll-Access Pass

   Separate a workbook into inputs, calculations and outputs, put every assumption in one visible place, and prove the outputs reconcile to the data.

   14 marked steps

Finished Foundations? Sit the Foundations exam for its certificate.