Setup a Slicer to Sort or Filter Another Slicer for Quick Navigation
Learn how to group text or number fields to create a slicer that can sort and filter another slicer. This technique is great for slicers that contain a lot of items and are difficult to navigate.
You can create a slicer with less items that will help sort and filter the longer slicer. This technique can be used for slicer fields with text (people names, product names, etc.) or numbers (phone numbers, id numbers, account codes, etc.)
Download the file and read the article at: http://www.excelcampus.com/pivot-tables/how-to-sort-a-slicer-with-another-slicer/
Subscribe to my free email newsletter: http://www.excelcampus.com/newsletter
Видео Setup a Slicer to Sort or Filter Another Slicer for Quick Navigation канала Excel Campus - Jon
You can create a slicer with less items that will help sort and filter the longer slicer. This technique can be used for slicer fields with text (people names, product names, etc.) or numbers (phone numbers, id numbers, account codes, etc.)
Download the file and read the article at: http://www.excelcampus.com/pivot-tables/how-to-sort-a-slicer-with-another-slicer/
Subscribe to my free email newsletter: http://www.excelcampus.com/newsletter
Видео Setup a Slicer to Sort or Filter Another Slicer for Quick Navigation канала Excel Campus - Jon
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![How to Add a Search Box to a Slicer in Excel](https://i.ytimg.com/vi/95_dIb8PMpc/default.jpg)
![Using slicers with formulas in Excel | Allow users to select parameters | Excel Off The Grid](https://i.ytimg.com/vi/3LqjVgml2ZI/default.jpg)
![Learn Excel - Slicer For Two Data Sets - Podcast 2198](https://i.ytimg.com/vi/AibLsRM-QbI/default.jpg)
![Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)](https://i.ytimg.com/vi/9NUjHBNWe9M/default.jpg)
![How to Lock and Protect Individual Cells in Excel + Bonus Tips for Quick Setup](https://i.ytimg.com/vi/vTGeVgzxzAs/default.jpg)
![How to Combine Excel Tables or Worksheets with Power Query](https://i.ytimg.com/vi/HcfKOusOJhA/default.jpg)
![Top 15 Advanced Excel 2016 Tips and Tricks](https://i.ytimg.com/vi/PU8ACyYxJBk/default.jpg)
![Excel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)](https://i.ytimg.com/vi/UsdedFoTA68/default.jpg)
![Excel Dashboard - Plan vs Actual Variances - FREE Download](https://i.ytimg.com/vi/_PlBRWc0RlI/default.jpg)
![Learn Excel - Sync Slicers from Different Data Sets - Podcast 2104](https://i.ytimg.com/vi/1fOeIS-UpNU/default.jpg)
![Create Multiple Pivot Table Reports with Show Report Filter Pages](https://i.ytimg.com/vi/sjnUThSQ8hk/default.jpg)
![Excel Array Formulas Explained with MIN and IF Functions (Part 1 of 5)](https://i.ytimg.com/vi/I23Cy8FkMLY/default.jpg)
![How to Filter Pivot Tables for Month-to-Date MTD Comparisons with Slicers](https://i.ytimg.com/vi/DGwkAi4hRY4/default.jpg)
![25 Advanced Excel Chart Tips and Tricks](https://i.ytimg.com/vi/FvWdbvHEadc/default.jpg)
![Force Excel Slicers to Single Select Using These Crafty Tricks](https://i.ytimg.com/vi/T7UUgYN-7Lo/default.jpg)
![Interactive Excel Project Management Dashboard - FREE Download](https://i.ytimg.com/vi/5qtSioTE2wY/default.jpg)
![Excel Slicer Formatting](https://i.ytimg.com/vi/KEZzGu1MIY4/default.jpg)
![7 Clever Excel Custom Formatting Tricks (Advanced)](https://i.ytimg.com/vi/IO1oDfEFfQ8/default.jpg)
![Get Unique List from a Table to Populate a Dropdown List](https://i.ytimg.com/vi/ZanRAnbh30M/default.jpg)
![How to Merge Tables with Power Query: VLOOKUP Alternative](https://i.ytimg.com/vi/73T7isNVH_w/default.jpg)