Interactive Excel Dashboard - The Full Tutorial

The full tutorial of creating an excel dashboard from scratch. In this video, we will build an interactive and dynamic excel dashboard from scratch using the sample data provided below. First, we prepare the base of our dashboard by removing the gridlines on the sheet and making sure that no cell has any color/value yet. Then we create the overall structure of our dashboard using the shapes which are readily available on Excel. Then we add the outline and label the shapes to Dashboard Title, Slicers / Filters, Metrics, and Charts. After that, we will start working with our data and create Pivot Tables. Then we connect our Metrics to the Pivot Table. We’ll also create Pivot Charts. Then we customize our dashboard to make it look more polished and professional. Finally, we’ll add the slicers.

iDATA Analytics Hub provides free tutorial videos for Data Visualization, Data Storytelling and Data Analytics.

[mdekram]

Thank you brother, definitely i can it is more than awesome.

[plantsharvest]

How to make a trading journal dashboard?

[aridh]

This is awesome! Exactly what I'm looking for - how to create pivot tables and slicers to my dashboard. Thank you!