ycliper

Популярное

Музыка Кино и Анимация Автомобили Животные Спорт Путешествия Игры Юмор

Интересные видео

2025 Сериалы Трейлеры Новости Как сделать Видеоуроки Diy своими руками

Топ запросов

смотреть а4 schoolboy runaway турецкий сериал смотреть мультфильмы эдисон
Скачать

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

ChatGPT Excel

Excel AI

Power Query M

DAX formulas

Python in Excel

ChatGPT fails

Excel vs AI

Excel tutorial

Premier League Excel

EPL data

Excel challenge

AI in spreadsheets

Excel formula tips

ChatGPT Power Query

Excel vs ChatGPT

ChatGPT DAX

ChatGPT Python

dynamic arrays Excel

nested IFs Excel

Excel vs human

Excel analytics

Excel AI mistakes

ChatGPT Excel test

Автор: Ben Jones Explains

Загружено: 2025-08-11

Просмотров: 203

Описание: 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

Не удается загрузить Youtube-плеер. Проверьте блокировку Youtube в вашей сети.
Повторяем попытку...
ChatGPT vs Excel Expert: Testing AI on Formulas, Power Query & Python in Excel

Поделиться в:

Доступные форматы для скачивания:

Скачать видео

  • Информация по загрузке:

Скачать аудио

Похожие видео

© 2025 ycliper. Все права защищены.



  • Контакты
  • О нас
  • Политика конфиденциальности



Контакты для правообладателей: [email protected]