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

Published: 07 May 2024
on channel: TrumpExcel
6,608
249

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 - https://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 - https://www.buymeacoffee.com/SumitB

✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-c...
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...

#Excel #ExcelTips #ExcelTutorial #SumitBansal


Watch video 🤖 NEW AI Function in Excel - LABS.GENERATIVEAI (CHATGPT inside Excel Formulas) online without registration, duration hours minute second in high quality. This video was added by user TrumpExcel 07 May 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 6,608 once and liked it 249 people.