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.
With power query, named tables, linked data types, lambdas, and xlookup, you can hack structs into excel, letting you write `Person("John").age` in formulas.
It's so handy typing
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.