Stage 2 · Lesson 1 of 6
References and structured tables
Formulas only work at scale if you understand references. A points a formula at a cell. A relative reference such as A2 shifts when you copy the formula to another cell.
An absolute reference such as $A$2 stays fixed. A mixed reference fixes only the row or only the column. Next, turn every block of data into a .
In Excel, click inside it and press Ctrl+T. In , use a and consistent columns. Tables grow as you add rows.
Formulas can also refer to columns by name, such as Sales[Amount], which is far easier to read and check. Everything later in this stage, from SUMIFS to , works better on a table.
Common traphand-typed ranges like A2:A500 that quietly miss row 501 next month, or a rate cell without the $ that breaks when copied down.
A question to check yourself, an AI practice session and 2 cheat sheet entries come with the full roadmap. Unlock
Resources for this stage
Start with
- GuideFreeExcel help and learning
Microsoft · Beginner
Official, accurate guides to XLOOKUP, SUMIFS, PivotTables and cleaning functions, with examples you can paste