How to add a filter to the interface in Excel The dropdown and search filters are good for you, but they’re not great for others who might be viewing the information in your pivot table.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.