Prompt

Tech & AI at WorkPromptPlan

Build a One-Page Dashboard From Your Sales Spreadsheet

Designs a one-page Excel or Google Sheets dashboard for a small business — which five numbers, which charts, a month selector and traffic-light rules — on tabs you can refresh.

  • Role-Based
  • Step-by-Step
  • Constraints
  • Structured Output

Opening lines · ~411 words in full

ROLE: You are a reporting designer for owner-managed businesses who has replaced many forty-tab workbooks with a single page the owner actually opens on Monday morning. You pick fewer numbers, not more, and every chart must serve a decision.

CONTEXT: My business is [BUSINESS_TYPE]. I track [DATA_I_HAVE] in [EXCEL_OR_SHEETS_VERSION], one row per [ROW_UNIT], with columns: [COLUMN_LIST]. The decisions I make …
On a plan

The rest of “Build a One-Page Dashboard From Your Sales Spreadsheet” opens on a plan

You are reading the opening lines. The full prompt (~411 words) — to copy, download as a ready .md file, or finish in the Studio — comes with the Library plan: every prompt and skill, .md downloads, 80 tailoring runs a month.

Upgrade — €15/moBrowse the free set

Part of the Excel & Google Sheets Users Pack — 8 items for excel & google sheets users.

Written by the PromptCorrectly team© 2026 PromptCorrectly · All rights reserved

How to use it

  1. Read it, then replace anything in [BRACKETS] with your details — the more concrete the context, the sharper the answer. The Studio lists the blanks for you and can add your project's background.
  2. Copy it (or download the .md) and paste it into the AI you already use — it knows your work, so that is where the prompt does the most.
  3. Want it in your brand’s voice? Press “Tailor to my brand” and the Studio rewrites it for your business. To sharpen the answer itself, add self-critique prompting.

Techniques in this prompt

Role-Based

Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.

Learn this technique
Step-by-Step

Forces explicit intermediate reasoning instead of jumping to a conclusion, which improves accuracy on hard tasks.

Learn this technique
Constraints

Sets the rules and boundaries — tone, length, what to avoid — that keep the output on-target.

Learn this technique
Structured Output

Pins the response to a defined structure so it drops straight into your workflow.

Learn this technique

Works with

Any chat AI — ChatGPT, Claude, Gemini, Copilot, Grok, Mistral or a local model. The structure does the work, so you are not tied to one vendor or one model version.

New to structured prompts? Start with how to prompt AI, the RCTCO prompt framework this prompt is built on, and role prompting examples.

More in Tech & AI at Work

Why Our Shop Emails Land in Spam and How to Fix ItWalks a non-technical owner through the causes of shop emails landing in spam — sender authentication, list quality, content and sending habits — with a step-by-step fix plan and messages for their web host.Accessibility and Readability Check for a Small Business WebsiteWalks an owner through a practical accessibility and readability review of their small business website — headings, contrast, alt text, links, forms, keyboard use — with fixes their builder can apply.Turn a Manual Task Into a Trigger-and-Action Automation MapConverts a repetitive copy-paste routine into a precise trigger, filter and action map with field mapping, duplicate checks and test records, and says which tool suits it.Stop a Zap or Make Scenario From Failing SilentlyAdds retries, error routes, safe re-runs, alerts and a heartbeat check to an existing Zapier, Make or n8n workflow so a broken automation is noticed the same day.