Using Microsoft Copilot to find any errors in your Excel calculations

There are times when you are working on a complex spreadsheet and you inadvertently add some calculation errors. AI Assistants can help you find these quickly. We ran an experiment where we used the comma delimited file to hide any calculations, the file is available here: https://github.com/ansarmuhammad/report-calculation/blob/main/PRICING-200.csv

I have used csv file to show how intelligent the AI assistant is as it does not have access to the formulas. The original file with formulas is here (you will need to download to open): https://github.com/ansarmuhammad/report-calculation/blob/main/complex_procurement_challenge-excel-v200.xlsx

Though ChatGPT and Grok stuggled to come up with the correct error (row / order), Microsoft Copilot was able to find the error and also explain it. You can view the 3 short videos/demos here which explain the steps:

Part 1: https://www.youtube.com/watch?v=FkpacGqkiUU

Part 2: https://www.youtube.com/watch?v=pYC7GQ7nVrc

Part 3: https://www.youtube.com/watch?v=Kh-aYtInQZw

Some recent posts that cover introductory concepts in applied AI:

1. 5 AI Terms You Need to Know https://www.garudax.id/pulse/5-ai-terms-you-need-know-ansar-muhammad-pmp-psm-1-mwupf/
2. Simple chatbot versus an agentic chatbot https://www.garudax.id/pulse/simple-chatbot-versus-agentic-ansar-muhammad-pmp-psm-1-bwkjf/
3. Agentic Code Generation through CrewAI https://www.garudax.id/pulse/agentic-code-generation-through-crewai-ansar-muhammad-pmp-psm-1-grkuf/
4. Building a Multiagent system using Google’s agent development kit https://www.garudax.id/pulse/building-multiagent-system-using-googles-agent-kit-ansar-ibkbf/
5. What is Retrieval Augmented Generation (RAG): https://www.garudax.id/pulse/what-retrieval-augmented-generation-rag-ansar-muhammad-pmp-psm-1-wpdpf/
6. Using custom instructions in ChatGPT to help with better / relevant responses: https://www.garudax.id/pulse/using-custom-instructions-chatgpt-ansar-muhammad-pmp-psm-1-molof/
7. Powerful tools that save time (NotebookLM, etc.): https://www.garudax.id/pulse/powerful-tools-save-time-notebooklm-etc-ansar-muhammad-pmp-psm-1-mbcrf/?trackingId=UGZxe0bkReuxxe8om8X43A%3D%3D
8. Improving your AI predictions through voting technique https://www.garudax.id/pulse/improving-your-ai-predictions-through-voting-muhammad-pmp-psm-1-kjkzf/?trackingId=hAMUyZfISwGjziGF91wAMQ%3D%3D
9. Automation with n8n.io: https://www.garudax.id/pulse/automation-n8nio-ansar-muhammad-pmp-psm-1-sgeaf/
10. How to Generate Synthetic Data for your Testing https://www.garudax.id/pulse/how-generate-synthetic-data-your-testing-ansar-muhammad-pmp-psm-1-k4mvf