Рет қаралды 29,144
How to create a Social Media Dashboard in Excel - Free Dashboard Template
Download the Social Media Dashboard from :
exceldashboardschool.com/cat/...
This video will show you how to create a social media dashboard. Our ready-to-use dashboard framework enables you to create various dashboards in a short time. Don't forget: This excel dashboard template is free, you can download from our website.
Just a few words about the dashboard: Let's examine the Workbook structure! It's very simple.
First, you can add your data to the datasheet. We have created sections for the key performance indicators. Now, we'll apply a nested IF formula. Using this formula, we can identify and display the variance between the selected month and the previous month. Okay, let's see the dashboard sheet.
We've used a grid layout in Excel for better readability. If you need a monthly breakdown for your dashboard, the best choice is to create a drop-down list. Now, we have to talk about the key element of our dashboard.
We have created widgets for each KPI.
These are:
- Total Watch Time
- Total Amount of Views
- Unique Views
- Impressions CTR
- Average watch Time (s)
- Average views per viewer
- Audience Retention
- Engagement
- Subscribers (Gain)
- Subscribers (Lost)
- Estimated Revenue ($)
- Monetized playbacks (%)
Let us see the data behind the widget.
First, add a data label for the widget. After that, link the data from the Data sheet to the Dashboard sheet. Create a simple line chart. Select the source range on the Data sheet. We'll get and display an annual trendline. Finally, link the variance from the calculation sheet. Repeat these steps for every widget. That's all! Jump to the calculation sheet! Apply conditional formatting. Create new rules for the current selection. So, we can display the positive values in green and the negative values in red. Choose an impressive chart type to display your most important metrics.
Okay, back to the Dashboard sheet. For the main KPI, create a custom chart manually or use Ultimate #Dashboard Tools for data visualization purposes in Excel.
We'll try to answer the most common questions:
------------------------------------------------------------------------------
- How do I create a social media dashboard in Excel?
- How do I create a social media dashboard template in Excel?
- How do I create a dynamic dashboard?
- What is KPI in Excel?
Thanks for watching our video! Subscribe to our KZbin channel!
Learn more about dashboards!
excelkid.com/how-to-create-ex...
#excel #exceltips #exceltutorial