A slicer will be created for every field that you selected. Clicking any of the slicer buttons will automatically apply that filter to the linked table or PivotTable.

Slicers and Timelines allow you to quickly filter your PivotTables and PivotCharts so you can see just the information that's meaningful to you. Select any PivotTable and go to PivotTable …

Learn about the many ways to create a table in an Excel worksheet, and how to clear data, formatting, or table functionality from a table in Excel. Discover more in this video.

Much like a slicer for filtering data, you can insert a Timeline one time, and then keep it with your PivotTable to change the range of time whenever you like. Here’s how:

How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

With Power Query (known as Get & Transform in Excel) and Power Pivot in Excel, you'll spend less time manipulating data, and more time driving impact. Watch this 2-minute video to learn …

In Excel, use slicers and other ways to filter large amounts of PivotTable data to show a smaller portion of that data for in-depth analysis.

Use a screen reader and keyboard shortcuts to filter data with slicers or manual filters in an Excel PivotTable.

Create a PivotChart based on complex data that has text entries and values, or existing PivotTable data, and learn how Excel can recommend a PivotChart for your data.