How to use Slicers in Excel to filter data efficiently

Download PC Repair Tool to quickly find & ready Windows errors automatically

Microsoft Excel Slicers are easy-to-use visual controls added to Excel that allows to chop-chop and easily filter data in an interactive way by selecting values from a listing. The slicer characteristic provides the user with a rich visualization of the pivot table on which dynamic segmenting & filtering tin exist applied to display the required data. Using the search filter, the time taken to search a record in the big data set is significantly reduced.

A slicer typically displays the components:

• Filtering push that is not selected indicates that the item is not included in the filter.
• Filtering push button that is selected indicates that the item is included in the filter.
• A Clear Filter button removes the filter past selecting all items in the slicer.
• Slicer displays the following components:
• Slicer header indicates the category of the items in the slicer.
• Edge moving and resizing controls permit you to modify the size and location of the slicer.
• Whorl bar enables scrolling when in that location are more items than are currently visible in the slicer.

How to apply Slicers in Excel

1. Click anywhere in the table or PivotTable.
2. On the Home tab, get to Insert > Slicer.
3. In the Insert Slicers dialog box, select the checkboxes
4. A slicer will exist created for every field that you lot selected.
5. Clicking whatever of the slicer buttons will automatically apply that filter to the linked table or PivotTable.
6. To select more than one item, agree Ctrl, and then select the items that y'all want to evidence.
7. To clear a slicer's filters, select Clear Filter Delete in the slicer.

If you want to connect a slicer to more than 1 PivotTable, go to Slicer > Report Connections > check the PivotTables to include, and then select OK.

KeyTips to accomplish Slicer in Excel: Alt + N + SF

Slicer can be establish nether the Insert tab in the Ribbon. A slicer acts as a study filter, so you can hook it up to a PivotTable, PivotChart, or CUBE role to filter them and create an interactive report.

In the example illustrated below, there is a slicer in three different Countries. I or more than or all countries can be selected. This would reflect a filtered data corresponding to the number of selected Countries.

In contrast, selecting a tile in a slicer in Excel is like shooting fish in a barrel – information technology takes only one click.

To select multiple tiles, apply combinations of ctrl+click, shift+click, or click+elevate.

Using slicers to create your reports will invite interaction, enabling you and your collaborators to spend less fourth dimension sifting and more fourth dimension analyzing. Slicers also works with Excel Services and Excel Web App too, so you lot tin can piece of work and share on the spider web as well.

Promise this helps.

The author Vasu Jain is studying Information science at the University of Southern California, Los Angeles. He was a Microsoft Most Valuable Professional in Windows. He blogs at WindowsVJ.com and tin can be contacted on Twitter @vasujain.

Source: https://www.thewindowsclub.com/use-slicers-microsoft-excel-2010-efficiently-filter-data

Posted by: skillernwidee1984.blogspot.com

Share this post