The Excel Filter function is a powerful and versatile tool that can transform your data analysis workflow, dramatically boosting your productivity.

You can filter data in Excel based on either certain parameters in columns or over the whole sheet, and you can later unfilter the sheet.

Learn how to master dense ranking in Excel to fix ranking gaps and improve data analysis with this step-by-step guide. Fix Excel ranking by ...

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

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

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

Excel spreadsheets do so much. This guide starts with the basics and will add more Excel tips over time, so you'll always be in the know.

If the Excel Date Filter is not grouping by month, enable grouping dates in the AutoFilter menu, set dates in the proper format, etc.