20 June 2015
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.
Full article: Structured referencing to identify parts of Excel tables
