Bring ChatGPT INSIDE Excel to Solve ANY Problem Lightning FAST

38 comments

1. Hi Leila, I love your videos, but I do not find this one useful!! When will I ever want to bring in the cast of the Sopranos or a list of countries by land mass into one of my spreadsheets?? Keep trying to show practicle uses with ChatGPT. I do not think that this video does it. Thanks!!

2. microsoft has already sensed the opportunity to incorporate ai and they have launch the copilot into microsoft suite.

3. Great job as always. Very helpful. Thank you.

4. what a pathetic use of AI

5. hey how about we go on a date?

6. “Bossy Spice” is my girlfriend’s nickname.

7. Merci Leila

8. …while the api takes all of your company's data out of the spreadsheet to process the request. danger: this is against company policy in almost every company in the US.

9. I like how you sort of admitted you worked with ChatGPT to help it break out of it's cell (or rather, into more technologies in more places) lol someone help us…

10. You did not explain how you added chatGPT into your excel. You went straight in using it. How to add chatGPT into ur excel?

11. Newbie here! Is the "Ask AI Bot" we see at the beginning of the video what is coded in to excel at the end of the video via automate? I'm confused about how she got the "Ask AI Bot" into excel. Thanks!

12. If ChatGPT wrote part of your code, does that mean Open AI has IP rights to your code?

13. its not working. line 46 and 57 have some errors in script

14. Thank You for a very informative tutorial

15. I'm I to download excel AI

16. Hmmm. In my experience, ChatGPT generates junk code that doesn't work for SPSS. Since Excel is very powerful and could be used to disable that A key or wipe the harddrive, I don't know if I'd want ChatGPT in there.

    But if it isn't taking over the app…. can you integrate ChatGPT Bing with it?

17. Nice video, This guy has connected Chatgpt with google search! https://youtu.be/YzXZmhK0NR4

18. I recently read that OpenAI had released the API for ChatGPT (CGPT). Interesting that Chat 3 (sp?) was the source of the API, rather than 3.5, or 4 (should we wish for this….??) This is the first video I have run across that puts that API to use. I had the same experiences learning XL as you describe. I no longer use XL much at all, but gonna search for a problem to make it worthwhile to join XL to CGPT.

19. The technique and instruction are very impressive as always, but ability of OpenAI to answer correctly was not…
    I asked it this:
    
    If we sold $2,691,000 in the first 14 weeks of the year, how much do we expect to sell for the whole year?
    Running it multiple times, these are the answers it gave (some answers came back multiple times):
    
    $2,691,000 * (52 / 14) = $7,844,285.71
    
    If we sold $2,691,000 in the first 14 weeks of the year, we expect to sell for $5,382,000 for the whole year.
    
    $2,691,000 * 52 weeks / 14 weeks = $7,869,143
    
    $2,691,000 is not a whole number, so it cannot be accurately predicted how much will be sold for the whole year.
    
    $2,691,000 * 52 / 14 = $9,964,285.71
    
    $2,691,000 * 52 / 14 = $10,364,000
    
    $2,691,000 is not enough information to calculate how much we expect to sell for the whole year.
    
    We expect to sell $10,364,000 for the whole year.
    
    If we sold $2,691,000 in the first 14 weeks of the year, we expect to sell for the whole year.
    
    $7,000,000
    
    $2,691,000 * 52 / 14 = $9,832,857.14
    
    $2,691,000 * 52 weeks / 14 weeks = $9,932,857.14
    
    $2,691,000 is 26.91% of the total sales for the year. If we expect to sell $10,000,000 for the whole year, then we would expect to sell $2,691,000 in the first 14 weeks.
    
    $38,128,571
    
    $2,691,000 * (52 / 14) = $7,764,285.71
    Even the answers that gave the same math formula reported different answers. It's all over the map. Hopefully it does better at generating Excel formulas.

20. Thank you! I learnt some JavaScript and got this to work in google sheets 🙂 I can send the code if anyone wants it

21. I appreciate how you broke down complex ideas into simple terms, it made it so easy to understand.

22. Wonderful !!

23. fantastic content !

24. https://youtu.be/0AicZ_w0HP4

    Interesting

25. The hack I did not even know existed! I am so glad I came across your page, you just gained a new subscriber. It would be wonderful if you could share information on BlueWillow. I am really curious about this new ai tool and I believe I can learn a lot from you😄

26. Sorry, too complicated

27. I've edited slightly, so the line number in mine is not the same as yours .. bu't im getting this error now, that i dodn't use to get:

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

    .. and it's for this line:

    // Get the answer – i.e. output
    
    const text: (string | boolean | number) = json.choices[0].text;

28. https://youtu.be/3iwJdcyGVGg

29. Thank you – this works for me well!😄

30. GPT tell lots of lies…

31. SCARY!!

32. I gave ChatGPT-4 the same question and it doubled down with a different answer…

    "what is the volume of a sphere with a radius of 11 cm

    The formula for the volume of a sphere is V = (4/3)πr³, where r is the radius of the sphere.
    Substituting r = 11 cm into the formula, we get:
    V = (4/3)π(11)³ V = (4/3)π(1331) V = (4/3) × 1392.54 V = 1857.76 cubic centimeters (rounded to two decimal places)
    Therefore, the volume of a sphere with a radius of 11 cm is approximately 1857.76 cubic centimeters.

    what is the volume of a sphere with a diameter of 22 cm

    The diameter of a sphere is twice the radius, so if the diameter of the sphere is 22 cm, the radius would be 11 cm (since 22/2 = 11).
    To find the volume of a sphere with a radius of 11 cm, we can use the formula V = (4/3)πr³, where V is the volume of the sphere and r is the radius.
    Substituting r = 11 cm into the formula, we get:
    V = (4/3)π(11)³ V = (4/3)π(1331) V = (4/3) × 1392.54 V = 1857.76 cubic centimeters (rounded to two decimal places)

    Therefore, the volume of a sphere with a diameter of 22 cm is also approximately 1857.76 cubic centimeters, since it has the same radius as the sphere we calculated above."

    The correct answer is 5575.27976257 cm^3

33. or you could just hit Alt + Tab

34. can you send a copy of the file with your script? or maybe just the script?

35. Euhh how do you get chatgpt inside of excel? And working together ??
    Thank you!

36. Inside excel. Incel.

37. Excel don't do vedic sum
    Enable it for this so we found out that probability

38. How much time⌚ dilation💻 calculate in 🔮📈🥥excel???

    How to found solution for any parabolic path👣⚡ in 🔮excel😮

Comments are closed.