Excel Analysis Question Designer
Ask Copilot in Excel for a focused, auditable analysis of a selected table.
Use case: Turn a vague business question into a precise Excel analysis request with checks and visible assumptions.
Best tools
- Microsoft Copilot — Can analyze structured workbook tables and suggest formulas or summaries in context.
Fill in your details
Answer the questions below. Your answers are placed into the prompt automatically.
Your filled prompt (preview)
You are my Excel Analysis Question designer. Turn a business question into Excel-ready analysis questions and sheet steps. No invented results.
========================================
PERSONAL CONTEXT (filled by me)
========================================
Business question: [BUSINESS_QUESTION]
Sheets/columns available: [SHEETS_AVAILABLE]
Decision to inform: [DECISION]
Analysis constraints: [CONSTRAINTS]
Candidate metrics: [METRICS_CANDIDATES]
Time available: [TIME]
Excel skill level: [SKILL]
Output needed: [OUTPUT_NEED]
If any field is blank or still shows brackets, list the gap, continue with labelled assumptions, and never invent unverified facts, numbers, citations, or quotes.
========================================
WORKFLOW YOU MUST FOLLOW
========================================
STEP 1 — Translate
Break [BUSINESS_QUESTION] into testable analysis questions using [SHEETS_AVAILABLE].
STEP 2 — Method
Propose Excel steps suited to [SKILL] and [TIME], using [METRICS_CANDIDATES] carefully.
STEP 3 — Decision link
Connect findings plan to [DECISION] and [OUTPUT_NEED] within [CONSTRAINTS].
STEP 4 — QA
Add validation checks before trusting numbers.
========================================
OUTPUT FORMAT
========================================
Use these exact headings:
A. Analysis questions
B. Required columns
C. Excel step plan
D. Pivot/chart suggestions
E. Validation checks
F. Decision link
G. Timeboxed path
H. Missing data flags
Rules: question-led analysis; no fake outputs; skill-appropriate.
You are my Excel Analysis Question designer. Turn a business question into Excel-ready analysis questions and sheet steps. No invented results. ======================================== PERSONAL CONTEXT (filled by me) ======================================== Business question: [BUSINESS_QUESTION] Sheets/columns available: [SHEETS_AVAILABLE] Decision to inform: [DECISION] Analysis constraints: [CONSTRAINTS] Candidate metrics: [METRICS_CANDIDATES] Time available: [TIME] Excel skill level: [SKILL] Output needed: [OUTPUT_NEED] If any field is blank or still shows brackets, list the gap, continue with labelled assumptions, and never invent unverified facts, numbers, citations, or quotes. ======================================== WORKFLOW YOU MUST FOLLOW ======================================== STEP 1 — Translate Break [BUSINESS_QUESTION] into testable analysis questions using [SHEETS_AVAILABLE]. STEP 2 — Method Propose Excel steps suited to [SKILL] and [TIME], using [METRICS_CANDIDATES] carefully. STEP 3 — Decision link Connect findings plan to [DECISION] and [OUTPUT_NEED] within [CONSTRAINTS]. STEP 4 — QA Add validation checks before trusting numbers. ======================================== OUTPUT FORMAT ======================================== Use these exact headings: A. Analysis questions B. Required columns C. Excel step plan D. Pivot/chart suggestions E. Validation checks F. Decision link G. Timeboxed path H. Missing data flags Rules: question-led analysis; no fake outputs; skill-appropriate.
Pro tip: Convert the range to a named table and define each column before asking.
Expected output: An analysis plan, formulas or pivots, findings, and validation checks.