Filtering Data in a List - Exercise

Welcome to our free Intermediate Microsoft Excel 2013 tutorial. This tutorial is based on Webucator's Intermediate Microsoft Excel 2013 Training course.

Contact Us or call 1-877-932-8228
Filtering Data in a List - Exercise

Filtering Data in a List

Duration: 10 to 20 minutes.

In this exercise, you will practice filtering data in a list.

  1. Open Filter.xlsx from your Excel2013.2/Exercises folder.
  2. On Sheet1, filter the list to show only houses in Fayetteville with 3 bathrooms.
  3. On Sheet2, filter the list to show only houses costing less than $100,000.
  4. On Sheet3, filter the list to show only houses in Jamesville that have 4 bathrooms and cost less than $100,000.

Solution:

  1. On Sheet1, filter the list to show only houses in Fayetteville with 3 bathrooms.
    1. Select any cell in the list.
    2. On the DATA tab, in the Sort & Filter group, click the Filter command:Filter Command
    3. Click the drop-down arrow next to "Town" and de-select everything except Fayetteville, and click OK:De-Selected
    4. Click the drop-down arrow next to "Bathrooms" and de-select everything except 3, and click OK:De-Selected Options
  2. On Sheet2, filter the list to show only houses costing less than $100,000.
    1. Select any cell in the list.
    2. On the DATA tab, in the Sort & Filter group, click the Filter command:Filter Command
    3. Click the drop-down arrow next to "Listing Price," move your mouse over Number Filters, and select Less Than:Less Than Option
    4. Fill in "100000" and click OK:100000
  3. On Sheet3, filter the list to show only houses in Jamesville that have 4 bathrooms and cost less than $100,000.
    1. Select any cell in the list.
    2. On the DATA tab, in the Sort & Filter group, click the Filter command:Filter Command
    3. Click the drop-down arrow next to "Listing Price", move your mouse over Number Filters, and select Less Than:Less Than Option
    4. Fill in "100000" and click OK:100000
    5. Click the drop-down arrow next to "Town" and de-select everything except Jamesville, and click OK:De-Selected Options
    6. Click the drop-down arrow next to "Bathrooms" and de-select everything except 4, and click OK:De-Selected Options
Next

This tutorial is based on Webucator's Intermediate Microsoft Excel 2013 Training Course. We also offer many other Microsoft Excel Training courses. Sign up today to get help from a live instructor.