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

One typical application for Excel is to find information in a list of data. The simplest way to do this is filtering the data so that Excel does the work of finding the pertinent information for you ...

Organize your Excel spreadsheet so that each row represents a new and unique record and each column contains categories of information. This organization allows you to use the sort and filter ...

Timelines provide an easy way for viewers to quickly filter Microsoft Excel data in a meaningful way.

How to Filter Every 5th Item in Excel. When manipulating large amounts of data in an Excel spreadsheet, it can be challenging or time-consuming to select specific items by hand.

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on ...

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

What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter, format ...

XLOOKUP is Excel’s modern fix for everything VLOOKUP got wrong. It’s simpler, more flexible, and available in Excel 365 and ...