Wasser AI
Copilot for Excel work
A practical guide to using Copilot with Excel work: improve messy workbooks, create analysis you can inspect, reuse repeatable workflows, and turn outside information into clean spreadsheet outputs.
Tell it what to create, what source to trust, and how you want the output structured.
Pick the job, not the feature.
click a tile to jumpAnalyze and build inside the workbook
Ask Copilot to reason through the file, then create the pivot, chart, formula column, or formatted report directly in Excel.
Refresh repeatable outputs
Use a saved template plus a live workbook to regenerate reports, dashboards, summaries, or recurring analysis in the same format.
Bring information into Excel
Turn reports, exports, notes, PDFs, documents, or pasted text into structured tables you can analyze in Excel.
Try the workflows most people miss
Build trackers, calculators, merge messy tabs, create scenarios, generate sample data, and prep presentation-ready visuals.
Three useful ways to work with Copilot.
Do not start with the button. Start with the kind of help you need. Use the Excel pane when the workbook itself needs to change, Copilot Chat when you want to reason across files or pasted information, and an agent when the same workflow should run again later.
Best for changing the workbook you already have open: formulas, PivotTables, charts, formatting, summaries, trackers, and analysis sheets.
Workbook editsBest for comparing files, summarizing information, extracting structure from documents, and asking for a workbook-ready output before you open Excel.
File analysisBest when the task repeats. Save instructions, connect trusted files, and ask the agent to produce the same style of output whenever the source changes.
Reusable workflowStart clean, not perfect.
Old Copilot-in-Excel advice said your data had to be formatted as a Table first. The current editing experience is broader than that: Copilot can create sheets, formulas, PivotTables, charts, formatting, and dashboards inside the open workbook. Clean structure still helps. It just is not the hard gate anymore.
Editing with Copilot can change the workbook directly. Duplicate anything important first, then keep the original untouched.
This is the cleanest path for workbook editing, file history, and custom agents that need to read the same file later.
Use clear headers, avoid merged cells in analysis ranges, and remove blank rows in the middle of data. A Table is helpful, not mandatory.
Use Excel when the open workbook needs to change. Use Chat when the source is outside the workbook. Use an agent when the same task should be repeatable.
Make Copilot build the analysis, not just describe it.
Use Editing with Copilot when you want Excel changed: new sheets, formulas, PivotTables, charts, formatting, report sections, and dashboards. The key phrase is: “create it in the workbook.” If you only ask for an answer, you usually get text. If you ask for the artifact, Copilot has to build the thing.
Starter prompt
When to use this workflow
- You have a workbook open and want Copilot to make changes inside it.
- You need an artifact: a PivotTable, chart, formula column, formatted summary, tracker, or calculator.
- You want a first draft you can inspect, edit, and undo.
Better prompt patterns
What to check before you trust it
- Are the PivotTable fields actually the fields you meant?
- Do formulas reference full ranges, not just the visible rows?
- Does the chart source match the summary table?
- Did Copilot invent a category or assumption that was not in your data?
Reuse a format you already like.
Copilot gets more useful when you give it a repeatable structure. That structure might be a dashboard, a weekly report, a scorecard, a client summary, or a standard analysis format. Keep the source workbook live, keep the template stable, and ask Copilot to refresh the output instead of reinventing it every time.
Template refresh prompt
Example setup: dashboard refresh
- Build a dashboard you like first. Use your own HTML, a dashboard your team already uses, or ask an AI tool to make a first draft.
- Open the HTML file, copy all the code, and paste it into a plain text file called
dashboard-template.txt. - Put
dashboard-template.txtand your live workbook in the same OneDrive or SharePoint folder. - Create a new Copilot agent. Add both files as knowledge sources.
- Tell the agent: preserve the template, update only the values, return complete HTML.
See example system prompt for a refresh agent
What to put in the live workbook
- A simple KPIs sheet for headline numbers, dates, and deltas.
- A Chart Data sheet with one row per chart bar or line point.
- A Notes sheet with definitions, date range, and any business rules.
- Stable labels. If last month’s workbook says
Revenueand this month saysSales $, the agent has to guess.
If the agent gives you a paragraph instead of HTML
- Tell it: Return raw HTML only. No markdown. No summary.
- Shorten the template if it is huge. Agents do better when the template is clean and not full of unused CSS.
- Use the Knowledge refresh button if the OneDrive file was just updated and the agent still sees old numbers.
- Ask for one section first, then the full file, if your tenant truncates long answers.
Turn outside information into usable workbook data.
Excel work often starts outside Excel: a report, export, email, document, screenshot, PDF, meeting note, or pasted block of text. Use Copilot to turn that source material into clean rows, columns, summaries, and checks that can move into a workbook.
Starter prompt
What to ask after the first pass
Example source material
- Vendor price lists into comparison sheets.
- Order confirmations into shipment trackers.
- Meeting notes into action-item logs.
- Monthly scorecards into trend workbooks.
- Survey exports into summary tables and charts.
Example workflows worth trying.
Use these as starting points, not a fixed list. The pattern is the same every time: give Copilot a clear source, name the output, and ask for something editable that you can review.
Ask for a project tracker with dropdown status, due-date formatting, owner columns, and a summary sheet.
Have Copilot create inputs, formulas, and a sensitivity table for price, volume, margin, or headcount.
Ask it to standardize headers, combine tabs, flag mismatches, and create one analysis-ready sheet.
Have Copilot create an exceptions sheet with duplicates, blanks, outliers, formula errors, and suspicious totals.
Ask for three KPIs, one chart, three bullets, and one recommended next action based on the workbook.
After Copilot writes a formula, ask it to explain the references, assumptions, and edge cases.
Use an agent with code interpreter to create fake transaction, survey, or ticket data when you need a demo.
Upload a workbook to an agent with code interpreter and ask for trend charts, distributions, and a downloadable output file.
Copy a prompt for the idea bank
Sources checked for this guide
Microsoft ships Copilot updates constantly. These are the current source trail behind the guidance above — if a step here doesn’t match what you see at work, your tenant settings and these docs are the authority.
Want this built around your real workflow?
Bring one messy workbook, one recurring report, or one dashboard you keep rebuilding. We can turn it into a cleaner Copilot workflow.