KENYA · GUIDE 0589 · EDITION 4.2

Spreadsheet dashboard building in Kenya

Build an explainable spreadsheet dashboard from defined business records.

A CONCRETE EXAMPLE · ILLUSTRATIVE

Fictional dashboard DSH-89 summarises an owner-approved sales table using four fixture rows: confirmed 500, confirmed 700, cancelled 300 and refund 200. The example definitions yield confirmed sales 1,200, refunds 200 and net 1,000; cancelled 300 is excluded. These are invented test values, not audited accounts. Output is source table, metric dictionary, three KPI cells, one monthly chart and refresh instructions. Forecasting, tax reporting, accounting assurance and live-system integration are excluded.

Who is the first customer?

Owners needing a repeatable operational summary.

Test the offer

Create a small dashboard from fictional or authorized sample data.

What your operating pack contains

A business-specific operating guide PDF
Offline itemised costing and quotation tool
Supplier request and sales message drafts
Job-card and quality-response documents
Offline operations desk: supplier comparison, work checkpoints, accepted deliveries and cash tracking
Cashflow and launch review: downside scenarios, break-even, 13-week cash plan and trial decision
Source register and unresolved checks

Delivery and quality

Headline totals reconcile and missing data is not disguised as zero.

Cost drivers

sources
metric complexity
refresh support

Use your own supplier quotations. Worked figures in the pack are illustrative and do not establish a verified startup budget or profit forecast.

Evidence and scope

SUMIFS function — Microsoft ↗
Conditional summation and matching range dimensions; business metric definitions remain client decisions. · Checked 2026-10-26

Keeping leading zeros and large numbers — Microsoft ↗
Import identifier columns as text to preserve zeros and precision. · Checked 2026-10-26

Import data from data sources (Power Query) ↗
Import preview and data-source workflow; version-specific menus may differ. · Checked 2026-10-26