Excel Dashboard Setup | Your Business on One Screen

A dashboard is a live screen that summarizes multiple data sources (sales, stock, collections, marketing) in one place. The point is to see the overall state of the business at a glance, instead of hunting through separate tables for every number. A well-built dashboard answers “what do I need to look at today” the moment you open it each morning.

I build it on top of Excel or Google Sheets — you don’t need to buy separate software. I add a layer on top of the tools you already use, one that pulls your data regularly and visualizes it.

What Should — and Shouldn’t — Be on a Dashboard?

The most common mistake is trying to cram every piece of data onto the dashboard. The result ends up just as cluttered as the original reports. A good dashboard focuses on a handful of key indicators (KPIs) — anyone who wants more detail can click through, but what matters is visible at first glance.

Before building it, I ask what decisions you’ll actually make by looking at this dashboard. If the answer is clear (“I want to see when stock runs low,” “I want to track weekly sales trends”), the dashboard gets built clearly too.

How Does the Live Data Get There?

It depends on your data source: form integration or linked tables in Google Sheets, external data connections or regularly imported files in Excel. In some setups, an automation tool like n8n or Make pulls data from the source system (accounting software, CRM) and feeds the dashboard.

“Live” doesn’t have to mean real-time — for most businesses, a dashboard that updates daily or weekly is plenty, and simpler. If you need real-time, we discuss that separately.

Starting With an Example

I recommend sending over a slice of your data so you can see a working example — seeing a draft built with your actual data makes the decision much easier than an abstract description. If you don’t like it, we adjust it from there; if you do, we move to the full setup.

This approach reduces risk on both sides: instead of starting a big project on an abstract promise, we start with a small piece of proof.

How do we start? We begin with a free 20–30 minute intro call. We talk about what you want and what’s realistic. If it looks like a fit, I send you the scope and price in writing, then we start. You can reach me through the contact page.

Frequently Asked Questions

What data do I need to prepare for the dashboard?

Raw data pulled from your existing system (sales, stock, accounting) is enough — you don’t need to format it specially. During the intro call, we discuss which sources the data comes from and, if needed, I show you how to export it.

How will my team use the dashboard?

Usually it’s set up as a shared Google Sheets file or an Excel file accessed via OneDrive/SharePoint. Team members either just view it or update specific fields — we define who can change what upfront.

Can I view the dashboard from my phone?

Google Sheets–based setups work smoothly through the mobile app. Excel-based setups offer a similar experience through the OneDrive app; we discuss which fits your usage during the intro call.

If my data source changes, does the dashboard break?

If the source format changes significantly (say, you switch accounting software), the data-pulling part of the dashboard may need to be rebuilt. For minor changes, a small fix is usually enough.