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 2010 workbook. If you want, you can use this example.
  2. Filter a column of data. If you are using the example, filter the Type column so it displays only laptops and other equipment.
  3. Add another filter by searching for the data you want. If you are using the example, search for EDI brand equipment in the Item Description column.
  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 cam. This should exclude any camera-related equipment, such as digital cameras and camcorders.
  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 2010.
  7. Use an advanced number filter to view numbers less than a certain amount. If you are using the example, display all ID #s less than 3000.