GCFLearnFree.org

I love you guys!”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel 2013
  • Filtering Data

Excel 2013

Single page view print copy

Filtering Data

Challenge!

  1. Open an existing Excel workbook. If you want, you can use the Lesson 19 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.
previous next
previous 1 2 3 4 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.