Tutorialspoint

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)

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.

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

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

Prerequisites

  • Basic knowledge of Excel is preferred
  • Passion to learn dashboard
Show More

Curriculum

  • Welcome to the Course and Resource Material
  • Content
    02:16
    Preview
  • Visualization Game
    04:29
    Preview
  • Importance of Visualization
    07:56
  • What is Dashboard
    04:09
  • Types of Dashboard
    04:25
  • Key Benefits of Dashboard
    04:47
  • Things to be considered before creating Dashboard
    04:57
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Feedbacks
  • No Feedbacks Posted Yet..!
Learn to Create Interactive Dashboard using MS Excel in just 2 hours.
This Course Includes
  • 1.5 hours
  • 26 Lectures
  • 1 Resources
  • Completion Certificate Sample Certificate
  • Lifetime Access Yes
  • Language English
  • 30-Days Money Back Guarantee

Sample Certificate

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

We have 30 Million registered users and counting who have advanced their careers with us.

X

Sample Certificate