Bring ChatGPT INSIDE Excel to Solve ANY Problem Lightning FAST

Great work! I dont have the automate tab in my Excel. Which version I should I get to have that Automate Tab. I am Project Manager so I would like to use AI in my excel it will make my life whole lot easier. I appreciate your help.

I am using Excel 2021 but I am unable to find the option of Analyze Data. How can I get that option in my excel. Can you tell me ?

I know I'm late to the game, but not everyone watching this video has the same level of skills/know-how when it comes to Excell. You might want to start by explaining how did you add an ask column in excel?

damen garm baba . du er kjempeflink LEIa :-*

The script is running,however when you ask a question,there is no answers reflecting by AI

there is an error while we run the office script you have put up in the line
"const text: (string | boolean | number) = json.choices[0].text;" and it says
Line 46: Cannot read properties of undefined (reading '0')
Please help leila

Light 💡 bulb has been turned on in me

the downside of this is it frequently makes your MS excel run too slow and lots of lags

I don't have automate tab, can I use a code in vba to have such dialog box of gpt

awesome video. the file used to work, but now i am getting an error when running the script. Line 46: Cannot read properties of undefined (reading '0') . I appreciate any help

Nice..but..real problems come when you're working with big files with 10 or 20 columns, full of formulas. In this case, when you have to deal with complicated issues, there you need an assistant. I don't think you can simply copy and paste the entire file in the box, because in this case i'm not sure if ChatGPT can really understand all the links and formulas behind the file...am i wrong or is there a solution? thanks

You might as well speak Chiense.

Can you please make a video that shows beginners how to write a script step by step? When I added your script, it gave me an error message for line 10 :(

HI Leila, why can not see the automate tab? I have Microsoft 365.

this seems complicated, Microsoft CO-Pilot will replace everything soon it will revolutionized the way we work, A game changer in many ways.

Answer to "Line 46: Cannot read properties of undefined (reading ‘0’)" - you will have to pay in order for this script to work, lowest amount to charge your balance is 5$ to. Nothing's free my friends - "When your credit balance reaches $0, your API requests will stop working. Enable automatic recharge to automatically keep your credit balance topped up."
I confirm that paying 5 bucks solves the case and the script works. I'd add this information to pinned info.

Thanks!

Thank you! This error displays: Line 46: Cannot read properties of undefined (reading '0'). any idea why?

Works great! Thank you for sharing. I had a little trouble initially locating that UNICHAR(96) character. Also, for some reason one line of code was giving me trouble in my version and not in yours (// get generated text part).

Thank you, thank you, thank you! This will save me untold hours of research. You are amazing Leila! You provide quality information that is much appreciated.

You did a greatest showcase about ChatGPT what I'm looking for, thanks a lot!

i dont have automate tab in my excel what can i do?

you donkey, you never showed HOW YOU BRING AI INTO THE FILE. HOW DO YOU BRING THE AI INTO THE EXCEL FILE? DONKEY!!!!!!!!!!!!!!

Is there a way to do this same thing but through Power automate?

where do you put the API key?

This is an error I'm countering while running the script
"Line 4: Cannot read properties of undefined (reading 'getRange')"

Why didnt you do it with python? I thought python was design for this a little better then typescript?

Awesome video and great idea!!! My mind is spinning with ideas on such applications! Just impressive!

Beyond its state-of-the-art security technology, the Utopia P2P browser shines for its exceptional functionality. By integrating the chatGPT neural network, it simplifies and enhances the online experience for users, eliminating the need for multiple tabs.

Huge thank you, Leila!

The 1/3 creator's of word program the last 6 months i been woring on your project it ashamed just like stealing the program or shall i say snowballing friends surly you have ideas of your own or maybe pay people like me no you rather take well i do like excel just promote it now i dont back theifs

Is it possible in office 365 on smart phone

Dear Leila, thanks for all this information. I was trying to follow your instructions, but the Excel file is not opening, and it sends a message that the file might be corrupted. Thanks again for this amazing job.

profi video de sajnos nem tudom hasznalni a benne levo infokat , mert nincs microsoft 365 abonamentem. peddig nagyon klasz kis video , kar hogy szamomra hasznavehetetlen.

bonjour Est-ce que tu utilises également chaque GPT avec Google sheet?

est-ce que je pourrais te mp étant donné que j'ai eu quelques idées pour utiliser pour mon e-commerce mais je ne sais pas si ces idées sont bonnes , j'aimerais avoir ton avis

et aussi j'ai pensé à d'autres outils d'intelligence artificielle

en tout cas merci de tes vidéos

Hi @Leila , Where I can get that excel plugin that you are using and is there any tutorial on how to run and install it?

Hi Leila, I don't see automate on my excel desktop

Thank you for the great work as usual! I'm not sure where exactly I should paste the API key, it's not that clear for me in the video, can anyone help with that, please? Thank you in advance

How did you set up AI in Excel?

This is gonna change my life.

Line 46: Cannot read properties of undefined (reading '0')

Please I want make hyperlink from current cell raw and take to matching cell raw in another sheet dynamically

I have been watching your videos for the last few months and find them to be very excellent. I really enjoy them a great deal :-)

love it

I experimented with ChatGPT and Google BARD -- my conclusion? We still need to fact-check and verify whatever these chatbots suggest.

Thank you Leila! Fantastic video!

sucks ....

Hello , I get his error when I try the script : Action script error Line 46: Cannot read properties of undefined (reading '0')