Interactive Guide The interactive guide () is an Excel file that contains instructions on how to use slicers. You could consolidate all of these reports into one sheet and use a slicer to allow the user to see different views (slices) of the same report. Slicers can also greatly condense your file size.įor example, let's say you have a workbook with a lot of tabs, and each tab contains a similar report for each region, product, category, etc. They are very easy to use and make your report more interactive. However, users and consumers of your reports will really enjoy using slicers. Basically, slicers do the same thing as filtering a PivotTable using the Filter drop-down menus.
They also serve as a visual reference that allow you to see what filters are currently set in the PivotTable. Video Watch full screen or on What's a Slicer? Slicers were introduced in Excel 2010, and allow you to quickly filter a PivotTable or PivotChart with the click of a button. You can use this if you are distributing a file that contains slicers, and want to provide instructions to your users. This post contains a video and interactive guide on how to use slicers ().
(Slicers are available for pivot tables but not regular tables in Excel for Mac 2016.) To add a slicer to a table, with your cursor already somewhere in the table, head to the Design ribbon.
