How to use the Advanced Filter in Excel Here are a few tricks for configuring the Advanced Filter feature in Excel, including enabling And and Or operators.