Most spreadsheet problems come from static cell ranges—Excel tables replace them with dynamic, self-managing data structures.

Use implicit And and Or operators with Excel’s Advanced Filter feature to create complex, but powerful, filtering combos. Editor’s Note: This article was originally published in July 2010 and the ...