मध्यवर्ती5–7 hrsEnglish + हिन्दी

Dashboards

Client/boss ko dene layak interactive dashboard bana sakte ho.

मॉड्यूल: 8
पाठ: 22
अवधि: 5–7 hrs

आपकी प्रगति22 में से 0 पाठ · 0%

मॉड्यूल क्रम

1

Dashboard Design Principles

4 पाठ · 40 मिनट

Audience-first design: who will look at it, what decision they'll take10 min Layout grid, F-pattern, \"5-second rule\"10 min Colour system: one accent colour, semantic red/green, accessibility10 min Typography, whitespace, print/screen sizing10 min

2

Data Layer Architecture

3 पाठ · 45 मिनट

3-layer pattern: Raw → Model → Dashboard (never mix them)15 min Named ranges, tables, and naming conventions15 min Staging queries and refresh strategy15 min

3

Building Blocks

5 पाठ · 65 मिनट

KPI cards — value + delta + trend in one cell block13 min Sparklines, bullet charts, variance bars13 min Conditional formatting icon logic and custom rules13 min Dynamic titles and subtitles with formulas13 min Shapes, icons, and cell-based layout tricks13 min

4

Interactivity

4 पाठ · 60 मिनट

Slicers + timelines with multiple pivots15 min Form controls: dropdown, spin button, checkbox, option buttons15 min Driving charts with FILTER + dynamic arrays15 min Camera tool and linked pictures15 min

5

Build 1 — Sales Dashboard

1 पाठ · 60 मिनट

Build: Sales Dashboard — revenue trend, top products, region heatmap, salesperson leaderboard, target vs actual gauge60 min

6

Build 2 — Finance Dashboard

1 पाठ · 60 मिनट

Build: Finance Dashboard — P&L summary, cashflow waterfall, budget variance, expense breakdown, ratio cards60 min

7

Build 3 — Marketing Dashboard

1 पाठ · 60 मिनट

Build: Marketing Dashboard — funnel chart, CAC/ROAS cards, channel comparison, cohort retention grid, campaign table60 min

8

Performance & Handover

3 पाठ · 30 मिनट

Volatile functions, calculation mode, file size trim10 min Sheet protection, hidden helper sheets, workbook structure lock10 min Documentation sheet + version control for xlsx10 min

Dashboards | ExcelWalaa