In this video, I will show you how to make a dashboard in Excel.
First, we will create a data sheet and a contact sheet.
The data sheet will contain the data that we will use to create the dashboard.
The contact sheet will contain the names and contact information of the people who are responsible for each item on the dashboard.
Once we have created the data sheet and the contact sheet, we will create the dashboard.
The dashboard will consist of three parts: a title, a data section, and a contact section.
The title will be at the top of the dashboard and will contain the name of the dashboard.
The data section will be in the middle of the dashboard and will contain the graphs and charts that will visualize the data.
The contact section will be at the bottom of the dashboard and will contain the names and contact information of the people who are responsible for each item on the dashboard.
To create the dashboard, we will use the following steps:
1. Select the data sheet and click on the Insert tab.
2. Click on the Chart button and select the type of chart that you want to create.
3. Drag the chart onto the dashboard.
4. Format the chart to match the style of the dashboard.
5. Repeat steps 1-4 for each graph or chart that you want to create.
6. Add the title to the dashboard.
7. Add the data section to the dashboard.
8. Add the contact section to the dashboard.
Once you have completed these steps, you will have created a dashboard in Excel.