10x Your Excel With This New AI Formula
Вставка
- Опубліковано 27 чер 2024
- Use the ChatGPT powered =AI.Function in Excel.
🔥 Take our Excel Course: www.careerprinciples.com/cour...
🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.co...
In this tutorial we teach you how to use the new ChatGPT powered AI.Formula. First, we cover how to install it as an Excel add-in for free. Then, we learn how to use it by using the =AI.ASK feature asking simple questions. Next, we use the =AI.FILL formula to generate smart answers. Third, we use the =AI.EXTRACT for a superior version of the flash fill. Fourth, we learn the =AI.TRANSLATE to translate any text automatically and make it dynamic with a drop down list using data validation. Finally, we generate tables with =AI.TABLE. As a bonus, we see how this add in works in PowerPoint to create slides from scratch.
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Intro & Set Up
1:03 - AI.ASK Formula
2:54 - AI.FILL Formula
4:27 - AI.EXTRACT Formula
7:27 - AI.TRANSLATE Formula
8:45 - AI.TABLE Formula
10:35 - Bonus Feature
🔥 Take our Excel Course here: www.careerprinciples.com/courses/excel-for-business-finance
Holy cow this is outstanding! Thank you!
I spent the whole video with my jaw dropped.... I have been praying for some of these features for years! Thank you very much for sharing! By the way, congrats on all the videos, you always explain Excel features in a very simple and practical way 👌👌
Thank you for your lovely comment Filipa!
Can it extract attachnent from outlook?@@KenjiExplains
This is extremely useful! thanks for uploading!
This Ai new function is so cool. Totally game changing, it can replace a lot of formula we use to remember. Thanks for sharing Kenji.
Awesome ! Thank you Kenji !
Its so bloody insane what Excel can do now....love this and great video with great examples
It still hasnt been able to help me pick winning lottery numbers....or make me understand how to do a multiple line graph
This is really amazing. I did not know any of them. Thank you so much 😍
Thank you!
Fantastic Kenji
That....was...crazy! I didn't know this existed. THX
Simply brilliant
I liked this particular video very much Because you provided exclusive things
Literally amazing
Thank you, it is helpful
Thanks for this video, a wonderful and smooth explanation
Glad it was helpful!
this will surely increase productivity. thanks for updates
Pray your boss doesnt see this or youll just get extra work (without extra pay) which your coworkers should have done if they knew how to do this. And even if they do, theyre smart enough not to brag but act stupid and let you do all the work while they goof off in the breakroom, on their cellphones.
whatever you have shared in this video is totally new for me, thanks a lot for sharing
Thank you!
I'm excited to learn sir
Really an awesome tutor 😊
What a great hack!! Thanks Kenji
thank you
Amazing 👍🏿
This is awesome!
Wow this is great
Great video and examples
Glad you like them!
good and informative video
Amazing
Hi Kenji, can you run some tutorials for census data 1 and 2 which all are in the same worksheet were species code did not match census 1 and 2,,,,,, because I'm trying to make left = right and I'm manually insert-shifting cell down to make left=to right
Great video! Thanks!
Fantastic. Am I right in saying it doesn't work when the column the new extracted data is to go into,
is in a table format?
00:03 Excel's AI formula can extract names, create tables, and more
01:30 Excel AI can generate professional emails and excel formulas based on prompts.
02:55 Using AI.Fill to auto-populate data in Excel
04:20 Excel AI feature - Extract makes data extraction easier
05:50 Excel's AI features can improve productivity
07:27 The equals AI do translate feature allows text translation and language selection.
09:03 Using AI formulas to generate structured data and lists in Excel.
10:25 AI formula may not work well with larger datasets.
Hello Kenji I am great fan of yours and learned lot of excel formulas by seeing your vedios now i need a help hope you would help me in our office we have a daily tracker in that we have 12 agents and works in 24/7 shifts we work on incident tickets as soon as the ticket arrives we have enter the ticket number in that sheet and change the color of the cell manually according to the time the ticket arrived for eg. if ticket came in between 8am to 9 am it will be green if it is between 9 am to 10 am then red if it is between 10 am to 11 am then purple so on so instead of changing the color manually i need a formula or a steps so based on current time when the data entered into a cell the color should change please suggest
It is awesome. just a quick question, when i use Ai.fill or extract, it just returns a single result in the first row, any idea?
This looks like a promising add-in, but I'd imagine it's not ready for professional use just yet. The most powerful feature is ai.table, but when it's used to generate data, any analyst is going to be spending the same amount time, if not more, verifying that the generated data is correct than they would have spent generating the table themselves with a Google search. As ai gets more reliable with time, I think this add-in will have much greater use in a professional setting. Until then, it feels like just a gimmick.
You'd definitely be better served learning how to pull xml data from a trusted website which excel can do natively without needing some third party plugin.
Amazing! Great quality!
Thank you!
📝 Summary of Key Points:
📌 The video introduces the AI formula in Excel, showcasing its capabilities like answering questions, generating emails, and suggesting formulas.
🧐 Another feature highlighted is the AI fill function, which can populate tables based on examples provided, making data entry more efficient.
🚀 The AI extract feature is demonstrated to extract specific information like names or emails from unstructured data, surpassing traditional methods like Flash Fill.
💡 Additional Insights and Observations:
💬 "The AI formula in Excel offers a range of powerful features to enhance productivity and streamline tasks."
📊 The AI translate function can swiftly translate text into different languages, saving time compared to external tools like Google Translate.
🌐 The AI do Table feature can generate tables based on prompts, making data organization and analysis more convenient.
📣 Concluding Remarks:
The video showcases the diverse capabilities of the AI formula in Excel, from answering queries to translating text and generating tables. These features can significantly boost productivity and efficiency in Excel tasks, offering a valuable tool for users seeking to streamline their workflow.
Generated using TalkBud
Is it possible to remove select words or numbers from a list of sentences which have those?
Thing to note with that add-in that you can see at approximately the 1 minute mark in the lower right corner of the add-in window, "free trial". It isn't free if you're working with even relatively small samples of data. I frequently get location files from clients with incomplete date like missing area codes. Was thinking this could be a handy way to populate missing ones. Working with a file of just 90 rows and having to take a couple swings at ai.fill and ai.ask to get the results I finally wanted, it filled about 28 rows before stating "ERROR: Free trial ended. Choose a plan to continue using functions."
The "Starter" sub is $8/mo when I followed the link in the add-in.
Jadon Sancho....tell me you are an United diehard fan without telling me! Keep up the great work Kenji
hahaha im actually a barcelona fan lol (I'm from Barcelona). We're both going through some rough times haha
@@KenjiExplains Barcelona is doing a lot better than United does. United has been brutal under the Glazer ownership. Hope the new owner brings in some changes.
Wondering if I could use the AI table function to make a table which the data source is from some specific and massive financial data, instead of the information from the internet?
ChatGPT summary :
Sure, here's a textual summary of the tutorial on useful Excel add-ins:
1. **AI.ASK Formula**: This feature allows you to ask questions directly in Excel using the AI.ASK formula. It can provide answers to simple queries and even draft emails based on prompts.
2. **AI.FILL Formula**: The AI.FILL formula helps in auto-filling data based on examples provided above. It's useful for completing lists of data or populating tables with consistent information.
3. **AI.EXTRACT Formula**: Similar to Flash Fill, AI.EXTRACT helps extract specific information from text strings. It's particularly useful when dealing with inconsistent data formats.
4. **AI.TRANSLATE Formula**: With the AI.TRANSLATE formula, you can translate text from one language to another directly within Excel. It's a handy tool for multilingual users.
5. **AI.TABLE Formula**: AI.TABLE generates tables based on prompts provided. It can create structured tables from data or even generate tables with random data.
Bonus Feature: **AI in PowerPoint**: The AI add-in also works in PowerPoint, allowing you to generate slides based on prompts. It can create presentations on various topics, although some manual tweaking might be needed for design.
These add-ins leverage AI technology to automate tasks, enhance productivity, and provide valuable insights directly within Excel and PowerPoint.
Its good . Dude this chatgpt excel can support persian language?
bro, pls kindly advise formula for say in currency
ex : 1,000 be One Thousand
i hope u can advise the formula.
thank you
Hello, thank you for sharing your knowledge, I have a question how I can obtain the lowest number that is repeated the most. That is: Ex: 0, 1, 2, 2, 4, 5, 6, 1. In this case the lowest number that is repeated the most is 1.
Do we need to be paid member in chat gpt to leverage these features?
I have excel 14.7.7 what are you using?
Hi Kenji, I am able to get all kinds of info using formula AI.ASK but in the result I did not receive image/pic. Could you please suggest me how to get image with answer.
This is super cool 👍
Yupp 🚀
Hi, i can't find the ChatGpt in excel 2016. what else can i use????
productivity 10X
@KenjiExplains It says I have 50 AI calls for free within trial version. Is it total or 50 a day?
Thank you. Wow more.
Thanks for watching!
Is this applicable online?
The current functionality is not fully compatible with my requirements. Specifically, it only provides a single cell as the output.
unable to add add ins how to do it is telling that failed to install custom functions even though iam having good internet connections please tell what to do
I am getting an error message when I try. Does it need to be formatted exactly like this?
im not find ai add ins in my excel sheet
Vwhat ELSE can excel do that ive never heard of? It would be nice if these things were mentioned in theuser manual instead of a quick blurb about the simple and self evident tasks, up in the ribbon
Please record a video on date type data in excel. I have a big excel file in which the date column has lots of different formats such as m-d-y and d-m-y and the regular ways do not work for me to fix it😢.
Try Ctrl 1 and try to change the format to date if that that does not work maybe try to custom formats
I would try to combine some date functions. Try year(), month(), day() to extract the right values (it might not be possible depending on the formatting) and then date(year, month, day) to combine back. Otherwise I would try ai.extract first and then same last steps.
That's right you ask the AI so that you can gauge how AI answers from the many right answers programmed and unprogrammed from AI own branchings of learnings inorder to gauge if AI progress by information or self thinking or if there's derangements dictated by the spiritual intrusions and to gauge how AI thinks and to know AI mindset in real time. You ask AI
doesnt work for me - my organization has disabled access to office store so I cant "Add-In"
This will not work in excel version 2016
Should I update my excel version to use this AI Function or its work on Excel 2016 ?
❤
It's Free upto 50 AI message... beyond that chargeable..can you suggest for completely free AI tool for excel
Course fee must be in Indian currency and rate like wise
why dont you say if its free for life time or trail use only?
Whats the point of that if you can just go to chat gbt
At first i was also amazed by this tools, but after few attempts it asked me your trail period is over.
Disclaimer Not free
Hey, I mention that at the start of the video that I'm on the trial version
Great information. Music is distracting.
Thank you for the feedback. Would you prefer it turned down or completely off?
Better hope that translation is accurate.
how much is the full version one?
about 12$
NOT ABLE TO FIND THESE FORMULA IN MY EXCEL, PLEASE GUIDE
I'm not able to see the add-in button in Excel
It's very hard to find. You have to go into one of the drop down menus, because the button is only on the ribbon if the ribbon is customized by the user. Or something like that.
Sir, please teach in Hindi or with subtitles in Hindi, thanks.
OMG
🚀🚀🚀
This add-in is free life time??
I haven't used it but I believe it uses your ChatGPT account and the credits you may have previously bought for it.
Thank you for the always very excellent presentation, Kenji.
However, the new AI is very underwhelming imo.
On top of that, what does a photo of two black children have to do with either Messi or Ronaldo?
This add-in is not free for lifetime. One has to pay to Microsoft after the trial period.
You literally can't use the same formula symbol for every single formula in your application
But the question is is it free ?
of course not
only 25 ai calls are free
This is why I hate automation
wow!!!
Not working 🥲