ChatGPT vs Excel Expert: Testing AI on Formulas, Power Query & Python in Excel

Описание: Welcome to the channel!
In this video, I take on ChatGPT in an Excel challenge using real Premier League (EPL) data to test how well AI handles four common Excel scenarios — and where it falls short with overcomplicated solutions:

📌 Static Formula Writing
Categorizing goals using nested IFs vs a scalable lookup table

📌 Dynamic Array Formulas
Summarizing and sorting team stats using GROUPBY vs AI’s overly complex workaround

📌 Power Query (M Language)
Combining and deduplicating teams — AI’s 7-step logic vs a simple 3-step native M function

📌 Python in Excel
Visualizing league data: AI’s repeated matplotlib errors vs a clean, functional Python solution

Throughout the challenge, you’ll see where ChatGPT suggests long-winded, inefficient, or incorrect methods — and where native Excel, Power Query, DAX, and Python can do the job faster and cleaner.

Whether you're an Excel beginner, power user, or exploring AI tools, this is your guide to knowing when to trust the AI and when to trust your own Excel toolkit.

⏱️ Timestamps:
00:00 - Intro
00:35 - Static formula task
00:47 - ChatGPT’s static formula attempt
02:25 - Ben’s static formula approach
03:22 - Comparison
03:55 - Dynamic array formula task
04:06 - ChatGPT’s dynamic array suggestion
06:19 - Ben’s dynamic array solution
07:22 - Comparison
07:40 - Power Query task
08:13 - ChatGPT’s GUI approach
09:27 - Ben’s native M approach
11:27 - Comparison
11:41 - Python in Excel task
12:07 - ChatGPT’s Python errors
14:41 - Ben’s working Python chart
15:42 - Final thoughts

👇 What AI will you be using within Excel?
If you found this helpful, please give it a like and drop a comment on which AI feature you'd like to explore next.

🙌 Support the Channel:
If this tutorial helped you:
👍 Like the video
💬 Comment your thoughts
🔁 Share with a colleague
💸 https://buymeacoffee.com/benjones - to support the channel

🔔 SUBSCRIBE FOR WEEKLY TUTORIALS
Subscribe to BenJonesExplains
Click here to subscribe and master Excel, one trick at a time!
   / @benjonesexplains  

@BenJonesExplains

🔍 Hashtags:
#ChatGPTvsExcel #PowerQuery #ExcelFormulas #PythonInExcel #DAX #ExcelTips #PremierLeagueData #ExcelAI #ExcelTutorial #ExcelChallenge