The best Excel trick when working with Dashboard and Pivot Table !

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!

Résultat de recherche d'images pour "slicer excel"

Here are some links to learn more about the Slicer function:

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s