Microsoft Office Tutorials and References
In Depth Information
Chapter 22: Managing information in tables
CHAPTER 22
Managing information in tables
How to organize a table ..........................723
Creating a table .................................723
Adding totals to a table...........................728
Sorting tables and other ranges....................730
Filtering a list or table ............................739
Using formulas with tables ........................754
Formatting tables................................760
MICROSOFT E CEL 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 add a
column directly to the right of a table, the table expands to incorporate the new row or
column. All table styles, conditional formatting, calculations, and data validation rules
extend to the new row or column. Charts based on data from the table also are
similarly updated. Likewise, if you add a new column adjacent to the table, the column is
automatically incorporated into the table definition.
Structured referencing Formulas that reference elements of a table can use
column names and other tags in place of ordinary cell addresses. This kind of
referencing, exemplified in Figure 22-1, makes table calculations self-documenting and
enhances reliability.
Filtering improvements It’s easier now to filter a table so that you see only the
rows in which you’re currently interested. You can filter on multiple criteria or on icon
sets applied via conditional formatting. You can also use filters based on dynamic
date definitions, such as last week or the current quarter.
Formula replication If you add a column that performs calculations based on
table data (a column such as the one that generates total scores in Figure 22-1), Excel
automatically replicates the calculation formula throughout the column.
721
Search JabSto ::




Custom Search