Create dashboards for stakeholders

Create dashboards for stakeholders in Microsoft Excel — with the four heights of help laid out: do it now, make it easier for the next person to accept, work out the right move when you are stuck, and learn the pattern so it stops coming back.

4prompt heights
Open it in the interactive atlas →

The four heights

The same task, four distances: today's deadline, the next reviewer, the stuck moment, the pattern.

Execute — do the immediate task

+
Stakeholders need a one-page dashboard showing revenue, margin, and backlog by region for the…
Stakeholders need a one-page dashboard showing revenue, margin, and backlog by region for the current quarter and the trailing 12 months. Build a dashboard tab that pulls from the existing 'Data' sheet, shows a single headline metric at top for total revenue, a small sparkline trend for margin, a stacked bar for backlog by region, and a table with last three months daily burn rates. Make it print-ready on a single A4 page and set the named ranges so the report updates when data is refreshed.

Improve — make it easier to accept

+
Before I share this dashboard with the SVP and the regional heads, make it easier to approve. Put…
Before I share this dashboard with the SVP and the regional heads, make it easier to approve. Put the total revenue figure and percentage change vs prior quarter clearly at the top, surface the assumptions used to calculate backlog in two bullet lines, make the pricing and units columns collapsible, and flag any metrics that rely on manual overrides. Call out any filters that will confuse a reviewer (date slicer or region) and suggest one default view for approval.

Decide — diagnose the stuck moment

+
The regional lead says backlog looks off and asks whether it includes work-in-progress; I am not…

I sent a draft dashboard and the regional lead asked if backlog includes work-in-progress.

The regional lead says backlog looks off and asks whether it includes work-in-progress; I am not sure which calculation we used in the dashboard and I can’t explain without opening the source model. What is the likely reason the numbers differ, and what is the fastest clear answer and fix I should give that lead?

Become — change the pattern

+
We spend days tailoring dashboards to each stakeholder: finance wants month-to-month, ops wants…

We keep redoing dashboards for each stakeholder and losing time in approval loops.

We spend days tailoring dashboards to each stakeholder: finance wants month-to-month, ops wants daily burn, exec wants one KPI. What habit or small change should I introduce so one dashboard serves all audiences and we stop wasting cycles on multiple versions?

Next to this one

Other spreadsheet work people do in Microsoft Excel.

Every task here came from the work, not from a feature list — which is why the prompts name what you want done and never the button that does it. The tool changes; the work does not.
Copyright © LLOS.ai · 2026 — original pedagogy, voice, and design — all rights reserved.

The rest of the map

Same library, five ways in.