A structured table is a range of data converted into a named Excel object that expands automatically when rows are added, applies formatting and offers filters and total rows. Formulas can reference its columns by name. It is a stable source for charts, PivotTables and queries.
Example
Insert > Table, then name the table Ventes in the Table Design tab.