Excel AI FORMULA To Save You Hours of Work (NEW)

[@MyOnlineTrainingHub]

❓ How are you going to use this new AI function? Let me know in the comments!

[@hcandts]

I honestly do not know if I'm going to use AI

[@mohammedelsakally540]

Thank you Mynda for your always kind updates you provided to us... the development now is so fast and i think we need to learn how to deal with it to be more efficient in our work... Thank you again...

[@MyOnlineTrainingHub]

My pleasure! Thanks for watching. I'm glad you're keen to make use of these new features.

[@jeremyoakes1]

Amazing stuff! Always appreciate the rundown you provide in simple terms for us excited to learn these things!

[@MyOnlineTrainingHub]

I appreciate your kind words! Thank you 😊

[@nadiamartin76]

What are the privacy controls in place when using that function? Should this be avoided when working with personally identifiable information?

[@MyOnlineTrainingHub]

The function can only see the data you give it in the prompt. If you have sensitive data in the spreadsheet, but don't reference it in the prompt, then there is no risk of leakage. Think of it like having ChatGPT in a formula. If you wouldn't put it in ChatGPT, then don't reference it in the formula.

[@mrkenwu1]

Awesome! Thank you!

[@MyOnlineTrainingHub]

You're welcome!

[@Gorman-84]

Wow, you are on a roll. Thank you.

[@MyOnlineTrainingHub]

Thanks so much 😁

[@IamTheReaper911]

Wow, just wow 💯

[@MyOnlineTrainingHub]

Have fun with it! 😁

[@sheet-chat]

Great video, thanks for sharing! 😊👍

[@MyOnlineTrainingHub]

My pleasure 😊

[@sheet-chat]

@@MyOnlineTrainingHub Thanks for you reply, You are a very skilled Excel expert. I was wondering if we could collaborate because I have been working on an Excel assistant recently. I am an independent developer who has been trying to develop AI-related software since being laid off. However, I am not good at marketing. If you are willing, we can work together. I am willing to share the software's sales revenue with you. Looking forward to your reply. Thank you once again! 🤝

[@rickfittipaldi9856]

Thank you!

[@MyOnlineTrainingHub]

Thank you for watching and for the support!

[@dwang085]

That’s awesome! Thanks

[@MyOnlineTrainingHub]

Thank you for watching and for the comment! 😊

[@a.achirou6547]

Thank you.

[@MyOnlineTrainingHub]

Thank you for watching and for the comment :)

[@MarkSmith-bj2gf]

Could this ai be used to calculate travel distance between two postcodes without using a google api?

[@MyOnlineTrainingHub]

Worth a try.

[@tmb8807]

Thanks for the demos here. Sentiment analysis could be pretty useful with survey/questionnaire data (depending on how reliably it actually detects the sentiment). Have to say though, part of me is somehow reluctant to use this kind of thing... just feels like... *cheating*. I know there's no choice though - it's full steam ahead, or get left behind!

[@MyOnlineTrainingHub]

Yes, it always needs some validation. You could probably check a sample of responses and come up with a confidence level. As for it feeling like cheating, I would get over that ASAP. Before we had the internet we'd go to the library for research. Did you feel like it was cheating to be able to do your research online when the internet was at your fingertips? Not everything online is correct/accurate, but you don't feel guilt for using it. I think of ChatGPT as the next level of search, just better, smarter and faster. Embrace it, but don't trust everything it says. You can always ask it to tell you how confident it is in its answer and cite its sources.

[@tmb8807]

@@MyOnlineTrainingHub I've never felt like using the Internet to research something was cheating, but I grew up with it. I have heard some people who lived through the transition express thoughts of that nature. I'm sure they got over it. It's not really _guilt_ - more that I just get less satisfaction from prompting an AI and having answers handed to me than from working some things out for myself (depending on what it is, of course). But that will obviously take a back seat when it has the potential to turbocharge productivity to such an extent. I'm sure I'll get over it, too!

[@nemanjastojiljkovic3729]

I have MS Professional plus 2021, and I do not have this feature?

[@MyOnlineTrainingHub]

Yes, it’s only available in 365, sorry.

[@jorisvanh.9274]

My formula returns, after some time on #BUSY, always a #N/A error. Is this a paid feature? E.g. do you need to pay for an OpenAI subscription to their api?

[@MyOnlineTrainingHub]

Great to see you trying it out. I explained the cause and solution to that error towards the end of the video 😉 Yes, it's a paid feature, but you get free credit that expires after 30 days when you create an OpenAI account, so perhaps your credit has expired.

[@steven.h0629]

I know a few people that will put this to use :-) 👍😎✊

[@MyOnlineTrainingHub]

Awesome to hear, Steven! 😁

[@bcoz70_gamer]

just get an error #NAME? - is this specific version of Office Excel required?

[@MyOnlineTrainingHub]

Yes, it requires Microsoft 365.

[@gaurangamin6827]

How do I compare current File with Previous version and show the difference only

[@MyOnlineTrainingHub]

You can use Power Query to do this as explained here: www.myonlinetraininghub.com/excel-compare-two-lists

[@gaurangamin6827]

Hi I want to compare with the previous version which I don't save I use one file which pulls the data when it opens so it refreshes the file with the latest data and I want to compare with the previous version

[@awesh1986]

Awesome

[@MyOnlineTrainingHub]

Glad you liked it, Awesh!

[@cyclonesbot737]

I dont have that function in my excel i have 2021 version but instead i have AI.ask and AI.fill such type of prompt

[@MyOnlineTrainingHub]

Hmm, not sure what you're referring to with AI.ask etc. 🤔

[@ratulbanerjee]

Those commands are for another add ins called ChatGPT for Excel

[@mogarrett3045]

wow

[@MyOnlineTrainingHub]

Hope you find this function useful 😊

[@sbatsia]

I copied the formula exactly as shown but kept getting an error. I'm using Chat GPT 3.5. Could that be the reason? Do I need GPT 4.0?

[@MyOnlineTrainingHub]

It’s not the model type. I explain the possible case and solution to errors towards the end of the video. Hope that helps.

[@jimmyPOUFAJones]

all I get is an N/A?

[@DoonRugby]

Same😢

[@MyOnlineTrainingHub]

Did you watch the troubleshooting tips at the end of the video? I found that because I had signed up for OpenAI > 30 days before trying this function, my free credit had expired and I had to add some funds to my account.

[@DoonRugby]

@@MyOnlineTrainingHub That would be it. I opened the account in April.

[@taranawa]

Wow! This is amazing stuff. Thank you for sharing with us Mynda!

[@MyOnlineTrainingHub]

Happy to read that! Thank you 😊

[@shriram8088]

Thank you so much for the video Mynda. you always give detail information with advance functions.

[@MyOnlineTrainingHub]

You are so welcome! 🙏😊

[@chrism9037]

Mynda this is unbelievable! Thanks!

[@MyOnlineTrainingHub]

Thank you for the support! :)

[@janithb1309]

Nice....why does it for a split moment shows busy, is the formula calculated at the cloud ?

[@MyOnlineTrainingHub]

Yes, depending on the complexity of the task, it might take a bit of time to show the result, so the "busy" text appears in the cell.

[@dafeac]

Great, thanks (positive sentiment)

[@MyOnlineTrainingHub]

😁 thank you!

[@nazarkamal8831]

Is this paid option???? In excel

[@MyOnlineTrainingHub]

No, it is not.

[@DavidWhite-zp6bj]

Thanks as always! I've tried to use this function to get it to do something in Excel, but instead of doing it, it's telling me how to do it. Is there something I'm missing?

[@MyOnlineTrainingHub]

This tool can't change cells in your spreadsheet, it can only return information. Next week I'll show you the tool that can change cells in your spreadsheet e.g. add formatting, formulas, PivotTables and more.

[@DavidWhite-zp6bj]

@@MyOnlineTrainingHub Thanks Mynda. I shall look forward to it.

[@iankr]

Many thanks, Mynda. Superb demonstration.

[@MyOnlineTrainingHub]

Cheers, Ian! Glad you enjoyed it 😊

[@dougmphilly]

this is what we're looking for.

[@MyOnlineTrainingHub]

A very useful function, indeed! :)

[@HenricAndersen]

Amazing stuff Mynda. Thank you! 🙂

[@MyOnlineTrainingHub]

Thanks so much, Henric!

[@rasuru_dev]

I like your professional delivery!

[@MyOnlineTrainingHub]

Oh, thank you so much!

[@DaBaiTube]

easier than ever and I'm more lost then before

[@MyOnlineTrainingHub]

Doh 🤦‍♀️If you're stuck, you're welcome to post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum

[@123hocthoi5]

wow, it's pretty good!

[@MyOnlineTrainingHub]

Glad you think so!

[@sbatsia]

Thanks, Mynda, for your detailed explanatory demos. Professional and clear!

[@MyOnlineTrainingHub]

Thanks for watching and your support 🙏😊

[@JennTheWriter]

As always, LOVE your videos. So grateful you do these for us. One question - it appeared you use the 3.5 TURBO within the settings for Lab. Why not use 4.0 Plus instead? Curious to know. :)

[@MyOnlineTrainingHub]

Thanks for your support! The GPT-4 queries cost more! Actually, there was no specific reason. If I got the answer i needed with GPT-3.5 then I left it on that. If not, I can override the model in the formula arguments.

[@PHWiest]

Thanks for another terrific video. The scope of things one can do with Excel grows day by day and none of it is accessible without training! GPT's middle name is "pre-trained"! 🤓

[@MyOnlineTrainingHub]

So pleased you enjoyed it 😁🙏 it's mind-boggling to think where we will be in 12 months' time!

[@apaksoy]

How do you know the result returned by ChatGPT is not "hallucinated" when it operates on a large set of data or the results don't include "hallucinated" elements when the result is a large set of data itself?

[@MyOnlineTrainingHub]

You'd have to do your own due diligence.

[@guranslifes]

I would prompt, "write a lambda function to generate amortization schedule of mortgage loan" will it work?

[@MyOnlineTrainingHub]

It will give you an answer, but you'd get a more specific answer if you can give it context like cell references, field names and more detailed instructions like length of loan etc.

[@kevinweaver6999]

cannot seem to get it installed. I don't have the option to get an API key.

[@MyOnlineTrainingHub]

You can just go to platform.openai.com/signup and sign up for an account and get a key.

[@thestitchmenagerie]

Thank you for this info! How can I permanently revert my default font to Calibri? I guess my Excel updated overnight, because this morning I had the new Aptos Narrow, which I absolutely hate. I found I can change the workbook theme to Office 2013-2022 but I have to remember to do that every time I start a new workbook.

[@MyOnlineTrainingHub]

Aptos is growing on me, but you can change the default workbook settings as explained here: www.myonlinetraininghub.com/customize-default-excel-workbook

[@tmb8807]

Aptos Narrow is a mess at the moment. It looks reasonably sorted (but not brilliant) on the web, but in the desktop app the rendering is horribly inconsistent between point sizes. And it keeps changing - just this last week the '1' numeral suddenly got a bottom bar similar to Calibri, which is inconsistent with the other Aptos variants. I don't know what MS are doing with it. The only way I've been able to make it passable is to set the size to 10.5 - don't know why but it looks smarter (to me) at that size than 11 or 12. Hopefully once they stop messing around with it it’ll look universally like it does on the web, and people will get used to it (I’m starting to).

[@lynnetitley7976]

So I get the #N/A error when I replicate your US state example - do you have to buy tokens even if you use GPT 3.5?

[@MyOnlineTrainingHub]

You have to buy tokens to use it, yes. However, if you signed up for your OpenAI account recently, then you should have some credit you can use. To find out, check your account usage: platform.openai.com/usage

[@lynnetitley7976]

@@MyOnlineTrainingHub Thank you!

[@aprashant1048]

Brilliant, thank you!

[@MyOnlineTrainingHub]

Thank you for the support!

[@markpodesta4605]

Thank you.

[@MyOnlineTrainingHub]

Thank you for watching and for the comment!

[@keylanoslokj1806]

It's greedy madness with all those Billions of dollars and still ask 30$ per month for a simple helper

[@mikechaffee4331]

Are you saying users are too greedy (frugal) to pay $30/month after billions have been invested to create and develop this? Because I DO think users will pay a TINY monthly amount to receive so much value. Or if they won't pay then they won't play.

[@Acheiropoietos]

It’s not $30 bucks pm for a single helper, it’s $30 bucks pm for a whole suite of products which demand professional dedication to master. Idiot.

[@MyOnlineTrainingHub]

Actually, this is a pay as you use model. If you don't use it, you don't pay. Each request is a fraction of a cent.