Needless to say, Slicers have become quite popular because of their ease of use and visibility. The buttons that represented the chosen categories would then remain colored to make it easy to understand which categories of data were visible as illustrated below: Once the slicer was visible, all you needed to do was click the various buttons in the slicer to only display the values for the categories desired. All you had to do was click the Insert Slicer command from the Pivot Table Tools/Analyze Tab, select the fields you wished to filter as illustrated below: While these were easy enough to use, it wasn’t obvious what criteria was being used after the filter was applied.Īfter you assembled a Pivot Table in the 2010 version, you could then add Slicers that made it easier and more intuitive to filter data. So, after the user had selected the drop down menu, the check boxes in the filter menu could be used to narrow down which data values were then displayed in the Pivot table. These filters were based on menus that had to be accessed from drop down menus as illustrated below: So, what is a slicer? Simply put, it is a tool used to filter data that is more visually oriented and easier to use than the traditional data filters that have been a part of Pivot Tables since day one. ![]() ![]() So, this blog is about a feature that was added to Pivot Table tools in the 2013 version – Timeline Slicers.įirst, let’s back up a bit to the 2010 version, where Slicers were first introduced. This tool has been a part of Excel for a long time and like many other features in Excel it has been improved with each subsequent release. Among the most popular tools is the ability to create and work with data in Pivot tables. Excel has always had a lot of robust tools that allow users to analyze their data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |