I Gave ChatGPT a Messy Excel File. Here's What Happened
From Leila Gharani · · 10 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.
If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.
Description
How to analyze Excel data with ChatGPT, using a workflow and prompts that help you check the answers before you trust them. ⬇️ Download the prompt template: https://www.xelplus.com/ai-excel-prompts/#download
🎓 Learn to build the data model used to check ChatGPT's answers: Power Pivot & DAX course: https://www.xelplus.com/course/excel-power-pivot-dax/
Most people drop a file into ChatGPT and type "Analyze this." The answer might look right, but would you put it in front of your manager? In this test, ChatGPT gets a sales workbook with several related sheets and only codes in the main table. You'll see how to set guardrail rules, ask ChatGPT to inspect the file first, check basic numbers in Excel, and compare its answers with a Power Pivot data model.
Note: don't upload sensitive company data. Anonymize it first and follow your company's AI guidelines.
00:00 Why "Analyze this" isn't enough 00:35 The test file: related sheets with only codes 02:12 Prompt 1: guardrail rules and file inspection 03:09 Be careful what you upload 03:30 What ChatGPT found in the file 04:35 Prompt 2: check numbers you can verify in Excel 05:18 Free vs. paid ChatGPT and Thinking mode 06:06 Test 1: sales by region and channel 07:09 Checking the answer with Power Pivot 07:28 Test 2: products with a negative profit margin 08:49 Test 3: will ChatGPT make up an answer? 09:32 Verdict and the 4-step workflow
★ 500,000+ professionals learn Excel with our courses: https://link.xelplus.com/yt-d-all-courses
✉️ Get one practical Excel tip every week in our free newsletter, Between the Sheets: https://link.xelplus.com/yt-d-newsletter
🎬 Related videos: Don't use ChatGPT until you watch this video: https://youtu.be/wBAnCMA98ls Copilot in Excel finally lets you personalize it: https://youtu.be/si61bqW4AEo 10 Copilot Chat prompts I use every week: https://youtu.be/oAbLb-K8VZo
🚩 Connect with us: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/in/leilagharani
#excel #chatgpt #dataanalysis