Premium Excel Slicer Tutorial: How to Filter and Sort Top/Bottom 5
Excel has many different tools that can be made more efficient or optimized simply by combining different concepts, tools or functions. Of course, there is no exception when it comes to Excel slicers. By default and out of the box, Excel slicers are made to provide you with the option to filter any field within a pivot table or a standard table using a visual selection tool. This tool allows the user to select any value and will then filter your entire pivot table or table by the value selected (note: you can also select multiple records for any given slicer as well). I will mention that unfortunately, out of the box, Excel slicers are available only in Excel 2010/2013. Let’s have a deeper look at what you are going to learn in this premium Excel slicer tutorial. (more…)