Get the data file here for free: [ Ссылка ]

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.

EXCEL TOTORIAL FOR BEGINNERS LEVEL 1 SERIES: [ Ссылка ]

EXCEL TOTORIAL FOR BEGINNERS LEVEL 2 SERIES: [ Ссылка ]

свернуть