Excel dashboards people actually read
A dashboard earns its place when someone can open it and make a decision in under a minute. That is the bar we design to.
How the file is put together
We start from the decisions, not the chart types. Which questions come up in every management meeting? Those become the top row. Everything else moves down or gets cut.
Underneath, the file is built properly: a separate data layer, Power Query for the refresh, PivotTables and measures for the maths, and a presentation tab that never holds raw data.
Data layer
Raw imports land on their own hidden sheets and are never edited by hand.
Model layer
Power Query and PivotTables do the shaping and the maths, so logic sits in one place.
View layer
Slicers, timelines and charts on a single screen sized for a normal laptop.
Refresh
One button, or a scheduled refresh where your setup supports it.
Common dashboard problems we repair
- 1It takes 40 seconds to openUsually volatile formulas and full-column references. Both removable.
- 2Charts break when data growsFixed ranges instead of tables. A structural fix, not a patch.
- 3Nobody agrees what a number meansWe label definitions on the sheet so the debate ends.
- 4It looks nothing like your brandColour, type and layout set to match your reporting standards.
Everything that ships with this
- A single-screen dashboard with working filters
- A documented data model behind it
- Refresh in one click, tested on your data volumes
- A print or PDF layout for board packs
- Walkthrough recording for the wider team
Fixed price, quoted after we have seen the file or the brief. Nothing is billed until you approve the scope in writing. See pricing.
If the audience lives in Excel and the data fits comfortably, Excel wins on adoption. If you need row-level security, scheduled distribution or millions of rows, Power BI is the better home. We build both and will say which fits.
Yes, where the source allows it — SharePoint, SQL, an API or a shared folder. Files on a personal desktop need a manual click.
Often. Keeping your layout and fixing the engine underneath is usually cheaper than starting again.
Send the file. Get a straight answer.
A 20-minute call, or just email the workbook with a note on what is wrong. Either way you will know the cause and the cost before you commit.