Create Interactive Dashboard using MS Excel in 2 hours

Categories: Data Science
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

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.

Benefits

  • Practical Dashboard from Scratch
  • No prior expertise required
  • Convert data into decision making
  • Create interactive dashboard
  • Experienced faculty
  • Soft-copy of Material
  • E-Certificate

Content

  1. What is Dashboard?
  2. Overview of types of Dashboard
  3. Benefits of using Dashboard
  4. Things to Do
  5. How to create a Dashboard in Excel
  6. Other BI Tools
Show More

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
  • Create a DASHBOARD of your Data
  • Add interactivity to your dashboard using slicers

Course Content

Basics of Dashboard
In this section, you will learn basics of the dashboard like what is dashboard, importance of it, types of dashboard etc...

Preparation for Dashboard for our Data
In this section, you will understand about the data that we are going to use to create Dashboard. Also, you will be learning how to create blueprint of Dashboard.

Pivot Table and Charts
In this section, you will learn how to create pivot table on your data and find the summary of the data. Also, you will learn to create chart of the summary.

Creating Dashboard in Excel
This is final section where you will learn to create interactive Dashboard by placing right information at right place with right chart.

Way forward
In this video, you will get an overview on Business intelligence and its various tools.

Want to receive push notifications for all major on-site activities?