By Michael Nocito, data analyst · Published August 8, 2026
By the end of this page you can turn a list into a real Excel table, write formulas that name their columns instead of pointing at cells, and add a row of data without going back to fix a single total, chart or pivot. It is about twenty-five minutes, and every result below was produced by doing it in Excel and reading what happened.
Here is what to do right now. Click any cell inside your data and press Ctrl+T. Check that "My table has headers" is ticked, press OK, then go to the Table Design tab and type a real name in the Table Name box, top left. Two keystrokes and a word, and every formula you write from now on can say Orders[Revenue] instead of $H$2:$H$17.
The short version: a range is a set of cells you named by their coordinates, and a table is an object that knows where its own edges are. Everything else follows from that one difference.
The edges are the whole idea, so they get the picture.
