Learn to Create Interactive Dashboard using MS Excel in just 2 hours.

person icon Hiren Kakkad

Learn to Create Interactive Dashboard using MS Excel in just 2 hours.

Truly practical course to convert your raw data in to meaningful dashboard (Template and Data included)

updated on icon Updated on Nov, 2023

language icon Language - English

person icon Hiren Kakkad

architecture icon Office Productivity,Microsoft Office,Microsoft Excel

Lectures -26

Resources -1

Duration -1.5 hours


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 8,500+ top Tutorials Point courses anytime, anywhere.

Course Description

About this 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.

The 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.


  • Practical Dashboard from Scratch

  • No prior expertise required

  • Convert data into decision making

  • Create interactive dashboard

  • Experienced faculty

  • Soft-copy of Material

  • E-Certificate


  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


What will you learn in this course:

  • Understand the dashboard and its importance
  • Converting a normal table to an excel table
  • Use of pivot table to summarize the data
  • Create a pivot chart for your data
  • Create DASHBOARD of your Data
  • Add interactivity to your dashboard using slicers


What are the prerequisites for this course?

  • Basic knowledge of Excel is preferred
  • Passion to learn dashboard
Learn to Create Interactive Dashboard using MS Excel in just 2 hours.


Check out the detailed breakdown of what’s inside the course

Basics of Dashboard
8 Lectures
  • play icon Welcome to the Course and Resource Material
  • play icon Content 02:16 02:16
  • play icon Visualization Game 04:29 04:29
  • play icon Importance of Visualization 07:56 07:56
  • play icon What is Dashboard 04:09 04:09
  • play icon Types of Dashboard 04:25 04:25
  • play icon Key Benefits of Dashboard 04:47 04:47
  • play icon Things to be considered before creating Dashboard 04:57 04:57
Preparation for Dashboard for our Data
5 Lectures
Pivot Table and Chart
5 Lectures
Creating Dashboard in Excel
7 Lectures
Overview of BI and BI Tools
1 Lectures

Instructor Details

Hiren Kakkad

Hiren Kakkad

Stat Modeller provides the solutions to the people who are looking for their data to analyze. We have a team of statistical experts who are having vast experience in academic, industries, research, consulting etc.

We have a team of statistical experts who are having vast experience in academic, industries, research, consulting etc.
We provide reliable and quick service to our valuable clients.

Client satisfaction is our ultimate objective. We use latest software to analyze data like SPSS (Statistical Package for Social Science), R, Python, SAS, Minitab, Power BI, Tableau, MS Excel 2016 etc.

We at Stat Modeller provides various solutions to the researchers and the industries who are looking to get their problems solved through statistical analysis and data analysis.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us