Create formulas and highlight outliers in Excel
Task · Spreadsheet analysis
Time saved · 30 min per sheet (estimate, not measured)
Steps
- Open the file, email or meeting in the Microsoft 365 app
- Open the Copilot pane
- Enter the prompt
- Check output against the source content
Prompt / template
Add a column that calculates margin % and highlight rows where margin is below 10%.
Source · https://support.microsoft.com/en-us/copilot-excel
Last checked · 2026-10-16