Get the files Here: https://github.com/LG-Experiment/Scripts
OpenAI inside Excel? How can you use an API key to connect to an AI model from Excel?
This video shows you how. You can download the files from the GitHub link above.
Wouldn’t it be great to have a search box in Excel you can use to ask any question? Like to create dummy data, create a formula or ask about the cast of the The Sopranos. And then artificial intelligence provides the information directly in Excel – without any copy and pasting!
In this video you’ll learn how to setup an API connection from Microsoft Excel to Open AI’s ChatGPT (GPT-3) by using Office Scripts.
As a bonus I’ll show you how you can parse the result if the answer from GPT-3 is in more than 1 line. This makes it easier to use the information in Excel.
My Online Courses https://www.xelplus.com/courses/
00:00 How to Connect Excel to Open AI ChatGPT
01:18 Answer Any Question in Excel
02:16 Use ChatBot to Write Excel Formulas
04:16 Analyze Financial Statements with AI GPT
05:21 Use AI to Create Dummy Data in Excel
07:26 How to Build Your Own AI ChatBot in Excel
08:54 Create Office Script to Connect to GPT-3
11:13 Wrap Up
LINKS to related videos:
How ChatGPT Can Help With Your Complex Excel Spreadsheets: https://youtu.be/21bXQDXSxYs
Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
RESOURCES I Recommend: https://www.xelplus.com/resources/
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel #chatgpt #ai
Take the opportunity to connect and share this video with your friends and family if you find it useful.