If their mind is blown by named ranges, they are going to faint when learning about the nice structure a proper table (Insert -> Table) gives! It's so handy ty

If their mind is blown by named ranges, they are going to faint when learning about the nice structure a proper table (Insert -> Table) gives! It's so handy typing =SUM(tbl_Sales_Transactions[Total]) And knowing you don't have to adjust the range of the named area as long as the table is the correct length. Far nicer than SUM(F:F) or SUM(F2:F1000) which can cause performance issues and could be exceeded when pulling in new data respectively. Within the table, you can do this syntax to use items on the same row of data. =[@[Price]*[@[Tax Rate]]