After my 7 years as an auditor, I thought that I knew most of the important functions from Excel… until I saw the Slicer function !!!
If you are working with Pivot Table, if you are filtering tables to create reports, if you need to build a dynamic dashboard, you will love this function.
You will find below examples and tutorial to learn how to integrate slicers. Believe me, it is really easy!
Here are some links to learn more about the Slicer function:
- Step by step tutorial page
- Official Office tutorial
- Exemple of a Dashboard with Graphs :
- Extensive tutorial video which includes step by step instructions to create a designed dashboard :