If you are a Microsoft Excel power user then you have probably been using pivot tables for quite some time. Pivot table functionality is among some of the most powerful features within Excel because it can turn a flat table of raw data into a powerful database with the ability to move data from rows to columns and to the page by position with just a couple of clicks of a mouse. In addition, a good pivot table user can do some interesting things such as creating formulas that exist within the pivot table or taking a field such as dollar sales and creating a dollar share with that same field. If you are a really creative Excel pivot table user then you have probably created various templates using, but hiding, pivot tables so that you can arrange your data in many creative ways such as a dashboard, a controlled tabular report or even a combination of both of these elements.
In Excel 2010 a new functionality was added… Data Slicers. Slicers are one-click filtering controls that narrow the data shown in PivotTables and PivotCharts. Slicers can be used interactively to display data changes when you apply filters. For example, you can create a PivotTable report or chart that shows sales by year, and then add a Slicer that represents promotions. The Slicer is added as an extra control in the PivotTable or chart, and lets you quickly select criteria and instantly show the changes. You could also embed the breakdown by promotion in the report itself, by including the field in the row or column heading, but Slicers do not add extra rows to the table, they only provide an interactive view into the data.
Data Slicers
The new Excel Data Slicer functionality really opens up how you can build a more intuitive templates that clearly identify which items are included or excluded from a particular pivot table view. Formerly, using only pivot table fields it was not as easy to see which items were included or excluded from a particular filtered view. In the following example it is easy to see which sizes, type, product category, flavors, geography and periods are included in the data portrayed on the left side of the report.
Data Slicers are available only in Excel 2010 and Excel 2013 and are very easy to use and create as the following steps will demonstrate:
- Create your pivot table as you normally would do
- Layout a consolidated report such as the following –
- Click anywhere in the pivot table and click on the Pivot Table Options (Excel 2010) or Analyze (Excel 2013), and click on the Insert Slicer option –
- Place a checkmark beside each pivot table element you want to have displayed as a Slicer, by left clicking in the box to the left of the element and click the OK button when done –
- Excel will insert a Slicer for each of the pivot table elements you placed a checkmark next to –
- The Slicers can be moved by dragging them around on the screen and grabbing the handles on the sides, top, bottom or corner to change their size. You will note in the example above that all of the elements for each Slicer are highlighted so the data display on the left has no filter and is displaying all data for all geographies, time, sizes, type and product category at one time.
- By clicking on the following criteria – Sizes = 16, Type = Half & Half, Geography = Denver and Time= Latest 52 Weeks…the data will be filtered now to display those specific settings, and you will see only two items in the Product Category are now highlighted –
Timelines
These days everybody boasts of a massive spreadsheet. But almost no one needs all the data at same time. We are always filtering data for the latest quarter, 6 months starting Mother’s day or 8 weeks from November 1st etc. Of course, you can use auto-filter and select all the dates. But it is a pain. Thanks to Timelines, filtering for dates is a breeze. You can add timelines for any date column in a pivot table / pivot chart. I am sure your internal clients & bosses will love it.
Really, the Timeline (only available in Excel 2013) is just another type of Slicer that only operates on date formatted fields. You can set up and use the Timeline Slicer in the following manner:
- Set up your pivot table and Data Slicers in a manner outlined above
- Click anywhere in your pivot table and click on Pivot Table Options (Excel 2010) or in Analyze (Excel 2013), and click on the Insert Timeline item in the Filter section of the ribbon. If you have pivot table fields that are date formatted those date fields will be presented as optional fields to create a Timeline from
- Select the date formatted field you wish to make a Timeline from; click on the box to the left of the field to place a checkmark and then click on the OK button –
- Excel 2013 Will Pl. a timeline Data Slicer onto your spreadsheet and you can move it around and change the size of it as we discussed above and the Data Slicer section. When the timeline is displayed all available fields are highlighted, however you can adjust and select only the periods that you want to display in the pivot table report.
- The Timeline slicer can be viewed in year, quarter, months or day aggregations to limit the data viewed in the pivot table report. For the purposes of this example I will select the month option. In the following example we have filtered on one market and set the geography slicer and one product in the product slicer, and we have selected the months of May and June. We can control the slicer by grabbing the ends of the slide along the timeline so we could click on May and then grab the right end of the slider and slide it to June –
As you can quickly see, the Microsoft Excel Data Slicer and Timeline filter functionality provide a powerful user interface to allow users with little to no pivot table experience to quickly and intuitively filter on the data they want to see.
Insight, Information & Consulting Services, Inc. is a data visualization consulting firm that helps its Consumer Package Goods clients better “see” their data. We deliver data visualization tools from cost-effective Excel & PowerPoint templates to a turnkey data visualization tool that will allow your users to see their data in PowerPoint templates using only a web browser. For more information, please visit our website at www.insightinformation.net or call Rick Pensa at 770-425-4243.
Hi
I’m already using the Slicers. I have not problems using it. My question is: Is there a Way to ad in a cell, all the selected items in a Slicer? Let me gave you a example:.
My pivot table is showing the sales by country by year.
One slicer: Country
Second Slicer: Year
If I’m selecting severals Country, and Severals Years, and then, I’m sending this file by email to a client: This client need to Watch all the slicer to see what has been selected to get the result in the PivotTable.
I’m looking for a add-in, or somethings else to be able to write down in a cell each selected items from the Slicer.
Can you help me?
Sorry, English is not my first languages.
Thank you for your help
Marc
Cheers! A good amount of content.
http://canadianonlinepharmacynnm.com/
canadian pharmacies online prescriptions
aarp approved canadian online pharmacies
pharmacy drug store
canadian viagra
Many thanks. Awesome information.
http://www.canadianpharmacymsn.com/
canadian prescription drugstore top rated canadian pharmacies online best online canadian pharcharmy aarp approved canadian online pharmacies
canadian pharmacies that ship to us
top rated canadian pharmacies online
prescription drugs prices
canadian drugs without prescription
cheap prescription drugs
no 1 canadian pharcharmy online
Lovely write ups. Many thanks.
http://talahicc.com/
best non prescription online pharmacies canadian pharcharmy us pharmacy no prior prescription northwest pharmacy
online pharmacy usa
discount prescription drugs online
canadian prescription drugstore
canadian viagra
online canadian pharmacy
prescription without a doctor’s prescription
Thanks a lot, Valuable information!
http://canadianonlinepharmacynnm.com/
canadapharmacy com canada drugs online overseas pharmacy forum canada online pharmacies
mexican online pharmacies
buy drugs online
canada online pharmacies
canadian pharmacy online canada
drugs from canada
mexican pharmacies shipping to usa
Very good info. Regards!
http://canadianpharmacyntx.com/
cheap prescription drugs online canadian pharcharmy canadian pharmacy uk delivery canadian online pharmacy
canadian drug
pharmacy online mexico
walmart pharmacy price check
canadian prescription drugs
best canadian online pharmacy
top rated online canadian pharmacies
Thank you, Quite a lot of knowledge!
http://canadianpharmaciescubarx.com/
canada pharmacy online orders canadian viagra pharmacies near me canada pharmacy
prescription drugs without prior prescription
pharmacy tech
pharmacy prescription
canada pharmacies online prescriptions
highest rated canadian pharmacies
canadian pharmacy reviews
Thanks, Awesome information!
http://canadianpharmacyntx.com/
medication costs canadian pharmacies online canadian meds london drugs canada
canadian pharmacies online
get prescription online
canadian drugs
online pharmacies canada
drugstore online
drugstore online
Cheers! Lots of data.
http://www.canadianpharmacymsn.com/
canada pharmacies online prescriptions canadian pharmacies online discount prescription drug northwestpharmacy
canadian pharmacy online
pharmacy prices
canadian discount pharmacy
online pharmacy canada
mexican pharmacies
top rated online canadian pharmacies
Helpful write ups. Thanks a lot!
http://canadianpharmaciesnnm.com/
canadian drugs canadian pharmacies-24h mail order pharmacy northwest pharmacy
buy prescription drugs from canada
canada meds
northwest pharmacy canada
canada online pharmacies
canadian pharmacy viagra brand
canadian pharmacies
Truly a good deal of wonderful info!
http://canadianpharmacyntx.com/
canadian pharmacy no prescription needed canada drug canadian pharmacy reviews mexican pharmacies shipping to usa
top rated online canadian pharmacies
top rated online canadian pharmacies
legitimate canadian mail order pharmacies
canada drugs online
prescription prices comparison
best canadian mail order pharmacies
Nicely put. Kudos.
http://canadianpharmacysilo.com/
online drugs canada pharmaceuticals online drug costs london drugs canada
best online pharmacy
drug price
online prescription drugs
prescription drugs prices
online discount pharmacy
board of pharmacy
Wonderful forum posts. With thanks.
https://nicktambone.com/
canadian prescription drugs canada drugs canada pharmacies online pharmacy canada online pharmacies
canadian online pharmacies prescription drugs
canada online pharmacies
pain meds online without doctor prescription
visit poster’s website
mexican pharmacy online
canada drug
Thanks, I value this!
http://canadianpharmacyntx.com/
best online pharmacies no prescription canadian online pharmacy canadian pharmacy viagra canadian pharmacies online
pharmacies in canada
canadian rx pharmacy online
prescription without a doctor’s prescription
onlinecanadianpharmacy.com
online pharmacy no prescription
canadian pharmacy reviews
Truly lots of very good tips.
https://nicktambone.com/
drugs from canada northwest pharmacy buy prescription drugs online canadian pharmacy online
canada pharmacies prescription drugs
canadian online pharmacies prescription drugs
ed meds online
canadian pharmacy no prescription
ed meds online
canada pharmacies
Nicely put. Thanks a lot.
http://canadianpharmacysilo.com/
pharmacy near me canada pharmaceutical online ordering canada drugs canada pharmaceuticals online
walmart pharmacy price check
pharmacy price compare
canada pharmacy online orders
online pharmacies
trusted overseas pharmacies
legitimate online pharmacies
You said it nicely.!
http://canadianpharmaciesnnm.com/
canada pharmacies mexican pharmacies shipping to usa cialis online canadian online pharmacies
canadian rx pharmacy online
best price prescription drugs
mexican pharmacies
us pharmacy no prior prescription
canadian pharmacy reviews
canadian viagra
You’ve made your stand extremely nicely..
http://canadianonlinepharmacynnm.com/
drug price top rated canadian pharmacies online onlinecanadianpharmacy.com mexican pharmacies shipping to usa
canada pharmacy
online discount pharmacy
pharmacies near me
cialis online
pharmacy online
canada drug pharmacy
Thanks! Loads of content!
http://canadianonlinepharmacynnm.com/
online pharmacy without a prescription canadian pharmacies that ship to us prescription cost comparison northwestpharmacy
cialis online
prescription pricing
canadapharmacy com
highest rated canadian pharmacies
online pharmacy no prescription
pain meds online without doctor prescription
Thank you! A good amount of posts.
http://canadianpharmaciescubarx.com/
prescription drug cost canadian cialis onlinecanadianpharmacy.com top rated canadian pharmacies online
mexican pharmacies online
costco pharmacy pricing
canadapharmacyonline com
online pharmacy without prescription
overseas pharmacies
cheap prescription drugs
Whoa tons of valuable material.
http://canadianpharmacyntx.com/
canadian pharmacy 365 online pharmacies canada pharmacy prescription canadian pharmaceuticals online
prescription drugs canada
online pharmacy
canadian prescriptions
canadian viagra
prescription drugs canada
canada pharmacy online no script
Seriously a lot of superb facts.
http://www.canadianpharmacymsn.com/
pharmacy drug store mexican pharmacies shipping to usa best canadian pharmacies northwestpharmacy
best price prescription drugs
pharmacies near me
prescription pricing
best online pharmacy stores
buy online prescription drugs
buy prescription drugs canada
Awesome information. Regards.
http://canadianpharmaciescubarx.com/
northwestpharmacy canadian pharmacies that ship to us candrugstore com canadian pharmacies
discount prescription drugs online
mexican pharmacies
prescription drug
drug prices comparison
best online canadian pharcharmy
canadian pharmacies online prescriptions
Well voiced really! .
http://www.canadianpharmacymsn.com/
online pharmacy without prescription online pharmacies canada prescription online canadian pharmacies that ship to us
online pharmacy canada
canadian drugstore online
best canadian mail order pharmacies
pharmacy near me
no prior prescription required pharmacy
prescription drugs without prior prescription
Many thanks. Numerous information.
http://canadianpharmacymim.com/
discount pharmacy online canadian drugs pharmacy online canada pharmaceuticals online
northwestpharmacy
canadian discount pharmacy
canada pharmacy no prescription
pharmacies in canada
canadian prescription
canadian pharmacies without prescriptions
Amazing advice. Many thanks.
http://www.canadianpharmacymsn.com/
canada pharmacy no prescription canadianpharmacy prescription drugs prices london drugs canada
canada drugs online
canadian online pharmacies
online discount pharmacy
walmart pharmacy price check
pharmacy tech
medical information online
Regards! Useful stuff.
http://www.canadianpharmacymsn.com/
canadian pharmacies top best canadian pharmacy online canadian online pharmacies prescription drugs canadian pharmacies
online discount pharmacy
top rated online canadian pharmacies
safe canadian online pharmacies
approved canadian pharmacies online
canadian pharmacy uk delivery
legitimate canadian mail order pharmacies
Thanks a lot. Terrific information.
http://canadianpharmaciescubarx.com/
trust pharmacy canada canadian online pharmacy online discount pharmacy canada pharmaceutical online ordering
no prior prescription required pharmacy
canada drugs pharmacy
online pharmacy no prescription
online canadian pharmacies
discount prescription drug
buy prescription drugs online
Nicely put. Cheers!
http://canadianpharmacymim.com/
prescription drugs online without doctor canadian online pharmacies no prescription pharmacies canada online pharmacies
online drugstore
prescription prices comparison
canadian pharmacy no prescription needed
cialis canadian pharmacy
canada pharmacy no prescription
<a href="http://jesserubenfeld.net/?s=+With+thanks.+Numerous+information%21++http%3A%2F%2Fwww.canadianpharmacymsn.com%2F+buying+prescription+drugs+canada+online+pharmacies+canada+pharmacy+online+store+%5Burl%3Dhttp%3A%2F%2Ftalahicc.com%2F%5Dcanadian+pharmacies+without+an+rx%5B%2Furl%5D+%0D%0Acanadian+online+pharmacies+%0D%0Acanadian+drug+%0D%0Acanadapharmacyonline+com+%0D%0Amy+canadian+pharmacy+%0D%0Acanada+pharmacy+online+no+script+%0D%0Acanadian+discount+pharmacy&s=+%0D%0AWith+thanks.+Numerous+information%21++%0D%0Ahttp%3A%2F%2Fwww.canadianpharmacymsn.com%2F+%0D%0Abuying+prescription+drugs+canada+online+pharmacies+canada+pharmacy+online+store+%5Burl%3Dhttp%3A%2F%2Ftalahicc.com%2F%5Dcanadian+pharmacies+without+an+rx%5B%2Furl%5D+%0D%0Acanadian+online+pharmacies+%0D%0Acanadian+drug+%0D%0Acanadapharmacyonline+com+%0D%0Amy+canadian+pharmacy+%0D%0Acanada+pharmacy+online+no+script+%0D%0Acanadian+discount+pharmacy”>candrugstore com
You said it adequately..
http://www.canadianpharmacymsn.com/
pharmacy canada canada online pharmacies buy prescription drugs canada canada pharmacy
canadian online pharmacy
prescription pricing
no 1 canadian pharcharmy online
discount pharmacy online
rx pharmacy
best online pharmacy stores
Truly quite a lot of very good data!
https://nicktambone.com/
online pharmacies no prescription canada pharmaceutical online ordering the canadian pharmacy canadian pharmacy online
safe canadian online pharmacies
rx online
online canadian pharcharmy
prescription cost
pharmacy online mexico
canadian drug store
Incredible quite a lot of terrific advice!
http://canadianpharmaciesnnm.com/
canadian pharmacies online prescriptions canada pharmacy pharmacy tech canadian cialis
top rated online canadian pharmacies
canadian cialis
trust pharmacy canada
canada meds
canadian drugs
prescription drugs canada
Valuable data. Kudos.
http://canadianpharmacymim.com/
pharmacy online canadian pharmaceuticals online online pharmacies top rated canadian pharmacies online
candrugstore com
canada meds
canadian pharmacy reviews
pharmacy prices
pharmacy without dr prescriptions
canadian drugstore reviews
Info clearly applied!!
http://canadianpharmacysilo.com/
prescription prices comparison canadian pharmacies without an rx canada meds canadian pharmacies-24h
canadian pharmacy meds
top rated canadian pharmacies online
prescription drug price comparison
canadian meds
pharmacy online
24 hour pharmacy
Nicely put, Cheers!
https://nicktambone.com/
buy prescription drugs canada canadian pharmacy canadian meds canadian pharmacy online
prescription drugs online without
canada pharmacies online
canadian pharmacy without prescription
canadian pharmacy online canada
prescription cost
discount prescription drugs online
Thanks a lot, Quite a lot of info!
http://canadianonlinepharmacynnm.com/
canadian online pharmacy reviews canadian drugs drugs online canadian pharmacies online
the canadian pharmacy
canadian viagra
prescription drugs without prior prescription
pharmacies in canada
no 1 canadian pharcharmy online
canada drugs pharmacy
Wow all kinds of amazing knowledge.
http://www.canadianpharmacymsn.com/
online canadian pharcharmy aarp approved canadian online pharmacies approved canadian pharmacies online canadian drugs
onlinecanadianpharmacy.com
drugs for sale
drug prices comparison
prescription pricing
canadapharmacy com
pharmacy without dr prescriptions
This is nicely said! .
http://canadianpharmacyntx.com/
prescription drug assistance canadian drugs canadian pharmacy canadian pharcharmy
no prescription pharmacies
medication costs
overseas pharmacies
canadian pharmacy viagra
trusted overseas pharmacies
discount prescription drugs online
Regards! Lots of facts!
http://canadianpharmaciescubarx.com/
cialis canadian pharmacy canada drug canadian drug store canada drugs
no prescription pharmacy
web medical information
international pharmacy
canadian family pharmacy
rx price comparison
king pharmacy
Incredible a lot of wonderful tips.
http://talahicc.com/
cheap canadian drugs canadian pharmacies online approved canadian pharmacies online canadian online pharmacy
pharmacy online
canadian pharmacy viagra brand
prescription drugs prices
canada meds
pharmacy canada
mexican online pharmacies
Regards! Excellent information!
http://canadianpharmacysilo.com/
pharmacy online mexico northwest pharmacy canadian drug canadian pharcharmy
best canadian prescription prices
prescription online
online canadian pharmacy
global pharmacy canada
pharmacy cost comparison
canadapharmacyonline.com
You mentioned it really well.
http://canadianpharmaciescubarx.com/
prescription without a doctor’s prescription canadian pharmacies that ship to us canadian pharcharmy online canadianpharmacy
meds online
online pharmacy
best online pharmacy
online pharmacy no prescription needed
canadian pharmacy online
canadian pharmacies
Incredible plenty of excellent info.
https://nicktambone.com/
compare prescription prices canadian pharmacies that ship to us best online pharmacies canada north west pharmacy canada
canadian pharmacy no prescription
canadian drug store
canadian pharmacy meds
canadian pharmacy
canadianpharmacy
canadian online pharmacies prescription drugs
Many thanks! Lots of advice!
http://www.canadianpharmacymsn.com/
discount drugs online pharmacy canadian pharmacies-24h best non prescription online pharmacies london drugs canada
highest rated canadian pharmacies
northwest pharmacy
best online international pharmacies
canadian discount pharmacy
us pharmacy no prior prescription
drugs from canada
Kudos! I enjoy it.
http://canadianpharmaciesnnm.com/
canadian pharmacies that are legit canadian drugs canadian drugs canada pharmacy online
pharmacy online
canada drugs online
prescription pricing
drug stores near me
best online canadian pharcharmy
prescription online
With thanks! Excellent stuff!
http://talahicc.com/
best online pharmacy stores canada drugs online rx online canadian pharmacies that ship to us
cheap drugs online
medication costs
canadianpharmacy
canadian pharmacy uk delivery
canadian drugstore
prescription drug assistance
Helpful material. Regards!
http://www.canadianpharmacymsn.com/
cheap prescription drugs canadian pharmacies that ship to us canada online pharmacies northwestpharmacy
top rated online canadian pharmacies
drug price
pharmacy price comparison
canada pharmacy online reviews
best online international pharmacies
prescription cost comparison
Helpful knowledge. Thanks a lot.
http://canadianpharmacymim.com/
pharmacy prices canadian online pharmacies canadian pharmacy viagra london drugs canada
drugs online
canadian prescription drugstore
pharmacy prices
no 1 canadian pharcharmy online
best online pharmacies canada
overseas pharmacies
Effectively spoken genuinely! .
http://canadianpharmaciesnnm.com/
drug price canadian viagra canadian drug store canadian pharmacies online
web medical information
online pharmacy
trusted overseas pharmacies
canada pharmacies prescription drugs
canadian online pharmacy
canada pharmacies online
You suggested this really well.
http://canadianpharmaciesnnm.com/
canadian prescriptions canadian cialis canadian pharmacies shipping to usa online pharmacies canada
reputable canadian mail order pharmacies
prescription drugs online without
canada pharmacies online prescriptions
us pharmacy no prior prescription
best online pharmacies canada
canadian pharmacy viagra brand
You stated this perfectly.
http://canadianpharmacyntx.com/
online drugstore canadian pharmaceuticals online canada drug prices canada online pharmacies
canadian prescription drugstore
online pharmacy usa
safe canadian online pharmacies
canada drugs
online pharmacy without a prescription
buy cialis
Many thanks. Quite a lot of write ups!
http://canadianpharmacymim.com/
canadian pharmacy uk delivery canadian pharmacies-24h discount pharmacy canada pharmaceuticals online
canadian online pharmacies prescription drugs
pharmacy price comparison
cheap canadian drugs
top rated online canadian pharmacies
canadian drug stores online
overseas pharmacy forum
Nicely put. Thanks.
http://canadianonlinepharmacynnm.com/
prescription drugs online without canada pharmacy online pharmacies near me canada pharmaceuticals online
global pharmacy canada
canadian prescriptions
prescription drugs without doctor approval
no prescription pharmacy
northwestpharmacy
canada pharmacies prescription drugs
Incredible tons of amazing material!
http://canadianpharmaciesnnm.com/
online rx pharmacy canadian pharmacies that ship to us canadian pharmacy king canada online pharmacies
canadian family pharmacy
no prior prescription required pharmacy
pharmacies in canada
online pharmacy no prescription needed
canadian pharma companies
cheap canadian drugs
Amazing quite a lot of useful advice.
http://canadianpharmacysilo.com/
mexican pharmacies shipping to usa northwestpharmacy drug stores near me aarp approved canadian online pharmacies
online canadian pharmacy
canada drug
canada drugs online
canada pharmacies online
get prescription online
pharmacy price compare
You revealed it exceptionally well.
http://canadianpharmaciesnnm.com/
canadian pharcharmy online canadian pharcharmy discount pharmaceuticals top rated canadian pharmacies online
king pharmacy
buy prescription drugs without doctor
canadian cialis
candrugstore com
mexican online pharmacies
canadapharmacyonline com
You actually reported it very well.
http://canadianpharmacysilo.com/
canadian pharmacy viagra canada pharmaceuticals online reputable canadian mail order pharmacies canada drug
buying prescription drugs canada
canada drug
drugs for sale
canadianpharmacy
mail order pharmacy
cialis online
Truly quite a lot of helpful facts!
https://nicktambone.com/
drugs without prescription mexican pharmacies shipping to usa canadian pharmacy without prescription canadian cialis
most reliable canadian pharmacies
no prior prescription required pharmacy
pharmacy price comparison
prescription drugs online without doctor
pharmacies near me
canadian drug stores online