Make an AWESOME Multi-page Dashboard in Excel with this Trick 💡

A really simple yet effective trick to make an interactive pivot report or dashboard quickly.

You can set up hyperlink navigation in Excel that can take users from one sheet to another. When you combine this idea with shapes & simple formatting trickery, you get a nice & polished multi-page Pivot report.

Sample file📗📑 :
===============

💥NEW💥
========
I just launched a mini-course on how to create modern & interactive executive dashboard using Excel. If you want to learn how to make powerful & dynamic dashboards, Please get the course here 👇

Learn more 💻:
=============

~

And yeah, DFTBA 😃🌼🌞

#ExcelDashboards

[mariasaba]

Love the simple tips and tricks. Thank you

[gjaakash]

Big admirer of your simplicity while explaining anything and everything. Following you right from my early stage of career around year 2007. A big thank you for enriching the knowledge of millions.

[nuagenuage]

Since i have discovered your chanel i feel less scared even if i am still feeling anxious when i have to use excel but step by step i understand your explanation. Thank you so much for the content, quality of your videos and we can see the passion and generosity of sharing your knowledge to the world and that is wonderful. I am happy that people like you still exist on youtube!! Thanks again!!

[RobertAfrick]

Love, love, love this…simple, yet elegant!

[sarnathk]

Simple but Genius!!! Thank you Chandoo...One trick I learnt is to use IF(valid_data_in_some_cell, F(row data), "")
This can be used to create dynamically appearing sheets where rows suddenly appear and disappear as you interact and modify values...(say filtering rows in a pivot table)....I learnt it during my MS course at Georgia tech...

[TanveerAhmed-qugy]

I m new here, Sir you really enhance my knowledge regarding excel thanks a lot

[ramadiga]

You are God of excel Makin understanding in such simpler way...loved it ...

[wayneedmondson]

Hi Chandoo. Great trick! Thanks for sharing :)) Thumbs up!!

[jrr_ddp]

Really simple and powerful tip.. Thanks for the video

[shaikusman]

Awsome Chandoo...Truly NXT level Pivot

[gameanand]

Simple to extraordinary in efficiency 😎😎

[carloszuniga]

Excelente video para un panel fácil de realizar. Saludos desde Punta Arenas, Chile.

[jjessica]

Hello from Thailand
Great vdo as usual !!! Cheers 😘😘😘😘

[thasmygafoor]

Hi, it's very useful indeed. Can we use it in a dashboard so that once you select the tab, the respective table will appear in the same space of the dashboard. If possible, can you pls create a video. Much appreciated.

[harishpaldhir]

VERY VERY INSPRING SIR U PRESENT THINHGS IN SUCH A COOL AND EASY WAY THAT MAZZA HI AA JANDA WA 😈😈😈

[AKMadishetty]

Just created and it's damn good 👍

[BabarJunaid]

Love this. it is very informative and useful video

[sharavv]

Your a gift to the Ms Office users fraternity