Use slicers to filter data - Microsoft Support
Slicers provide buttons that you can click to filter tables, or PivotTables. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is currently displayed.
Video: Use slicers, timelines, and PivotCharts to analyze your ...
You can use Slicers and Timelines to filter your PivotTable data, and at a glance, you can see what filters are applied. To add a slicer, click a cell in your PivotTable, and the PIVOTTABLE TOOLS tab appears.
Filter data in a PivotTable - Microsoft Support
You can insert one or more slicers for a quick and effective way to filter your data. Slicers have buttons you can click to filter the data, and they stay visible with your data, so you always know what fields are shown or hidden in the filtered PivotTable.
Use Slicers to filter data - Microsoft Support
Training: When working with large amounts of data in Microsoft Excel, you can use slicers in your table to filter and view your data. Watch this online video to learn how.
Create a PivotTable to analyze worksheet data - Microsoft Support
Select a table or range of data in your sheet and select Insert > PivotTable to open the Insert PivotTable pane. You can either manually create your own PivotTable or choose a recommended PivotTable to be created for you.
Create a PivotTable timeline to filter dates - Microsoft Support
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: Click anywhere in a PivotTable to show the PivotTable Tools ribbon group, then click Analyze > Insert Timeline.
Sử dụng slicer để lọc dữ liệu - Hỗ trợ của Microsoft
Slicer cung cấp các nút mà bạn có thể bấm để lọc bảng hoặc PivotTable. Ngoài tính năng lọc nhanh, slicer còn cho biết trạng thái lọc hiện tại, giúp bạn dễ dàng hiểu chính xác nội dung hiện đang được hiển thị.
Change the style of your PivotTable - Microsoft Support
Create a PivotTable to analyze data in multiple tables. Change the data layout of a PivotTable. Add, change, find, or clear conditional formats
Slicers in Power View - Microsoft Support
Power View slicers act much like slicers in Power Pivot in Excel. You can add more than one slicer to your report, and the filtering effects of all slicers are combined. Slicers filter each other.
Change the source data for a PivotTable - Microsoft Support
You can change the data source of a PivotTable to a different Excel table or a cell range, or change to a different external data source.