Microsoft Excel 2013 Inside Out

Chapter 22. Managing information in tables

• How to organize a table

• Creating a table

• Adding totals to a table

• Sorting tables and other ranges

• Filtering a list or table

• Using formulas with tables

• Formatting tables

MICROSOFT EXCEL 2013 offers an extensive set of features for managing information in tables. You’ll find these features invaluable for almost any kind of tabular work—whether it’s a simple list of names and phone numbers or something much more complex, such as a list of transactions that includes tax or discount calculations, subtotals, and totals.

If you are coming to Excel 2013 from a version prior to Excel 2007, here are some advances in table management you will enjoy:

• Autoexpansion. If you add a row directly below the last row of a table or ...