Microsoft Excel Tutorial: Using Chat-GPT to write M code in Power Query.
Unlocking the Power of Power Query with MrExcel! 🚀 In this episode (2355), we tackle a common Power Query challenge: deleting rows where two conditions meet. Laura B posed the question, and you'll witness three solutions:
1️⃣ MrExcel's approach using the Power Query interface—efficient, but he admits it could be better.
2️⃣ Enter ChatGPT, the talk of the town! Can it enhance the code? Watch the excitement, the disappointment, and the learning process unfold.
3️⃣ The expert, Smozgur, steps in to provide an optimized solution. Efficiency is the key!
Join us to explore the hype around ChatGPT, its hits, misses, and why Stack Overflow temporarily banned its answers. Plus, a glimpse into the unpredictable world of AI-generated code. Is ChatGPT the future, or is it just another piece of tech lore?
📅 Recorded on Jan 12, 2023. A snapshot in time—will ChatGPT rule the world, or are we safe from our robotic overlords? Tune in, share your thoughts, and let's excel together! 🔍💡 #PowerQuery #ChatGPT #ExcelMagic
Laura B has a tricky Power Query question today. She needs to delete all rows where B=C and D=E. Bill solves this in the Power Query Editor but knows it is not efficient.
He turns to ChatGPT - an Artificial Intelligence tool that is in a free research preview. Bill is amazed at how quickly ChatGPT writes M code for Power Query. But then he bangs his head against the wall trying to get it to work.
See why Stack Overflow has banned ChatGPT because it generates code that is usually wrong but looks like it could work.
Finally, we turn to Smozgur, author of the upcoming "You wouldn't write professional VBA code using the macro recorder would you? A Programmer's Guide to M" book for his efficient solution.
As a bonus, Bill shows ChatGPT's attempts to write Excel formulas. Bill is convinced that his late Uncle B's is secretly running ChatGPT from the great beyond.
Excel MVP Paul Kelly has a great video where he tests ChatGPT for learning Excel VBA Code. Watch that here: [ Ссылка ]
Table of Contents
(0:00) 3 Ways to Solve Power Query Problem
(0:29) Human versus ChatGPT
(0:55) What is ChatGPT
(2:44) StackOverflow bans ChatGPT
(3:49) Tricky Power Query problem from Laura
(4:32) Power Query to delete based on 2 conditions
(5:00) Power Query Add Conditional Column
(7:34) Asking ChatGPT for Power Query code
(8:12) ChatGPT is AMAZING!
(8:28) Adjusting ChatGPT Code
(8:51) Why ChatGPT code sucked
(9:45) Efficient M code for 2 conditions
(10:44) ChatGPT success with IF AND formula
(11:03) ChatGPT fails for Prime number formula
(11:21) ChatGPT fails again.
(11:44) Uncle B's ability to talk about anything
(12:19) ChatGPT suggests the fictional ISPRIME function
(12:45) 25% success rate. Not impressed.
(13:12) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #powerquery
This video answers these common search terms:
ChatGPT
ChatGPT capabilities
ChatGPT limitations
ChatGPT writing Power Query code
Efficient Power Query code
Learn Excel from MrExcel podcast episode 2355
Power Query code
Power Query delete records
Power Query question
Power Query solutions
Stack Overflow and ChatGPT
Testing ChatGPT's abilities
Join the MrExcel Message Board discussion about this video at [ Ссылка ]
