Dashboards

Intermediate5–7 hrsComing soon

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

This track's lessons are still being written.

M1 · Dashboard Design Principles

40 min

Audience-first design: kaun dekhega, kya decision legaSoon

Layout grid, F-pattern, "5-second rule"Soon

Colour system: ek accent colour, semantic red/green, accessibilitySoon

Typography, whitespace, print/screen sizingSoon

45 min

3-layer pattern: Raw → Model → Dashboard (kabhi mix mat karo)Soon

Named ranges, tables, aur naming conventionsSoon

Staging queries aur refresh strategySoon

65 min

KPI cards — value + delta + trend, ek cell block meSoon

Sparklines, bullet charts, variance barsSoon

Conditional formatting icon logic aur custom rulesSoon

Dynamic titles aur subtitles formulas seSoon

Shapes, icons, aur cell-based layout tricksSoon

60 min

Slicers + timelines multiple pivots ke saathSoon

Form controls: dropdown, spin button, checkbox, option buttonSoon

FILTER + dynamic arrays se charts drive karnaSoon

Camera tool aur linked picturesSoon

60 min

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

60 min

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

60 min

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

30 min

Volatile functions, calculation mode, file size trimSoon

Sheet protection, hidden helper sheets, workbook structure lockSoon

Documentation sheet + version control for xlsxSoon