Microsoft Office Tutorials and References
In Depth Information
Managing Large Amounts of Data
After you create an Excel database
and assemble a large amount of data, you
probably want to analyze it. You may want
to ask yourself questions about your data. “Who
are my best customers?” “Which inventory items
are provided by a specific supplier and cost less
than a certain amount?” “Which employees work
the least amount of hours?" Which condos have
three bedrooms? Excel includes several tools you
can use to answer these questions and study your
data so you can make better decisions.
After clicking anywhere in your database,
choose Data>Sort & Filter>Filter. Excel
displays a filter arrow in each database column.
The AutoFilter feature is unavailable for
2. Click the arrow in the column heading from
which you want to find a common value.
Excel displays a drop-down menu, which
includes one of each unique entry (up to
10,000 entries) in the selected column (as
you see in Figure 11-29).
Filtering means that Excel can pull out specific
records for review. This provides you with an easy way
to break down your data into smaller, more
manageable chunks. Filtering does not rearrange your data; it
simply temporarily hides records you don’t want to
review so you can clearly examine those you do.
Creating an AutoFilter
AutoFilter provides a quick and easy way to find
and work with a subset of data in a range. A
filtered range displays only the rows that meet the
criteria you specify for a column. You use the
AutoFilter, which includes filtering by selecting
from available choices.
Unlike sorting, filtering does not rearrange a range.
Filtering temporarily hides rows you do not want
displayed. When Excel filters rows, you can edit,
format, chart, and print your range subset without
rearranging or moving it.
Select the item you want to filter.