Call us on 0844 800 7880
MS Excel 2013 : Slicers

Introduce Me

new mouse glasses  thumbSlicers

Use slicers to filter data within a PivotTable at the click of a button.

When using the standard PivotTable report filters on multiple items, a drop-down list needs to be used to identify the details. However, slicers clearly label the applied filter, enabling any filter to be easily understood.


Tell Me

Creating a slicer:

  1. Click anywhere within the PivotTable.
  2. Select the Analyze tab.
  3. Click Insert Slicer (within the Filter group).

    2013ExcelMasterpm slicer01
  4. Choose the fields required.
  5. Click OK.
  6. A slicer is displayed for each field selected.
  7. Within each slicer, select the items upon which the filter will be based (holding down CTRL whilst clicking on multiple items).

    2013ExcelMasterpm slicer02

Tell Me More

Formatting a slicer:

  1. Click the slicer to the formatted.
  2. Select the Options tab.
  3. Click the Slicer Styles More button.

    2013ExcelMasterpm slicer03
  4. Choose the style required.

Let Me Try

Here is an exercise for you to try out creating slicers for yourself.

MS Excel 2013: Slicers

If the "OPEN" option does not show you all icons you'd expect in the application, use the "SAVE" option.


Help Me

new mouse glasses  lightbulbTry and follow the steps below to give you a better learning experience:

  1. Make time for your learning on a frequent basis – remember little and often will be most effective.
  2. Think about what time of day will be best for you, and have some time to practice your new found skills.
  3. Think about how you go about a task in your daily work and whether you are doing it in the most efficient way.
  4. Think about your reason for learning.
  5. Speak to your line manager and request some time for learning, after all it will improve your outputs in the long term.
  6. And finally, read your Weekly Tips from Bite Size – learning something new this week could save you time and frustration next week.

Good Luck and Happy Learning!



My Bite Size Login

On-line Courses
Facebook Twitter LinkedIn YouTube