One of the most advanced and least used functions of Excel is the use of the table within Excel. Granted, a worksheet is a variety of table; however, specifying the data within your worksheet as a table unlocks numerous formula functions that were otherwise unavailable. In addition, when you specify your data as a table, Excel is able to interpret additions to the table and automatically include formulas, equations, and other items that are assigned manually.
In this recipe, you will learn how to specify data as a table and view the information with a data table effect.