Excel's AutoFilter feature is easy to implement and use, but it can do more than first meets the eye. The trick is to be a bit creative. The tips in this article aren't related in any way; they all ...

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 ...

Filters are used to create subsets of data in a Microsoft Excel worksheet. The "AutoFilter" or "Sort and Filter" function in Excel allows you to create views of data matching your specified criteria.

The Excel AutoFilter feature allows you to narrow your data based on certain criteria and extract records that match those criteria. To turn on a filter, select the cells with data that you want to ...

One of the most popular tasks in Microsoft Excel is filtering dates by month, or another particular criterion. However, there are times when the Excel date filter grouping does not work as intended, ...

You don’t need more effort; you need better formulas.

Pivot tables generate great reports in Microsoft Excel, but adding a filter or two can make them even more flexible. Here’s how. Pivot tables in Microsoft Excel are a great way to organize and analyze ...

From sales figures to production projections, employee performance data to equipment logs, Microsoft Excel provides a flexible, powerful means of investigating the hidden information within your ...