|
Excel: Work Smarter
There's too much data-too many rows of information.
This is just inyourface noise. A Filter is a simple method for analyzing your
data. Filters use the labels in the Header Row to show or hide the
rows of data.
Try it: Filter the Data
Make a copy of the Original Data worksheet. Rename it 2007 Sales
Filtered.
Select the entire spreadsheet
Go to the Data tab
Click on Filter
You can use
the
sample spreadsheet
or enter your own data if you wish. Data ->
Filter |
|||
|
| |||
Microsoft Excel 2007 Exam 77-602 Topic: 4. Presenting Data Visually
4.6. Sort and filter data 4.6.2. Filter data using AutoFilter