🤖 NEW AI Function in Excel - LABS.GENERATIVEAI (CHATGPT inside Excel Formulas)

Excel has a new AI function that allows you to use prompts and get the result right within a cell using simple formulas.
It's like having CHATGPT inside a cell in Excel.
In this video, I will show you how to get this new function (LABS.GENERATIVEAI) Into Excel, how to configure it, and then how to properly use it to get some meaningful work done from it.
While you can use it to generate text like writing a poem or a short story, you can also use it for data cleaning and data extraction.
⬇️ Download Example File - www.dropbox.com/scl/fi/p3nv4o...
00:00 Intro
00:42 Getting LABS.GENERATIVEAI in Excel
07:30 Writig Poem and Short story with LABS.GENERATIVEAI
10:45 Getting Full Month Name using LABS.GENERATIVEAI
14:06 Extracting Full Name from Sentences
14:06 Extracting Full Name from Sentences
16:16 Extracting City, State, and House Numbers from Address in Excel
21:10 Doing Sentiment Analysis using LABS.GENERATIVEAI
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzbin.info...
#Excel #ExcelTips #ExcelTutorial #SumitBansal

[@trumpexcel]

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos. Also, I have made all of my Excel courses available for free. You can check these out using the below links: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course

[@jhankhanajani9314]

Thank you very much Sumit for showing AI Integration in excel !!! You were on convenient speed so how the prompt define can be understood. Thanks once again.

[@comedianbrother9994]

Very Useful 👍👍

[@IvanCortinas_ES]

Excellent tutorial. Thank you for taking your time to do a good analysis of the tool. Without a doubt these tools will contribute to improving our work. Thanks Sumit.

[@jasonstube7074]

Thanks you for your video, I like it very much.✌✌✌✌✌✌

[@rtrbs8383]

Hi Sumit Thank you very much. It is awesme one. In Excel Labs window I can see Python Editor how to use that....

[@xeeshanahmad8757]

Thanks for sharing.

[@Satwant2463]

Thank you🙏🏼

[@tanmaypawar5339]

when i tried this and gave a prompt of write a poem about excel, it shows "#GETTING_DATA". what should i do ? it stays the same forever.

[@udowar]

Can we get it to do complex comparisons between tables and extract data based on criteria supplied?

[@trumpexcel]

It might work, but you will have to test it out. Might also take some prompt refinement. Try it with a smaller dataset, and it works fine, you can use it for a larger dataset. But keep in mind that AI results are not precise, so there is always a chance of some deviation

[@wasanthaarachchi295]

Hi, I am a Sri Lankan government officer. can I contact you, because I belong to the public training organization, we can utilize your valuable knowledge

[@trumpexcel]

You can reach me at [e-mail]

[@muhamedshahidpm8320]

hello boss

[@guruware8612]

Who hasn't used a chat bot? Me ! And? does it send all your worksheets to MS to do the "AI magic" ?

[@romulusmilea2747]

Sir, this is not a formula, it is a function !

[@trumpexcel]

Yeah true, did I call it a formula anywhere? It's a function, but all examples I have shown are formulas using this function

[@vinothkumarmanoharan2317]

I don't like the add in functions

[@lucknowvlog0.228]

First comment ❤

[@narayanavegeshna5137]

4th comment

[@trumpexcel]

This madness needs to stop 😂

[@Garimaish]

😂😂😂😂