Excel AI FORMULA To Save You Hours of Work (NEW)
ฝัง
- เผยแพร่เมื่อ 29 พ.ค. 2024
- ➡️ DOWNLOAD the free example file here: bit.ly/labsgenerativeai
👩🏫 LEARN MORE in my Excel courses: bit.ly/excelcoursesyt
If you're looking for a way to save hours of work, then you need to check out LABSGENERATIVE.AI! In this video, I'll show you how to use the new AI function that is the equivalent of having ChatGPT in a formula to do your work for you!
LEARN MORE
===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: www.myonlinetraininghub.com/e...
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 FOLLOW me on LinkedIn: / myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
⏲ TIMESTAMPS
==============
0:00 You need to know this about the new Excel AI function
0:26 Practical use 1: getting codes
1:30 Practical use 2: return tables and lists of results
3:03 Practical use 3: extracting data from the web
4:19 What you need to be mindful of
4:32 Practical use 4: sentiment analysis
5:19 Practical use 5: formula explanation
6:51 How to start using LABSGENERATIVE.AI
7:47 If you get errors
8:53 More content on Excel AI
#LabsGenerativeAI #ExcelTips #ExcelTutorial - วิทยาศาสตร์และเทคโนโลยี
❓ How are you going to use this new AI function? Let me know in the comments!
I honestly do not know if I'm going to use AI
Thank you so much for the video Mynda. you always give detail information with advance functions.
You are so welcome! 🙏😊
Wow! This is amazing stuff. Thank you for sharing with us Mynda!
Happy to read that! Thank you 😊
Many thanks, Mynda. Superb demonstration.
Cheers, Ian! Glad you enjoyed it 😊
Amazing stuff! Always appreciate the rundown you provide in simple terms for us excited to learn these things!
I appreciate your kind words! Thank you 😊
Mynda this is unbelievable! Thanks!
Thank you for the support! :)
Amazing stuff Mynda. Thank you! 🙂
Thanks so much, Henric!
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...
My pleasure! Thanks for watching. I'm glad you're keen to make use of these new features.
Thanks, Mynda, for your detailed explanatory demos. Professional and clear!
Thanks for watching and your support 🙏😊
I like your professional delivery!
Oh, thank you so much!
Wow, you are on a roll. Thank you.
Thanks so much 😁
That’s awesome! Thanks
Thank you for watching and for the comment! 😊
Brilliant, thank you!
Thank you for the support!
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. :)
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.
Thank you!
Thank you for watching and for the support!
Great, thanks (positive sentiment)
😁 thank you!
Thank you.
Thank you for watching and for the comment :)
Wow, just wow 💯
Have fun with it! 😁
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"! 🤓
So pleased you enjoyed it 😁🙏 it's mind-boggling to think where we will be in 12 months' time!
Nice....why does it for a split moment shows busy, is the formula calculated at the cloud ?
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.
What are the privacy controls in place when using that function? Should this be avoided when working with personally identifiable information?
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.
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.
Aptos is growing on me, but you can change the default workbook settings as explained here: www.myonlinetraininghub.com/customize-default-excel-workbook
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).
Awesome
Glad you liked it, Awesh!
wow, it's pretty good!
Glad you think so!
Could this ai be used to calculate travel distance between two postcodes without using a google api?
Worth a try.
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?
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.
@@MyOnlineTrainingHub Thanks Mynda. I shall look forward to it.
I would prompt, "write a lambda function to generate amortization schedule of mortgage loan" will it work?
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.
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?
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.
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?
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
@@MyOnlineTrainingHub Thank you!
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!
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.
@@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!
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?
You'd have to do your own due diligence.
this is what we're looking for.
A very useful function, indeed! :)
How do I compare current File with Previous version and show the difference only
You can use Power Query to do this as explained here: www.myonlinetraininghub.com/excel-compare-two-lists
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
I have MS Professional plus 2021, and I do not have this feature?
Yes, it’s only available in 365, sorry.
I know a few people that will put this to use :-) 👍😎✊
Awesome to hear, Steven! 😁
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
Hmm, not sure what you're referring to with AI.ask etc. 🤔
Those commands are for another add ins called ChatGPT for Excel
just get an error #NAME? - is this specific version of Office Excel required?
Yes, it requires Microsoft 365.
cannot seem to get it installed. I don't have the option to get an API key.
You can just go to platform.openai.com/signup and sign up for an account and get a key.
wow
Hope you find this function useful 😊
easier than ever and I'm more lost then before
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
Is this paid option???? In excel
No, it is not.
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?
It’s not the model type. I explain the possible case and solution to errors towards the end of the video. Hope that helps.
all I get is an N/A?
Same😢
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.
@@MyOnlineTrainingHub That would be it. I opened the account in April.
It's greedy madness with all those Billions of dollars and still ask 30$ per month for a simple helper
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.
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.
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.
Thank you.
Thank you for watching and for the comment!