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

In this guide, you’ll learn how to create a dynamic search box that filters data based on your input, using Excel’s built-in features and Developer tools.

A combo box's autocomplete feature linked to a lookup function creates a flexible search tool.

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.