In the current article, I show why it is convenient to use the Format as Table option in Excel. Pretty much, it enables a new feature – you may refer to the cells in it not by an address, but with the column names above.
At first I tought it was some kind of cheating, and then I saw it is really cool. It looks like this:
Step 1 – Create the table
Step 2 – Refer to the columns
I think this is quite beautiful and much more understandable for big formulas. You simply see what is behind the numbers.
Enjoy it! 🙂