Use slicers to filter data - Microsoft Support
In the Insert Slicers dialog box, select the check boxes for the fields you want to display, then select OK. A slicer will be created for every field that you selected.
Sử dụng slicer để lọc dữ liệu - Hỗ trợ của Microsoft
Tạo slicer để lọc dữ liệu trong bảng hoặc PivotTable Slicer sẽ được tạo cho mọi trường bạn đã chọn. Bấm vào bất kỳ nút slicer nào sẽ tự động áp dụng bộ lọc đó cho bảng được liên kết hoặc PivotTable.
Filter data in a PivotTable - Microsoft Support
Choose the fields you want to create slicers for, and select OK. Excel will place one slicer for each selection you made onto the worksheet, but it's up to you to arrange and size them however is best …
Excel help & learning - support.microsoft.com
Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.
Create a PivotTable timeline to filter dates - Microsoft Support
Click Analyze > Insert Timeline to add one to your worksheet. 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 …
Use a screen reader to filter data in a PivotTable in Excel
Use a screen reader and keyboard shortcuts to filter data with slicers or manual filters in an Excel PivotTable.
Create and share a Dashboard with Excel and Microsoft Groups
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 Analyze > Filter > …
Slicers in Power View - Microsoft Support
Place a slicer on a sheet to filter all of the visualizations on the sheet at once. When you click an item in the slicer, all of the visualizations with related content are filtered by the item you select.
Verwenden von Datenschnitten zum Filtern von Daten
Slicer bieten Schaltflächen, auf die Sie klicken können, um Tabellen oder PivotTables zu filtern. Zusätzlich zur schnellen Filterung geben Slicer auch den aktuellen Filterstatus an, sodass Sie leicht …
Use filters and slicers to focus on specific information
Filters and slicers are controls that enable you to focus on the data that you are most interested in viewing. For example, a time filter enables you to view information for a specific unit of time.