Filtering Data

Filtering in Excel lets you temporarily hide unwanted data. Use filters in Excel to narrow down data in your Excel spreadsheet.

Challenge!

  1. Open an existing Excel workbook. If you want, you can use our practice workbook.
  2. Apply a filter to a column. If you are using the example, filter the Type column (column B) so it displays only laptops and cameras.
  3. Add another filter by searching. If you are using the example, search for EDI brand equipment in the Equipment Detail column (column C).
  4. Clear both filters.
  5. Use an advanced text filter to view data that does not contain a certain word or phrase. If you are using the example, display data that does not contain the word saris (this should exclude all Saris brand equipment).
  6. Use an advanced date filter to view data from a certain time period. If you are using the example, display only the equipment that was checked out in September 2013.
  7. Use an advanced number filter to view numbers less than a certain amount. If you are using the example, display all items with an ID# below 3000.