How to make Interactive Dashboard on Excel and PowerPoint using Slicer

If you want to make very interactive dashboards in Excel and Powerpoint, Slicer is the feature that you are looking for.

Slicer is useful in doing data interaction very easily, be it a Table, Pivot table or any chart.

Slicer is a very interactive and single touch alternate to Filter. Also if you have to give your excel to someone for presentation, he/she can manage the same easily using slicer.

The slicer can be used in PowerPoint to make interactive presentations and better visualization. In this video Slicer usage with various options is explained with 5 examples. How to apply slicer on a table and properties of a slicer, like size, colour etc? How to apply slicers on multiple fields of a table? How to apply slicer on Pivot Table and Chart? How to apply Slicer on multiple Pivot tables and Charts using the connection and control them using a single slicer? How to use the slicer on Powerpoint?

How to insert Slicer:

Slicer Options/Styles:

Samples:

Slicer in PowerPoint