I Gave ChatGPT a Messy Excel File. Here's What Happened

Want to build reliable data models? Excel Data Modeling with Power Pivot & DAX 👉 https://www.xelplus.com/course/excel-... Most people drop a file into ChatGPT, type "analyze this," and call it a day. I wanted to know if the answer you get back is actually correct, so I gave it a sales workbook you would not wish on anyone. The transaction sheet is just codes. No names, no categories, nothing readable. To get real numbers, ChatGPT had to look up product info, customer location, and purchase type from three separate master sheets, then do the math itself. No formulas existed anywhere in the file. It had to build everything from scratch. ⬇️ DOWNLOAD the prompts here: https://www.xelplus.com/ai-excel-prom... In this video: The exact guardrail prompt I used before letting ChatGPT touch the analysis How I made it inspect the workbook first and flag missing values, duplicate transactions, and hidden sheets Three quick checks I ran to confirm it understood the basics before trusting it with anything harder A store vs online sales breakdown by region, cross-checked against my own Power Pivot data model A profit margin analysis where it had to pull cost data from a different sheet and calculate margins on its own What happens when I ask it a question the workbook genuinely cannot answer Chapters: 00:00 - The Problem with "Analyze This" 00:33 - Exploring the Complex Sales Workbook 02:12 - Setting Guardrail Prompts for ChatGPT 04:32 - Verifying Basic Check Numbers 06:08 - Test 1: Joining Tables for Regional Sales 07:25 - Test 2: Calculating Negative Profit Margins 08:48 - The Trick Question: Will ChatGPT Hallucinate? 09:50 - Learn Advanced Excel Data Modeling 📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: https://link.xelplus.com/yt-d-newsletter 🔓 Join this channel to get access to perks:    / @leilagharani   🎬 LINKS to related videos: Don't use ChatGPT Until You Watch this Video:    • Don't Use ChatGPT Until You Watch This Video   Copilot in Excel Finally Lets You Personalize It:    • Change This One Copilot Setting for Better...   10 Copilot Chat Prompts I Use Every Week:    • 10 Copilot Chat Prompts I Use Every Week   📲 Let’s connect on social: Instagram:   / lgharani   LinkedIn:   / leilagharani   #Excel #chatgpt