Microsoft Excel’s Advanced Filter feature displays records that match specific criteria. You can also limit the columns returned by this feature.

Microsoft Excel comes with a lot of built-in functionality that doesn't restrict you to comparing data in two columns using only one method.

Launch Microsoft Excel and open the spreadsheet you want to filter by multiple colors. Select the column that you want to filter. To select multiple columns, click and drag over the column headers.

This month, Susan Harkins introduces an Excel user to advanced filtering and helps a PowerPoint user reduce his work when positioning pictures in PowerPoint.