Administration and Executive AssistantTier 250 minintermediate

Structured Tables and Named Ranges

Organize your data so formulas grow with it automatically.

What you will learn

• Create a structured table from a data range
• Use table references in formulas
• Understand table expansion on new rows
• Name ranges explicitly and use them in formulas

Excel skills

Table feature, table references, named ranges, Define Name · Data Organization

The task

We are moving leave tracking off paper. The Employees tab has what I captured so far. I need three things.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free