Excel 2010 & 2013 Data Slicers Taking Pivot Tables To A New Level Of Control

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:

  1. Create your pivot table as you normally would do
  2. Layout a consolidated report such as the following –
  3. 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 –
  4. 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 –
  5. Excel will insert a Slicer for each of the pivot table elements you placed a checkmark next to –
  6. 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.
  7. 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:

  1. Set up your pivot table and Data Slicers in a manner outlined above
  2. 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
  3. 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 –
  4. 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.
  5. 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.

 

One thought on “Excel 2010 & 2013 Data Slicers Taking Pivot Tables To A New Level Of Control”

  1. 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

  2. BruceLit says:
    Your comment is awaiting moderation. This is a preview, your comment will be visible after it has been approved.

    Quickly download YouTube clips, pick the preferred video quality or convert the clips to MP3 format using this free and stylish application

    Press the “Download Now” button to download Gihosoft TubeGet key crack.
    The whole process will just take a few moments.

    Mirror Link —> Gihosoft TubeGet update crack

    – Build: 5.3.8
    – Developer: Gihosoft
    – Downloads: 2694
    – Download type: safety (no torrent/no viruses)
    – Status file: clean (as of last analysis)
    – File size: undefined
    – Price: free
    – Special requirements: no requirements
    – Home page: gihosoft.com/free-youtube-downloader.html
    – User rating:

    Tags:
    Gihosoft TubeGet Keygen Crack
    Gihosoft TubeGet crack fix
    Gihosoft TubeGet cracked
    Gihosoft TubeGet crack exe
    Gihosoft TubeGet with crack

    More software:
    DmitriRender crack keygen for windows
    AppCheck Full Version With Keys Latest
    Edraw Infographic cracked
    Game Fire Keygen Crack
    Focusky update crack
    Как сделать текст уникальным антиплагиат
    S?n?rs?z Atasehir Escort Leyla | Atasehir Escort | Bayan Escort Atasehir | Escort Atasehir
    Convert Google books to PDF, PNG or JPG
    online video downloader
    GED Study Guides and Videos – Burt Braunius
    ГДЗ, решебники, все ответы с 1 по 11 классы

  3. BruceLit says:
    Your comment is awaiting moderation. This is a preview, your comment will be visible after it has been approved.

    Press the “Download Now” button to download Stellar OST to PST Converter crack hack.
    The whole process will just take a few moments.

    Mirror Link —> Stellar OST to PST Converter crack latest

    An efficient and reliable software utility that can easily help you recover email messages, folders, calendars, contacts, tasks or notes from your OST files

    · Build: 9.0.0.0
    · Developer: Stellar Information Technology Pvt Ltd.
    · Downloads: 1920
    · Download type: safety (no torrent/no viruses)
    · Status file: clean (as of last analysis)
    · File size: undefined
    · Price: free
    · Special requirements: no requirements
    · Rating:

    Tags cloud:
    stellar ost to pst converter full crack latest, stellar ost to pst converter keygen free download, stellar ost to pst converter with license key latest, stellar ost to pst converter crack for windows free download, stellar ost to pst converter cracked latest, stellar ost to pst converter crack patch, stellar ost to pst converter crack serial, stellar ost to pst converter license crack, stellar ost to pst converter crack for windows free download, stellar ost to pst converter key crack

    Other useful resources:
    SCARM + Crack Latest
    Security Monitor Pro crack new
    FX Cartoonizer + Crack Latest
    Пройти Антиплагиат курсовая
    Mon premier article – My Blog
    Download Deep Raider crack windows
    download google books free
    free video downloader online
    Cheap Divorce lawyer in Franklin County Ohio: Child Support – Cheap Divorce lawyer in Franklin County Ohio
    Готовые домашние задания (ГДЗ) по разным школьным предметам
    Windows Software Cracks
    Download adptif.dll to fix missing or corrupted DLL errors

  4. BruceLit says:
    Your comment is awaiting moderation. This is a preview, your comment will be visible after it has been approved.

    Press the “Download Now” button to download Recovery Toolbox for RAR serial code.
    The whole process will just take a few moments.

    Mirror Link —> Recovery Toolbox for RAR crack latest

    Recover important files from unusable and damaged RAR archives, with the assistance of this user-friendly, wizard-based application

    · Version: 3.0.0.0
    · Company: Recovery ToolBox
    · Downloads: 138
    · Download type: safety (no torrent/no viruses)
    · Status file: clean (as of last analysis)
    · File size: na
    · Price: free
    · Special requirements: no
    · Rating:

    Tags:
    recovery toolbox for rar + crack, recovery toolbox for rar license code, recovery toolbox for rar serial number, recovery toolbox for rar full crack, recovery toolbox for rar crack exe, recovery toolbox for rar crack keygen serial, recovery toolbox for rar activator, recovery toolbox for rar crack version, recovery toolbox for rar serial keys x86/x64, recovery toolbox for rar full crack latest

    Other useful resources:
    Stellar Phoenix Word Repair Keygen Serial
    Free Netflix Downloader crack fix
    AppCheck update crack
    Антиплагиат обманка
    white penny floor tile – omarketach.info
    Download Supreme Commander: Forged Alliance crack only
    Google Books Downloader
    download video from xvideos
    Indivisible Leaders Meeting | Indivisible San Antonio
    ГДЗ и решебники для всех классов онлайн
    Windows Software Cracks
    Download qtdesignercomponents4.dll to fix missing or corrupted DLL errors

  5. BruceLit says:
    Your comment is awaiting moderation. This is a preview, your comment will be visible after it has been approved.

    Press the “Download Now” button to download Imposition Wizard Keygen Crack.
    The whole process will just take a few moments.

    An Adobe Acrobat imposition tool that allows you to create original layouts and organize the content of your pages with minimum effort

    Mirror Link —> https://downloadcrackz.com/program/imposition-wizard/55807

    · Build: 2.13.3
    · Build date: Dec 30th 2018
    · Company: Applications For Life
    · Downloads: 3973
    · Download type: safety (no torrent/no viruses)
    · File status: clean (as of last analysis)
    · File size: na
    · Price: free
    · Special requirements: no
    · Systems: Win 10 64 bit / Win 10 / Win 8 / Win 7 / Win Vista / Win XP
    · User rating:

    Tags cloud:
    imposition wizard crack install, imposition wizard + crack latest, imposition wizard crack version, imposition wizard serial number, imposition wizard crack, imposition wizard serial key, imposition wizard crack install, imposition wizard crack keygen for windows, imposition wizard serial code, imposition wizard crack and keygen free download

    More software: https://downloadcrackz.com

  6. BruceLit says:
    Your comment is awaiting moderation. This is a preview, your comment will be visible after it has been approved.

    Press the “Download Now” button to download JoyToKey + Crack Latest.
    The process will just take a few moments.

    A feature-packed keyboard emulator that enables users to rely on their joysticks for controlling other software solutions and even games

    Mirror —> JoyToKey Full Crack

    · Release version: 6.2
    · Patch date: Feb 2nd 2019
    · Developer: Ryo Ohkubo
    · Downloads: 7505
    · Download type: safety (no torrent/no viruses)
    · Status: clean (as of last analysis)
    · File size: small
    · Price: gratis
    · Special requirements: no
    · Systems: Windows 10 64 bit, Windows 10, Windows 8, Windows 7, Windows Vista, Windows XP
    · Rating:

    Tags:
    joytokey crack and keygen free download, joytokey crack install, joytokey keygen crack, joytokey activate code, joytokey crack exe, joytokey crack keygen for windows, joytokey crack only, joytokey crack and keygen free download, joytokey crack keygen serial, joytokey full patched

    More software: https://crackserialnumber.com

    It may be interesting:
    GOOD | Cleft Connection
    Помощь повышение оригинальности текста
    Staying faithful in the beach volleyball world – Casey Patterson
    Download Giants: Citizen Kabuto Cracked Latest
    Liftderma. Aparencia mais jovem com Liftderma ORIGINAL
    Turn Off Windows Defender software
    Скачать SecurePassword Kit серийный ключ и кряк
    ГДЗ – готовые домашние задания и решебники
    Repair missing or corrupt api-ms-win-core-version-l1-1-0.dll

  7. BruceLit says:
    Your comment is awaiting moderation. This is a preview, your comment will be visible after it has been approved.

    Press the “Download Now” button to download AmiQuote Keygen Serial.
    The whole process will just take a few seconds.

    A stock data downloader that offers support for multiple threads when grabbing data, thus ensuring full utilization of network bandwidth

    MIRROR —> https://firedownload.in/crack/amiquote-65326

    · Release version: 4.02
    · Build date: July 22 2019
    · Developer: AmiBroker.com
    · Downloads: 12843
    · Download type: safety (no torrent/no viruses)
    · File status: clean (as of last analysis)
    · File size: unknown
    · Price: no cost
    · Special requirements: no
    · Systems: Win All
    · Rating:

    Tags cloud:
    amiquote crack latest, amiquote crack patch, amiquote cracked latest, amiquote + crack latest, amiquote crack hack, amiquote with crack, amiquote how to ctack, amiquote + crack latest, amiquote licence keys, amiquote crack exe

    More keygens: here

    Popular software:
    Neon PR | Building Your Social Voice
    Помощь повышение оригинальности
    How I Actually Make Chili These Days – Jo In The Kitchen
    Download Savage 2: A Tortured Soul Keygen Crack
    Equilibre et harmonie – personnalite.biz
    download google books
    Скачать Power2Go серийный ключ и кряк
    Download acrodistdll.dll to fix missing or corrupted DLL errors
    Atomic Mail Sender license – Форумы Белорусского общественного объединения стомированных (БООС)

  8. BruceLit says:
    Your comment is awaiting moderation. This is a preview, your comment will be visible after it has been approved.

    Push the “Download Now” button to download TunePat Spotify Converter Cracked.
    The process will just take a few moments.

    Convert music from Spotify to mp3, aac, wav or flac at 10X faster speed with the help of this neat and constantly updated Spotify audio converter

    MIRROR —> https://downloadcrackz.com/program/tunepat-spotify-converter/113728

    · Release version: 1.1.2
    · Crack date: August 16 2019
    · Company: TunePat Inc
    · Downloads: 6084
    · Download type: safety (no torrent/no viruses)
    · Status: clean (as of last analysis)
    · File size: unknown
    · Price: no cost
    · Special requirements: no
    · Supported systems: Win 10 64 bit / Win 10 / Win 8 64 bit / Win 8 / Win 7 64 bit / Win 7 / Win Vista 64 bit / Win Vista / Win XP 64 bit / Win XP
    · User rating:

    Tags:
    tunepat spotify converter crack latest, tunepat spotify converter crack latest version, tunepat spotify converter cracked, tunepat spotify converter keygen free download, tunepat spotify converter keygen serial, tunepat spotify converter crack patch, tunepat spotify converter cracked latest, tunepat spotify converter cracked latest, tunepat spotify converter crack keygen for windows, tunepat spotify converter full crack

    More software: here

    Other useful resources:
    Trunki PaddlePak – Equipaje infantil, 3 cm, – Todopiscinas.net
    Как обойти антиплагиат
    ??????: ???????
    Download Joint Operations: Typhoon Rising crack version
    ?????
    How to Turn On or Off Windows Defender Real-time Protection
    Скачать Easy Disk Drive Safeguard crack и keygen
    Repair missing or corrupt ac1st16.dll
    Yoga for Managing Stress and Preventing Chronic Illness – Yin & Juice

Leave a Reply

Your email address will not be published. Required fields are marked *