Data Analysis

Dynamic Ranges & Charts using Excel Tables

We frequently deal with data that is supposed to grow with time (product catalog, sales records etc), how do we write auto correcting formulas for such data? One very good solution lies in using excel tables to do this.

Suppose a stand-alone store owner decides to keep a record of all the items sold for the day in excel. The data looks like following:

Basic data that is likely to expand as we go

Excel Tables: Manage your data like a pro

Excel is all about tables (the two dimensional sheets), and we deal with tabular form data all the time. Due to this, a specific table format was introduced from excel 2007 onwards. Excel table feature help us in several ways, but the crucial ones are: