LESSON 18
Excel Dashboard
Learn how to create a professional Excel Dashboard for business data and reports.
📊 Excel Dashboard Kya Hai?
Excel Dashboard ek visual report hoti hai jisme important business
information ko charts, numbers, tables aur summary ke through
ek hi screen par show kiya jata hai.
English
An Excel Dashboard is a visual report that presents important
business information using charts, numbers, tables and summaries
on a single screen.
💡 Dashboard Kyun Banaya Jata Hai?
Large data ko directly samajhna difficult ho sakta hai.
Dashboard important information ko simple aur visual format mein
present karta hai.
Raw Data
↓
Data Analysis
↓
Charts + KPIs
↓
Professional Dashboard
🧩 Dashboard ke Main Elements
1. KPI Cards
2. Charts
3. Tables
4. Filters
5. Summary
6. Titles
7. Important Numbers
In elements ko combine karke ek professional dashboard banaya ja sakta hai.
🔢 KPI Cards Kya Hote Hain?
KPI ka full form hai Key Performance Indicator.
KPI cards important numbers ko highlight karte hain.
TOTAL SALES
₹25,50,000
TOTAL ORDERS
1,250
CUSTOMERS
850
PRODUCTS
120
Dashboard mein KPI cards sabse important information ko quickly show karte hain.
💰 Sales Dashboard Example
Ek sales dashboard mein business ki sales performance ko track
kiya ja sakta hai.
Sales Dashboard
Total Sales ₹25,50,000
Total Orders 1,250
Customers 850
Average Order ₹2,040
📈 Dashboard Mein Charts
Charts data ko visual form mein understand karne mein help karte hain.
Column Chart → Monthly Sales
Bar Chart → Product Sales
Line Chart → Sales Trend
Pie Chart → Category Share
📅 Monthly Sales Chart
Monthly sales ko chart mein show karke business ko sales trend
samajhne mein help milti hai.
Month Sales
January 150000
February 180000
March 210000
April 195000
May 250000
June 280000
Is data se monthly sales ka chart create kiya ja sakta hai.
📦 Product Sales Analysis
Dashboard mein different products ki sales compare ki ja sakti hai.
Product Sales
Laptop 900000
Mobile 650000
Monitor 350000
Keyboard 150000
Mouse 100000
🛒 Category Analysis
Product categories ke according sales ko analyze kiya ja sakta hai.
Category Sales
Electronics ₹12,00,000
Accessories ₹5,00,000
Furniture ₹4,00,000
Other ₹2,50,000
🔎 Dashboard Filters
Filters ka use dashboard mein specific information dekhne ke liye
kiya ja sakta hai.
Filter By:
Month
Product
Category
City
Salesperson
Excel mein advanced dashboards ke liye Slicers ka bhi use kiya ja sakta hai.
🎛️ Slicer Kya Hai?
Slicer Excel ka ek visual filtering tool hai.
Isse table ya PivotTable data ko easily filter kiya ja sakta hai.
Example:
City
[Kanpur] [Delhi] [Mumbai] [Lucknow]
Slicer dashboard ko interactive banane mein help karta hai.
📋 PivotTable ka Use
PivotTable large data ko summarize aur analyze karne ke liye
bahut useful Excel feature hai.
Raw Sales Data
↓
PivotTable
↓
Summary
↓
Chart
↓
Dashboard
🏗️ Dashboard Structure
Ek simple professional dashboard ka structure kuch is tarah ho sakta hai.
========================================
SALES DASHBOARD
========================================
TOTAL SALES | ORDERS | CUSTOMERS | PRODUCTS
----------------------------------------
MONTHLY SALES CHART
----------------------------------------
PRODUCT SALES | CATEGORY SALES
----------------------------------------
SALES SUMMARY TABLE
========================================
🔄 Dashboard Data Flow
Raw Data
↓
Clean Data
↓
Excel Table
↓
PivotTable
↓
Charts
↓
KPI Cards
↓
Dashboard
Clean aur properly organized data dashboard ke liye important foundation hai.
⭐ Professional Dashboard Design
Dashboard simple, clean aur easy to understand hona chahiye.
✓ Clear Title
✓ Important KPIs
✓ Clean Charts
✓ Proper Alignment
✓ Consistent Formatting
✓ Useful Filters
✓ Easy-to-read Data
✓ No Unnecessary Elements
💼 Business Mein Excel Dashboard
✓ Sales Dashboard
✓ HR Dashboard
✓ Finance Dashboard
✓ Marketing Dashboard
✓ Inventory Dashboard
✓ Customer Dashboard
✓ Performance Dashboard
✓ Management Reports
🧠 Dashboard Banane ke Liye Skills
Professional Excel Dashboard banane ke liye kuch important Excel
skills helpful hoti hain.
Excel Tables
Formulas
SUM
COUNT
COUNTIF
IF
Sort & Filter
PivotTable
Charts
Slicers
Formatting
⚠️ Important Note
Dashboard ka purpose data ko beautiful banana hi nahi hai.
Dashboard ka main purpose important information ko clear,
accurate aur quickly understandable banana hai.
📚 Lesson Summary
Is lesson mein humne Excel Dashboard ke basics aur structure ke
baare mein seekha.
Excel Dashboard
KPI Cards
Charts
Tables
Filters
Slicers
PivotTable
Sales Analysis
Product Analysis
Category Analysis
Professional Reports
Excel Dashboard business data ko visual aur professional report
mein convert karne ka powerful way hai.