Essentials · Foundations

Named References

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. Creating and scoping namesAll-Access Pass

   Define a name from the Name Box and from a header row, choose workbook or worksheet scope deliberately, and recognise the names Excel will not accept.

   14 marked steps

2. 2. Using names in formulasAll-Access Pass

   Replace an absolute reference with a name, explain why a name never shifts when a formula is copied, and use names inside conditional aggregates.

   14 marked steps

3. 3. Name Manager and auditing namesAll-Access Pass

   Find, edit and repair defined names, including duplicates, unused ones and names left pointing at a deleted range.

   14 marked steps

4. 4. Table names and structured referencesAll-Access Pass

   Convert a range to a Table, address its columns by name, and explain why a Table column beats both a fixed range and a defined name.

   14 marked steps

Finished Foundations? Sit the Foundations exam for its certificate.