Data visualization is one of the key elements of report/MIS presentation nowadays, which can be done through a modern tool like interactive dynamic dashboards.
The easiest way to build your interactive dynamic dashboard is to use MS Excel software which is widely used worldwide to keep day-to-day data on marks.
Majority of the people find difficulty in getting the blueprint of the dashboard ready which ultimately leads to the poor quality of the Dashboard. Those dashboards are not insightful and do not help in taking decisions.
In this course, we have focused on creating a dashboard from scratch that is to create a dashboard blueprint based on your data. This will cater as a base to create a dashboard which has practical usefulness.
Here we have come up with a newly crafted workshop on “Learn Interactive Dashboard using MS Excel”. It will be helpful to the person who wants to enhance their skills and how to create a dashboard in excel. To make a dashboard, features like Pivot Table, Pivot charts, etc. are used.
What will You Learn?
Understand the dashboard and its importance
Converting a normal table to an excel table
Use of pivot table to summarize the data
Create pivot chart for the your data
Checking process stability using control charts
Create a DASHBOARD of your Data
Add interactivity to your dashboard using slicers
Requirements
Anyone can Join
No Pre-Requisites
Audience
MIS Executives
Data Analyst Aspirants
Business Professionals
Those who currently use Excel and want to improve your skills
Those who would like to learn how to create interactive reports
Students
Strengthen Your Professional Profile with a Verifiable Certificate