Excel Slicer

PAGE UPDATED 27th July 2014

It’s taken me a long time to write about them but I have finally to round the part of my book that includes Pivot Table Slicers. I think the average Excel user will be surprised to learn what can be done with a bit of effort and some creativity. Here’s a screenshot of a simple dashboard set up with some slicers that you will see in my book.

 

UPDATE

I don’t always learn the far end of everything when I learn a technique in Excel. Slicers is a case in point. I know slicers quite well and can use them very effectively. I demonstrate slicers a few times a year to my training course audiences. Following a question on slicers this week, however, I answered the question is it possible to make the slicer read from Z to A rather than A to Z?

The answer turns out to be simple:

• select a slicer
• right click it
• in the menu you will now see
  • Sort A to Z
  • Sort Z to A
• … make your choice of the order you prefer

Alternatively, see the screenshot below to enable you to use the Slicer Tools Options Tab, Slicer Settings dialogue box:

Duncan Williamson