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

Опубликовано: 07 Май 2024
на канале: 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


Смотрите видео 🤖 NEW AI Function in Excel - LABS.GENERATIVEAI (CHATGPT inside Excel Formulas) онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь TrumpExcel 07 Май 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 6,608 раз и оно понравилось 249 людям.