Slicers in Excel - Easy Excel Tutorial http://www.excel-easy.com/examples/slicers.
html
Excel Easy
#1 Excel tutorial on the net Excel Introduction Basics Functions Data Analysis VBA 300 Examples Ask us
Slicers
Excel 2010 makes it possible to insert slicers to quickly and easily filter pivot tables. However, using the report
Chapter
filter gives the exact same result.
Below you can find a two-dimensional pivot table. Go back to Pivot Tables to learn how to create this pivot table. Pivot Tables
Learn more, it's easy
Group Pivot Table Items
Multi-level Pivot Table
Frequency Distribution
Pivot Chart
Slicers
Update Pivot Table
Calculated Field/Item
Download Excel File
slicers.xlsx
Follow Excel Easy
1 of 4 08-11 06:45 PM
Slicers in Excel - Easy Excel Tutorial http://www.excel-easy.com/examples/slicers.html
To insert a slicer, execute the following steps.
1. Click any cell inside the pivot table. The PivotTable Tools contextual tab activates.
2. On the Options tab, insert a slicer.
3. Check Category and click OK.
2 of 4 08-11 06:45 PM
Slicers in Excel - Easy Excel Tutorial http://www.excel-easy.com/examples/slicers.html
4. For example, Click Fruit to only show the fruit exported to each country.
Note: notice how the report filter changed to Fruit. Hold down CTRL to include fruit and vegetables.
3 of 4 08-11 06:45 PM
Slicers in Excel - Easy Excel Tutorial http://www.excel-easy.com/examples/slicers.html
Start Download
1) Click to Begin 2) Download App 3) Get 100s of Free Books & Readers
Start Download
Sewage Sample Filtration
Class 1 to Class 12
Vodafone Diwali Offer
Learn PredictiveAnalytics
Invest Smartly in Market
Download a Free Audiobook
Watch Free Videos
Salary & Payroll Software
Do you like this free website? Please follow us on Google+
Learn more about pivot tables, use the side menu >>
Go to Top: Slicers | Go to Next Chapter: Tables
COPYRIGHT (C) 2010-2015 WWW.EXCEL-EASY.COM. ALL RIGHTS RESERVED.
EXCEL 2010 TUTORIAL | HOW TO EXCEL | MICROSOFT EXCEL 2010 | EXCEL MACRO
4 of 4 08-11 06:45 PM
