Excel Formula / Logic Explainer
Explain what a formula or logic does, to document or debug it.
The prompt
Explain this formula/logic in plain language: [paste formula]. Cover: - What it calculates, step by step - The inputs it depends on - Edge cases or errors it could produce For understanding and documentation. Verify behaviour on real data before relying on it.
How to use it
- 1Select Copy the prompt above.
- 2Paste it into Microsoft 365 Copilot.
- 3Replace anything in brackets with your own detail, then send it.
Copilot gathers and drafts. You verify and decide. Check every figure, name and date against the system it came from before you act on it.
Written for
Business Analyst, Data Analyst, Finance Analyst
More for Data & Analytics
- Data & Analytics Critical Guardrails - Read First
- Dataset Profiling Prep
- Anomaly / Outlier Exploration
- Ad-hoc Analysis Plan
From the source collection in awesome-microsoft-copilot-prompts, licensed CC BY-SA 4.0.