Excel Dashboard - (Hindi)

About Course

Making valuable decisions has always been one of the most important things in business and those decisions are made based on numbers an analysis. Excel Dashboard is tool that gives business leaders valuable information, and it provides a quick outlook of all the most valuable numbers, which allows business leaders to perform an accurate business analysis.

Key Benefit’s:

Monitoring of key parameter/indicators at one place.

Total visibility on your business.

Data based decision making.

Time saving in searching data.

Course Content

Chapter 1: Introduction and dashboard elements
Introduction - adding necessary elements to create dashboard

Introduction
04:38
Developer Menu to Excel ribbon (MS Excel 2021)
01:50
Developer menu to excel ribbon (Previous versions of excel)
02:21
Dashboard & Calculations sheet
01:57
Resource -Excel dashboard sheet
00:00

Chapter 2: Combo box for dashboard
Adding dashboard elements like combo box, various formulas and preparing calculations to short the data as per criteria. this sorted data will be connected to selection tabs and visual charts.

Chapter 3: Important Formulas & Calculations
The 2 important formulas used for data sorting and data offsetting as per the selection criteria.

Chapter 4: Daily Chart for Dashboard
Preparing daily interactive bar chart for dashboard

Chapter 5: Monthly Chart
Preparing monthly chart calculations and adding monthly line chart to dashboard

Chapter 6: Adding Data table to dashboard
adding data table to dashboard with scroll bar. this help to view the portion of data sheet on dashboard for actual figures.

Chapter 7: Country Map – For sales visualization
Adding continent and country wise sales map to visualize the sales worldwide.

Chapter 8:Pie Chart – zone wise sales
Pie chart is used to visualize the categorical data. we are using this chart to visualize the zone wise sales in India

Chapter 9: speedometer Chart – Sales Data
Adding speedometer dial chart. this will give you a snapshot of monthly sales achievement against target sales

Chapter 10: protecting calculation sheet
Protecting calculation sheets to avoid unauthorized alteration or manipulations in formulas.

Chapter 11: Good by Note
Good by note - excel in your career by upskilling to latest industry specific knowledge.

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

Chapter 1: Introduction and dashboard elements Introduction - adding necessary elements to create dashboard

Introduction

Developer Menu to Excel ribbon (MS Excel 2021)

Developer menu to excel ribbon (Previous versions of excel)

Dashboard & Calculations sheet

Resource -Excel dashboard sheet

Chapter 2: Combo box for dashboard Adding dashboard elements like combo box, various formulas and preparing calculations to short the data as per criteria. this sorted data will be connected to selection tabs and visual charts.

Adding Combo box

Combo Box – Adding list

Combo Box – Use

Chapter 3: Important Formulas & Calculations The 2 important formulas used for data sorting and data offsetting as per the selection criteria.

sumifs & Averageifs

Offset Formula

Data Calculations Part 1

Data Calculations – Part 2

Cell freezing – Use of $ symbol

Copy formula to next cells – Part 1

Copy formula to next cells – part 2

Chapter 4: Daily Chart for Dashboard Preparing daily interactive bar chart for dashboard

Chart Data Preparation – Part 1

Chart Data Preparation – Part 2

Daily Chart Plot – Part 1

Daily Bar chart – Part 2

Chart Formatting

Chapter 5: Monthly Chart Preparing monthly chart calculations and adding monthly line chart to dashboard

Monthly Chart – Data Preparation

Monthly Chart on Dashboard

Chapter 6: Adding Data table to dashboard adding data table to dashboard with scroll bar. this help to view the portion of data sheet on dashboard for actual figures.

Scroll Bar – Part 1

Scroll Bar – Part 2

Chapter 7: Country Map – For sales visualization Adding continent and country wise sales map to visualize the sales worldwide.

Country Map – part 1

Country Map – Part 2

Country Map – Part 3

Chapter 8:Pie Chart – zone wise sales Pie chart is used to visualize the categorical data. we are using this chart to visualize the zone wise sales in India

Pie chart – Zone wise sales part 1

Pie Chart – Zone wise sales part 2

Chapter 9: speedometer Chart – Sales Data Adding speedometer dial chart. this will give you a snapshot of monthly sales achievement against target sales

Sales Dial Chart

Adding Pointer to dial chart

Dial Chart – Calculation sheet

Speedometer Calculations

Chapter 10: protecting calculation sheet Protecting calculation sheets to avoid unauthorized alteration or manipulations in formulas.

Protecting calculation sheet

Chapter 11: Good by Note Good by note - excel in your career by upskilling to latest industry specific knowledge.

Good By – Best of luck