Excel Copilot prompt ideas for spreadsheet work
Watch alongside this article
Public YouTube resources matched to this article's topic, functions, and practice goal.
Agent Mode in Excel: Build and Edit Spreadsheets with Copilot
Microsoft 365
Open on YouTube (opens in a new tab)
Copilot Excel Tutorial - Excels Biggest Upgrade Ever
Kevin Stratvert
Open on YouTube (opens in a new tab)
AI can help with Excel, but it works best when you ask specific questions and verify the result.
Prompt for cleanup
Try prompts like:
- “Find columns that look inconsistent or incomplete.”
- “Suggest a cleanup plan for this customer list.”
- “Identify rows that may be duplicates.”
Then review the suggestions before changing the file.
Prompt for formulas
Be specific:
- “Write a formula that returns the customer name for this invoice ID.”
- “Explain why this formula returns an error.”
- “Suggest a formula to classify overdue invoices.”
Always check the cell references and edge cases.
Prompt for summaries
Useful summary prompts include:
- “Summarize the biggest changes from last month.”
- “List the top five products by revenue.”
- “Find unusual values that deserve review.”
Keep sensitive data in mind
Do not paste private payroll, customer, medical, or confidential finance data into tools unless your organization has approved that workflow.
Go deeper with this skill
Use AI as a drafting and review helper while keeping control of formulas, assumptions, and sensitive data. For this article, the goal is to practice: Use clear prompts for formulas, cleanup, summaries, and review checks while keeping control of the workbook.
Practice workbook setup
Use a sample workbook with non-sensitive data that resembles your real workflow.
Practice workflow
- Ask for a plan before asking for formulas or changes.
- Prompt for one task at a time and review each result.
- Ask the tool to explain assumptions, edge cases, and possible errors.
- Compare the AI result with a manual formula, filter, or PivotTable check.
Quality checks
- No confidential data is pasted into unapproved tools.
- Every formula reference points to the intended cells.
- The final workbook still makes sense without the AI conversation.
Common mistakes
- Accepting a suggested formula without testing edge cases.
- Using vague prompts that hide the real business rule.
- Letting AI rewrite workbook structure without a backup copy.
Next actions
- Save prompts that worked well in a reusable prompt library.
- Create a human review step before sharing AI-assisted workbooks.
Formula focus: even if this workflow is not formula-heavy, add one check cell that confirms the final output still matches the source data.
