What are Excel Slicers?
In this step-by-step tutorial, you will learn what Excel Slicers are and how to create slicers in Excel.
Slicers in Excel are filters used along with excel tables or Excel pivot tables over a large amount of data. Not just filtering out data, slicers also help you with an easy understanding of the information being extracted and displayed on the screen. Microsoft Excel Slicers are compatible with Windows and Mac operating systems. Let us understand how to implement Slicers in Excel.
First, click inside a cell and press Ctrl+t to convert the spreadsheet data into a table. To implement the slicers in Excel you must execute this command. After pressing Ctrl+t, you will be asked to convert the data into a table. Do so by accepting the offer.
Start implementing or inserting slicers into the Excel spreadsheet
A. First select all the data in the spreadsheet.
B. Click the Insert menu.
C. In the Insert ribbon, you can see the Filters group. In the Filters group, select the Slicer option.
After clicking the Slicer option, you will see the Insert Slicers dialog box in which you have to specify the filters you want to apply. The dialog box allows you to select multiple options. For now, select Employee Name, Zone, Designation, and Department columns, as shown in the following figure. Press the OK button after making your selections.
You will see four slicers. Drag the headers of these slicers and arrange them according to the following figure.
Let's use these slicers to understand how they are helpful in filtering data. Suppose you want to get a list of employees who are working in the East zone.
Simply click the East entry in the Zone slicer as indicated in the following figure. The data in the spreadsheet will be filtered to show only those employees who are working in the East zone.
You can apply more filters to this output to get your desired dataset. For example, click the IT Support entry in the Department slicer and you will see only those employees who are working in the East zone and are serving in the IT Support department. The rest of the data from the spreadsheet will vanish from your screen.
Each slicer has a Multi-Select option in its header. As the name implies, this option is helpful in selecting multiple choices from a slicer. Let's see how it works.
In the Zone slicer, click the Multi-select icon to enable this option.
Then, click the West zone entry. Enable this option for the Designation slicer and select Manager, Senior, and Trainee options.
Next, enable the multi-select option for the Department slicer, and select Analytics, HR, and IT Support departments. The spreadsheet data is filtered simultaneously to reflect your selections as you select these options. The final output of these selections is depicted in the following figure.
Get the Excel 2022 Book from Amazon
