FinanceTier 215 minbeginner

Track Expenses as a Table

Turn a growing expense list into a structured table so it expands automatically as new rows are added.

What you will learn

• Convert a plain range into a structured table
• Explain why a table grows with new rows in a way a formatted range does not
• Recognise a plain range still lacks the behaviour a real table provides, however it is formatted

Excel skills

Format as Table · Tables

The task

This expense list keeps growing every month. Convert it into a structured table so new rows added at the bottom are automatically included in any formula or chart built on it.

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