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

Excel Slicers are easy to use visual controls added to Excel that allows to quickly and easily filter data in an interactive way by selecting values from a list.

Slicers provide an intuitive, user-friendly interface for filtering data in a spreadsheet. Here’s how to create slicers, format them, and use them to filter data in Excel.

A video demonstration also is available at the bottom of this article. Note that the walk-through and video were made using Microsoft Excel 365 for PCs. Other versions of Excel may work differently.

If Excel filter is not working after a certain row, for merged cells, on large files, or on a protected Sheet, you can follow these solutions to resolve the issue. These tips and work on Microsoft ...

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

One way to display figures in an Excel table according to certain time periods is by using filter buttons. However, a better way to do this is to use a timeline, a dynamic filter option that ...

To display specific values in a PivotTable in Microsoft Excel, use one of the many built-in filters, such as Top 10.

INDEX with XMATCH returns an item from a range or array according to the first or last match it finds. Like XLOOKUP, it works with vertical and horizontal datasets, can search in any direction, and ...