Most spreadsheet problems come from static cell ranges—Excel tables replace them with dynamic, self-managing data structures.

Microsoft Excel 2010 can convert a worksheet to a data table to help you quickly analyze your related data in formatted rows and columns. When you need to expand the table layout, apply the Home tab ...