---
title: "Make an Awesome Excel Dashboard in Just 15 Minutes"
source_url: https://youtu.be/jeYjtEX3RAE
captured_at: 2024-12-19
author: "Kenji Explains"
contributor: "ชิดชนก"
platform: youtube
---
# Make an Awesome Excel Dashboard in Just 15 Minutes

youtube video by **Kenji Explains**, 15m27s, uploaded 2023-02-05. URL: https://youtu.be/jeYjtEX3RAE
Tags: excel dashboard, excel dashboard in 10 minutes, excel dashboard in 15 minutes, build an excel dashboard from scratch, create a dashboard, sales dashboard excel, create a sales dashboard, excel kpi, excel koi chart, excel visuals, excel map chart, excel line chart, excel doughnut chart, excel radar chart, make a dashboard in 10 minutes, excel dynamic dashboard, excel interactive dashboard, awesome 

## Shared in LINE Note+
- 2024-12-19 08:08 by ชิดชนก — nearby chat: KasetSamkler.pdf

## Description
Build an awesome interactive Excel dashboard in just 15 minutes.
👉 Take our Excel for Business & Finance Course: 
🚀 All our courses: 

🆓 DOWNLOAD Free Excel file for this video: 

In this video we'll build a dynamic Excel dashboard from scratch in just 15 minutes. This will be a sales dashboard for McDonald's South America region. First, we'll make the dashboard dynamic using hyperlink to navigate to the different tabs. Then we'll build the overall structure using shapes and icons. Next we'll create all of the charts and visuals which include a map chart, radar chart, line chart, doughnut chart, KPIs, and more. Finally, we'll customize the visuals and add them to the dashboard.

LEARN:
📈 The Complete Finance & Valuation Course: 
👉 Excel for Business & Finance Course: 
🧑‍💻 The Data Analyst Program: 
🚀 All our courses: 

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Making the Dashboard dynamic
2:11​ - Dashboard Structure
4:15​ - Creating the charts and visuals
9:34​ - Customising the visuals and putting it all together

## Transcript (captions:manual:en)
in this video we'll create this awesome interactive Excel dashboard in just 15 minutes first we will structure the dashboard and make it Dynamic then we'll create all of the charts and visuals and finally we'll customize them to fit our look so let's get into it so here's the Excel file that we'll be working with which you can download for free in the video description let's suppose that we're working at McDonald's and we're tasked with creating a sales dashboard for the South America region and for this we're given three different tabs the dashboard where we'll have all our charts and visuals then the inputs tab where we have all of the data to create the visuals and finally we've got contacts tab over here just to have the contacts of all the managers so let's go back to the dashboard and the first thing here is to make this Dynamic so you can see that we've got all of these icons here to the side we can actually hyperlink them such that they navigate to different tabs so we'll go to right click on this one say and from here towards the bottom you'll find the link and we want to link it to a place in this document and more specifically to the inputs tab we'll hit OK the third one we can link as well we'll go to link again this time for the contacts and the final one here you can see the question mark let's say this is the support so it actually links to an email so let's suppose this is to an email address and you can specifically type say info at support .com that's just a made-up email but we'll hit OK there and then this first one should go to the to this dashboard tab so we'll go to link again and Link it to a place in this document the dashboard and we'll hit OK the idea here is that when you click on one it's gonna take you to the different tab we need to add the same thing across all of the different sheets so we'll go to this first one just select the column by clicking on the a here Ctrl C go to control page down Ctrl V control page down again and Ctrl V and now we can dynamically navigate across the different sheets now that we have the navigation in place let's work on the general structure so we're going to add different shapes here we're just going to go to insert then under shapes let's go ahead and create a rounded rectangle and we're just going to drag it more or less from here from column B all the way to column m and here you can decide how how rounded you want it to be we don't want it too rounded so I'm just gonna hover over there the shape fill we're gonna want it in a white color with no outline so we're gonna go to no outline down over here one final touch here is actually adding a shadow on the background of the shape kind of like so once we have the shape we can go ahead and add a title here so let's call this a sales dashboard for now Ctrl a in case you don't see it's probably because the text is currently in white so we'll change that to say a dark blue Ctrl B to bold in to make it bigger you can just click on this bigger a here once we have this first one you can just hit the Ctrl shift and then just drag it that's going to allow you to drag it down over here so the idea is to have three different shapes here such that they're going to be the three kpis so we'll go ahead and reformat this let me fast forward how I do that then right below that we're gonna have one large chart over here and then one smaller one down below here so let's do the shapes for that as well so Ctrl shift and just drag down let me reformat that as well and finally we need to add one more shape over here which is going to represent the map of South America nice now that we have all of the shape structures let me fast forward how I rename them here's what the structure with the titles is going to be looking like so we've got the title and what the figures are in right below that we have the three main kpis then we're gonna have some kind of a line chart over here alongside the customer satisfaction scores and finally a breakdown using a map chart to see the sales by country now that we've finished this first step the second step is to work on the different charts and visuals so let's head over to the inputs tab for this so control page down here the first thing we're going to do is go ahead and select all of the customer satisfaction scores here just hit on Ctrl a for that and then we're gonna go over to insert and we're gonna add what's known as a radar chart so we'll go to this drop down over here under all charts we're gonna go towards the bottom where it says the radar one it was hit on OK there and we don't really need this Legend here as we kind of have that already in the labels so we'll delete we'll also delete the title here now you can more or less see how we're doing on each of the factors and speed clearly isn't a very good one and nor is service we'll just go ahead and move this over to the side and make it smaller and we'll work on reformatting it later right next to that we've got the map chart over here so the country breakdown so control a again this time under insert we're gonna head over to maps go under a field map and we can just remove the title layer you can see that's looking fairly good already so we'll just make this a bit smaller leave it here to the side then for these sales figures over here to compare them easily we can use something like a line chart so we'll go Ctrl a insert and we're going to go under recommended hopefully it shows up there and you can see that we've got the line chart so we'll hit OK on that but you'll notice that this um axis over here has way too many labels so you actually can't see what's going on within this range so from more or less 180 to 250 is what we care about so first we'll delete this title here we'll change this axis by right clicking on it going to format access that minimum amount is the one we want to change and we'll add something like 180 here and hit enter and now you can see that discrepancy a little better and again we'll just move that to the side for the time being now let's work on these up over here basically here we're gonna get the different proportions so the percentage of complete if we look at the formula is simply going to be the actual over the target so we just want to get these two here so the complete and the remainder that's going to be enough for us to create a donut chart so we'll go under insert under the pi over here we're gonna select the donut down below great let's remove the title and we don't need the legend either and one more thing that we can do here is actually add a text box inside which is going to give us the percentage that's completed so in this case it would be 85. for this let's go to the insert tab under shapes here we're gonna select the first one which is the text box and then we're just gonna drag it over here but you can't simply put the 85 percent as that's not going to be dynamic so we're actually going to go up over here to the formula bar go to equals and we'll select that 85 percent ourselves and hit enter we can then reformat it so maybe put it in the middle and let's also Center it like this Ctrl V to bold then we can make it a bit bigger to something like size 16. and then we'll change the color to something like the dark blue great from here let me just go ahead and resize it I'm gonna fast forward how I do the same thing for all the other ones but one final thing is making the donut the width here a bit thicker so we can see it …