Structured referencing to identify parts of Excel tables

With the introduction of Tables in Excel 2007, we were also provided a new syntax for referencing Tables and the parts within those Tables. This new syntax is called structured referencing.

As you will see in this article, structured referencing is a very powerful tool that makes your formulas dynamic while maintaining significant simplicity.