Chat on WhatsApp

Create a Dashboard using MS Excel in 2 hours


Price: 300 INR

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.

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

Material Includes

  •   2+ Hours of High-quality Videos
  •   Exercise Files
  •  Handouts
  •  Unlimited Watch Time for 1 Year
  •  Verifiable e-Certificate

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

Meet your Instructor

Hiren Kakkad

CEO & Founder

Stat Modeller

  •  More than 10 years of industrial experience
  •  Awardee of the Training Quality Excellence Award by IQAC and ISTD
  •  Certified Trainer by NSDC & Skill India
  •  Certified by Google Analytics Academy for Data Studio
  •  Certified Lean Six Sigma Black Belt
  •  Trained 11000+ participants
  •  Guided 150+ Improvement projects
  •  Assisted 50+ Research Projects
  •  Trainer for in Data Analysis, R, Python, SPSS, Minitab, Power BI, Excel, Advanced Excel, Six Sigma, TPM, Kaizen, 5-S, Kanban etc.

Get your Verifiable Certificate

Strengthen Your Professional Profile with a Verifiable Certificate

Course Curriculum

Basics of Dashboard
  • Welcome note and Material Guideline
  • Download Material
  • Content
  • Visualization Game
  • Importance of Visualization
  • What is Dashboard
  • Types of Dashboard
  • Key Benefits of Dashboard
  • Things to be considered before creating Dashboard
Preparation for Dashboard for our Data
  • Data Description
  • Derive Parameters for Dashboard
  • Strategy to Display Parameters in Dashboard
  • Creating Blank Structure for Dashboard
  • Complete Header of Dashboard
Pivot Table and Chart
  • Create Measures for Dashboard
  • Prepare Summary of Top 5 Items
  • Prepare Summary for Geo Map and Pie Chart
  • Create Bar Chart for Top 5 Items Part 1
  • Create Bar Chart for Top 5 Items Part 2
Creating Dashboard in Excel
  • Updating Dynamic Measures in Dashboard
  • Creating and Updating Pie Chart in Dashboard
  • Creating Geo Map and Trick to make it Dynamic
  • Add Calculative Measure on Dashboard
  • Overview of Interactivity using Slicers
  • Adding Slicers Part 1
  • Adding Slicers Part 2
Feedback
  • Your Feedback
BONUS
  • Overview of BI and BI Tools
Chat on WhatsApp