AI & Copilot • Excel • 1–2 minute read
7 Copilot Prompts That Actually Save Time in Excel
Use these prompts when you need Excel help fast. Each one is designed to produce a practical output you can act on immediately: a clean column formula, a robust XLOOKUP, a summary, a set of rules, or a clear troubleshooting path.
The simplest way to get better Copilot results is to structure your prompt like this: Goal (what you want) + Context (where the data is and what it means) + Expectations (the output format). Replace the bracketed parts below and keep your request specific.
Fast prompt tip
Tell Copilot your data location (table name or range) and ask for the final formula plus a quick check.
Output tip
Ask for results in your preferred format: bullets, steps, a formula block, or a mini checklist.
Safety tip
Avoid pasting sensitive customer, financial, or HR data into prompts. Use anonymised examples where possible.
Jump to a prompt
Prompt format (copy this structure)
Goal: [what you want]
Context: [where the data is + what it represents]
Expectations: [output format + constraints + checks]
Context: [where the data is + what it represents]
Expectations: [output format + constraints + checks]
1
Clean and standardise messy data (formulas only)
Goal: Clean my table using formulas (not Power Query).
Context: Table has columns [Name], [Email], [Company], [State], [Date].
Expectations: Provide a new "Clean" column set with exact formulas to:
1) TRIM spaces, 2) standardise State to AU abbreviations, 3) convert dates to dd/mm/yyyy,
4) flag invalid emails, 5) return a final clean table layout.
Context: Table has columns [Name], [Email], [Company], [State], [Date].
Expectations: Provide a new "Clean" column set with exact formulas to:
1) TRIM spaces, 2) standardise State to AU abbreviations, 3) convert dates to dd/mm/yyyy,
4) flag invalid emails, 5) return a final clean table layout.
You should get: a ready-to-use set of clean columns you can reuse each month.
2
Write a robust XLOOKUP (with “latest wins”)
Goal: Create an XLOOKUP that is safe for shared reports.
Context: Lookup value is [E2]. Lookup key is column [A]. Return value is column [D].
Expectations: Exact match, show "Not found" if missing, and if duplicates exist return the most recent row.
Provide the final formula, explain each argument briefly, and give 1 validation check.
Context: Lookup value is [E2]. Lookup key is column [A]. Return value is column [D].
Expectations: Exact match, show "Not found" if missing, and if duplicates exist return the most recent row.
Provide the final formula, explain each argument briefly, and give 1 validation check.
You should get: one final formula plus a simple way to confirm it is correct.
3
Build a summary your stakeholders can read
Goal: Create a one-page summary from my data.
Context: Excel table is named [Sales] with columns [Date], [Region], [Customer], [Revenue].
Expectations: Provide either Pivot steps OR formulas (SUMIFS/COUNTIFS) to show:
1) Revenue by Region and Month, 2) Top 10 customers, 3) Average deal size.
Include the exact field layout and recommended slicers/filters.
Context: Excel table is named [Sales] with columns [Date], [Region], [Customer], [Revenue].
Expectations: Provide either Pivot steps OR formulas (SUMIFS/COUNTIFS) to show:
1) Revenue by Region and Month, 2) Top 10 customers, 3) Average deal size.
Include the exact field layout and recommended slicers/filters.
You should get: a repeatable summary layout you can refresh with new data.
4
Make issues visible with conditional formatting
Goal: Create conditional formatting rules that highlight risk.
Context: Columns are [Due Date], [Status], [Owner], [Priority].
Expectations: Provide exact formulas and where to apply each rule for:
1) Overdue items (Due Date < TODAY and Status not "Done")
2) Due in next 7 days
3) High priority items with blank Owner
Context: Columns are [Due Date], [Status], [Owner], [Priority].
Expectations: Provide exact formulas and where to apply each rule for:
1) Overdue items (Due Date < TODAY and Status not "Done")
2) Due in next 7 days
3) High priority items with blank Owner
You should get: three rules that turn your sheet into a self-checking tracker.
5
Explain a trend and generate a simple forecast
Goal: Summarise trends and forecast the next [3/6/12] months.
Context: Months in [A2:A25], Revenue in [B2:B25].
Expectations: 1) Plain-English summary (growth, seasonality, anomalies),
2) one recommended chart, 3) a built-in forecast approach (e.g., FORECAST.ETS) with the exact formula.
Context: Months in [A2:A25], Revenue in [B2:B25].
Expectations: 1) Plain-English summary (growth, seasonality, anomalies),
2) one recommended chart, 3) a built-in forecast approach (e.g., FORECAST.ETS) with the exact formula.
You should get: a usable story for stakeholders plus a transparent method you can validate.
6
Debug a formula fast (and learn why)
Goal: Fix a formula error and make it more robust.
Context: Here is the formula: [paste it]. Here is what I expect it to do: [one sentence].
Expectations: Explain what is happening, identify the likely cause, then provide:
Fix A: minimal change, Fix B: more robust modern approach.
Include 3 quick checks to confirm the fix is correct.
Context: Here is the formula: [paste it]. Here is what I expect it to do: [one sentence].
Expectations: Explain what is happening, identify the likely cause, then provide:
Fix A: minimal change, Fix B: more robust modern approach.
Include 3 quick checks to confirm the fix is correct.
You should get: a fix you can trust, plus a repeatable debug method.
7
Create a repeatable template (monthly reports, trackers)
Goal: Design a simple Excel template my team can reuse.
Context: Use case is [monthly reporting / asset register / sales tracker].
Expectations: List the sheets, columns, and key formulas to include (at least one XLOOKUP and one SUMIFS).
Include: clean input area, validated dropdowns, a summary/dashboard section, and a data quality check area.
Context: Use case is [monthly reporting / asset register / sales tracker].
Expectations: List the sheets, columns, and key formulas to include (at least one XLOOKUP and one SUMIFS).
Include: clean input area, validated dropdowns, a summary/dashboard section, and a data quality check area.
You should get: a clear blueprint you can build in 30–60 minutes, then reuse forever.
Want to learn these live? Nexacu's Copilot for Excel course covers real-world prompts with hands-on practice.
Next step
Get your team using Copilot in Excel safely and consistently
In the real world, the time savings come from consistent prompt patterns, good data habits, and knowing what outputs to trust. Our Copilot for Excel training focuses on practical scenarios, quality checks, and prompt workflows your team can reuse.
