|
Excel: Work Smarter
A Filter is a query, or question, regarding
your data. You can create Custom Filters by combining several
filters on the same spreadsheet.
Try it: Filter the Data
Go
to Data-> Sort
Sort by the Category.
Filter the Category for Educational clients,
then filter the Class for Excel.
What Do You See? Each column that has a
Filter has a small icon. Data ->
Sort |
|||
|
| |||
Microsoft Excel 2007 Exam 77-602 Topic: 4. Presenting Data Visually
4.6. Sort and filter data
4.6.1. Sort data using single or multiple criteria: Filter data using Custom AutoFilter