Filtering in Excel allows you to organize your data in multiple ways. Using a filter, you can cut down the amount of data shown on your sheet based on the values for either a certain selection ...

In Excel, both tables and PivotTables include built-in filtering tools, but they can be a little clunky to use. Slicers offer a more user-friendly way to filter data, making them especially useful ...

Learn how to filter data using wild cards and other complex criteria using Advanced Filter in Excel.

If you need to sort, filter, and manipulate your Excel 2007 data but you don't know how to take advantage of Filters, I have just the thing for you. Watch this two-minute long Business Hacks ...

Learn how to create self-updating filters in Excel to simplify data management and save time with this step-by-step guide.

How to Subset Data in Excel. 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 ...

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Pivot tables generate great reports in Microsoft Excel, but adding a filter or two can make them even more flexible. Here's how.

This post will show you how to filter or sort Excel data using Cell Color and Font Color the easy way. This helps organize cells & improve productivity.

Excel Add-Ins are applications written by independent programmers that provide enhanced capabilities for the primary software. Here's how to install, manage, and choose the best Add-Ins available.

You can't use a SUM() function to sum a filtered list, unless you intend to evaluate hidden and unhidden values. Here's how to sum only the values that meet your filter's criteria.