Download a free copy of the How-To Geek Advanced Excel Test workbook. After you click the link, you'll find the download button in the top-right corner of your screen.

Use implicit And and Or operators with Excel's Advanced Filter feature to create complex, but powerful, filtering combos.