Scribd
Upload
541 views

Slicers in Excel - Easy Excel Tutorial

Slicers in Excel

Uploaded by

Jamalodeen Mohammad
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
541 views

Slicers in Excel - Easy Excel Tutorial

Slicers in Excel

Uploaded by

Jamalodeen Mohammad
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

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

You might also like