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

Boolean logical operators in Excel formulas make searching easier, and you can apply the same methods in Internet or database searches.

Using Excel’s Scenario Manager for decision-making This column shows how to quickly project financial possibilities with Excel Scenario Manager.