Excel tutorials

In the last post we saw the benefits of using structured references.

Here we have created two columns of data, as a table. Our goal is to calculate som measures.

• Enter some data
• Format as table by hitting CTRL+T
• Name the table as Table1
• Check “Headers”
• Enter some values that you want to calculate, like MIN,MAX,AVERAGE,SUM

The formulas is as below:

• =MIN(Table1[AMOUNT])
• =MAX(Table1[AMOUNT])
• =AVERAGE(Table1[AMOUNT])
• =SUM(Table1[AMOUNT])

If we add a fruit and amount, the values will recalculate, this is one of the benefits of structured references.