A business dashboard sounds like something that requires expensive software or a dedicated data team. It doesn't. For most small businesses, a well-built Excel dashboard gives you everything you actually need — your key numbers, updated automatically, in one place you can check in under 60 seconds.
The goal isn't to build something impressive. The goal is to build something useful. A dashboard that shows you five numbers you actually look at every week beats a complex report that nobody opens. Here's how to build one.
Before you build anything, decide on your five to seven most important business metrics. These are the numbers that, if they moved significantly, you'd want to know about immediately. For most small businesses they look something like this:
Your specific metrics will depend on your business. A service business might track billable hours and outstanding invoices. A product business might track units sold and inventory levels. A restaurant might track covers, average check size, and food cost percentage. Pick the numbers that matter most for your specific situation.
The most common mistake when building a dashboard is jumping straight into Excel and ending up with a cluttered, hard-to-read mess. Spend five minutes sketching out what you want to show and where before opening Excel.
A simple layout that works well for most small businesses:
Your dashboard is only as good as the data feeding it. Before building the dashboard itself, make sure your underlying data is clean, consistent, and in Excel Table format.
At minimum you need your data organized with clear column headers and no merged cells. Convert each dataset to an Excel Table (Ctrl+T) and give each table a descriptive name — SalesData, ExpenseData, OrderData. Your dashboard formulas will reference these table names directly.
Keep your data sheets separate from your dashboard sheet. The dashboard is for reading. The data sheets are for entering and storing. Never mix the two on the same sheet.
KPI cards are the large number tiles at the top of your dashboard showing your most important metrics. In Excel, these are just cells with formulas, formatted to look like cards using cell borders, background colors, and larger font sizes.
Revenue this month (automatic — always shows current month):
Revenue last month (for comparison):
Month-over-month change percentage:
Number of orders this month:
Average order value this month:
Charts built from Excel Tables update automatically when new data is added — which is exactly what you want in a dashboard. Here's how to add the two most useful charts for a small business dashboard:
Revenue trend line (last 12 months):
Build a small helper table on a separate sheet with one row per month and a SUMPRODUCT formula pulling revenue for each month. Then insert a Line Chart from that helper table. The chart updates automatically each month as you add new data.
Expenses by category (pie or bar chart):
Build a helper table with each expense category and its SUMIF total for the current month. Insert a Pie Chart or Horizontal Bar Chart from that table. This shows at a glance where your money is going this month.
Once your formulas and charts are in place, spend 15 minutes on the visual polish that makes the difference between a spreadsheet and a dashboard people actually want to look at.
If your data is already clean and organized, building a basic dashboard with four KPI cards and two charts takes about two to three hours the first time. The payoff is a file you open every Monday morning for the next several years that tells you exactly how your business is doing in under a minute.
If your data is messy, spread across multiple files, or needs significant cleanup first, the setup takes longer — but the result is worth it. A dashboard you trust is one of the most valuable tools a small business owner can have.
If you'd rather have it built for you, that's exactly what we do at HelpMyData. Tell us what metrics matter most to your business and we'll build a clean, automatic dashboard that's ready to use from day one.
Tell us what numbers matter most and we'll build a clean, automatic Excel dashboard that shows your business performance at a glance — starting at $200.
📧 Get Started Today