Intermediate5–7 hrsEnglish + हिन्दी

Dashboards

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

Modules: 8
Lessons: 22
Duration: 5–7 hrs

Your progress0 of 22 lessons · 0%

Module roadmap

1

Dashboard Design Principles

4 lessons · 40 min

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 lessons · 45 min

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 lessons · 65 min

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 lessons · 60 min

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 lessons · 60 min

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

6

Build 2 — Finance Dashboard

1 lessons · 60 min

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

7

Build 3 — Marketing Dashboard

1 lessons · 60 min

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

8

Performance & Handover

3 lessons · 30 min

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