Work with data: Explore, analyse and consolidate dataLow to medium - verify calculations riskAI required
Explain formulas and calculations
Ask Copilot to explain what a formula does, suggest a formula for a calculation or help diagnose why a result looks wrong.
Where the action happens
Excel / Copilot Chat
Product or feature needed
Spreadsheet assistance
AI required
Yes
Extra credits
Usually no additional credits for normal use
Technical skill
Low
Risk level
Low to medium - verify calculations
Licence dependency
Depends on Excel/Copilot access.
Credit dependency
Usually none.
UK availability
available
What it can do
- Explain formulas in plain language.
- Suggest formulas for common calculations.
- Help troubleshoot spreadsheet logic.
Limitations
- Suggested formulas can be incorrect or inappropriate for the data layout.
Prerequisites
- Verify important calculations.
Notes
Moved into the data section.
Watch-outs for Work with data
- Check important calculations and conclusions before relying on them.
- This section focuses on capability; organisational rules determine which datasets are appropriate to use.
- For regulated or consequential decisions, keep human accountability.
Last checked: 2026-10-09
Disclaimer: Always follow your organisation's internal guidance and policies regarding AI usage. The suggestions in this guide have been created to the best of accuracy, but Microsoft licensing, pricing and feature availability change frequently — treat them as a planning baseline, not a procurement quote.
Community feedback
Has your organisation tried this? Confirm whether it's possible, whether it's useful, and share any tips.
0
Confirmed possible
0
Reported not possible
0
Found it useful
0
Not useful
Loading feedback…