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.

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 use Excel FILTER, XLOOKUP, and SUMIFS functions to streamline workflows and make smarter data-driven decisions.

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

It enables you to create interactive spreadsheets with ease, using data validation and drop-down lists to enhance user experience. How to use the Excel FILTER Watch this video on YouTube.

Learn how to easily set up your own search field in Excel to find and filter content within a table.

Tips This article applies to Microsoft Excel 2007, 2010, and Office 365. View the videos listed in the Resources section for more ideas on using Excel's database functions.