Free tools Windows power users keep installed
One-click scans. No signup required.
Write an Excel AI prompt in seven parts: name the result, identify the data, add necessary context, specify the output, start with a manageable request, refine with a follow-up, and verify the result. This practical framework helps turn a vague request into something Copilot can act on and you can check.
1. Name the result you want
Start with the task, not a broad instruction such as “analyze this spreadsheet.” Say whether you need an answer, formula, new column, summary, chart, lookup, or workbook change. Copilot in Excel can help with these kinds of work, though the exact behavior depends on the mode you choose.
As an Amazon Associate I earn from qualifying purchases.
For example, instead of “Tell me about sales,” ask: “Which region had the highest and lowest sales?” Or, if you need an issue spotted, ask: “Are there any outliers or anomalies in this data?”
2. Point Copilot to the relevant data
Identify the table, worksheet, columns, cell range, or source sheet the request concerns. Microsoft recommends naming the columns or ranges. This makes the target clearer, especially in a workbook with several tables or similarly named fields.
For example: “Use the Orders table’s Region and Sales columns” is more precise than “look at the sales data.” If the workbook has multiple relevant sheets, name the one to use.
3. Add context that affects the answer
Explain business terms, the time period, or assumptions Copilot needs to interpret the values. If “margin” means profit divided by revenue in your workbook, say so; if the analysis should cover the current fiscal year, specify the dates or fiscal-year definition.
Context helps clarify the request, but it does not guarantee a correct result. Check that Copilot has used the intended definitions and data.
Rank #2
- Used Book in Good Condition
4. Specify the output format
Tell Copilot what a useful result should look like. Ask for a formula in a particular cell, a new column, a summary row, a PivotTable, a chart, or a concise explanation. Microsoft recommends stating the desired format; a specific output request also gives you something concrete to inspect.
For example: “Add a Profit Margin column to the Orders table, calculated as Profit divided by Revenue.” If you need only one calculation, say where the formula belongs rather than requesting a whole column.
5. Begin with a manageable request
Do not try to solve every workbook question in one prompt. Start with the main task, then review the response. A focused first request is easier to assess and gives you a clear basis for deciding what needs clarification.
6. Refine with a targeted follow-up
If the result is close but misses a condition, add that condition directly. Clarify a column, narrow the date range, or ask for a different output. Copilot can build on the previous result, so you can refine instead of rewriting the entire request.
The Tool Desk
Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →For example, after asking for sales by region, follow up with: “Use completed orders only, and show the result as a summary table.” Keep each follow-up tied to a specific change so it is easier to judge whether the workbook now reflects your intent.
7. Check the result before relying on it
Microsoft Support’s guidance is direct: “As with any AI-generated content, review, edit, and verify anything Copilot creates for you.” Check that it used the intended columns, definitions, and scope. For formulas, compare results against representative rows and inspect the referenced cells. For edits, review the changed cells before using the workbook.
- For text-analysis results, a superscript reference can show the source data used.
- In data-analysis chat, expand and review the generated code when available.
- For formulas and workbook changes, test a few cases whose expected result you can verify independently.
Choose the Copilot mode that matches the task
Copilot in Excel currently distinguishes chat, plan, and edit modes. Pick based on whether you want an answer, a proposed approach to inspect, or changes made to the workbook.
| Mode | What it does | Useful when |
|---|---|---|
| Chat | Keeps the response in chat without modifying the workbook. | You want analysis or an explanation without workbook changes. |
| Plan | Creates an approach for you to review before editing. | You want to inspect the proposed steps before changes are made. |
| Edit | Can make changes in the workbook. | You want Copilot to generate or alter workbook content. |
Microsoft lists edit, plan, and chat on Windows, Mac, and web; chat and plan on iPad, with edit support rolling out; chat on iPhone, with edit support rolling out; and chat on Android. Availability can change. Copilot may not appear if it is not included in your Microsoft 365 subscription or is restricted by your organization’s settings. Check Microsoft’s current Copilot in Excel guidance for availability and mode details.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Know when chat analysis fits the data
Microsoft’s data-analysis chat uses Python-based analysis and supports single tables or table-like ranges, including multiple such ranges. Its documented experience does not support unstructured data. Chat analysis does not modify the workbook; some static tables or image visualizations can be inserted, but they are not refreshable. That differs from edit mode, which can make workbook changes.
Best Value
- The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher from Beginners to Advanced
- ABIS BOOK
When the data is table-shaped, a focused prompt can ask for a summary, trend, or outlier check. For material that does not fit a table or table-like range, do not assume this analysis experience can interpret it as intended. See Microsoft’s guidance on data-analysis chat.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Use Python for advanced work only when it suits the task
Microsoft’s August 25, 2026 release notes document Python use with Edit with Copilot in Excel on Windows, Mac, and web for advanced analysis, automation, and data transformation. This is an additional capability, not a requirement for ordinary prompt writing. Review and inspect its output before relying on it. Details are in the Microsoft 365 Copilot release notes.
A reusable prompt pattern
Put the seven parts together in one request when they are all relevant:
Quick wins for a faster PC:
Clear out junk files and repair common Windows errorsFree Scan →Scan for outdated or missing drivers - takes under a minuteDriver Scan →Repair Windows errors before they cause bigger problemsFix Now →“Create [result] using [table, columns, range, or worksheet]. Interpret [terms, period, or assumptions] as [definition]. Return it as [output format]. Start with [manageable scope]. I’ll review the result; if needed, I’ll follow up to clarify [constraint].”
For example: “Add a Profit Margin column to the Orders table using the Profit and Revenue columns. Calculate margin as Profit divided by Revenue. Return it as a formula column. Use completed orders only. I’ll check several rows against the source values.” Treat the generated formula and any changed cells as something to verify, not as a guarantee.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
