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)
Office Productivity,Microsoft,Excel
Lectures -26
Resources -1
Duration -1.5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ 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 making decisions.
In this course, we have focused on creating a dashboard from scratch which 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 is required.
- Convert data into decision-making.
- Create interactive dashboard.
- Experienced faculty
- Soft-copy of Material
- E-Certificate
Content:
- What is Dashboard?
- Overview of types of Dashboard
- Benefits of using Dashboard
- Things to Do
- How to create a Dashboard in Excel
- Other BI Tools
Goals
- 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 a DASHBOARD of your Data.
- Add interactivity to your dashboard using slicers.
Prerequisites
- Basic knowledge of Excel is preferred.
- Passion to learn dashboard.

Curriculum
Check out the detailed breakdown of what’s inside the course
Basics of Dashboard
8 Lectures
-
Welcome to the Course and Resource Material
-
Content 02:16 02:16
-
Visualization Game 04:29 04:29
-
Importance of Visualization 07:56 07:56
-
What is Dashboard 04:09 04:09
-
Types of Dashboard 04:25 04:25
-
Key Benefits of Dashboard 04:47 04:47
-
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
Course Certificate
Use your certificate to make a career change or to advance in your current career.

Our students work
with the Best


































Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now