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.

Microsoft Excel sorts slider buttons alphabetically and numerically. Fortunately, you can add a custom sort list to sort the buttons in a more meaningful way, when necessary.

Slicers are a great tool for filtering a data set or PivotTable. Learn how to use one slicer to manipulate more than one PivotTable or PivotChart.