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 👌👌
Usually I watch less video in English but After watching this video I become your channel fan. This is amazing and next level of working with Ai. Thank You.
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.
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.
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.
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
So powerful. So frustrating though when your organisation blocks the add-in store due to security reasons. Many of us won't be able to use this because of corporate policies.
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
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?
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.
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.
Hello Sir, I am one query regarding Excel. I am unable to enable the "Analyze Data" option into excel home tab. Can you Please help me, how can I enable it??
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.
I'd recommend counting the number of times a number repeats in a different cell, then use a different formula or color to identify the lowest number with the highest count
📝 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
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😢.
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.
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
@@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.
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
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
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.
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?
🔥 Take our Excel Course here: www.careerprinciples.com/courses/excel-for-business-finance
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
I just want to say a huge thank you for your amazing all Excel videos. It helped me a lot and improve my skills.
Usually I watch less video in English but After watching this video I become your channel fan. This is amazing and next level of working with Ai. Thank You.
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 Ai new function is so cool. Totally game changing, it can replace a lot of formula we use to remember. Thanks for sharing Kenji.
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.
Holy cow this is outstanding! Thank you!
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.
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?
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.
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
So powerful. So frustrating though when your organisation blocks the add-in store due to security reasons. Many of us won't be able to use this because of corporate policies.
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 is extremely useful! thanks for uploading!
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
This is really amazing. I did not know any of them. Thank you so much 😍
Thank you!
Thank you for sharing, too helpful!
Thanks bhai Kenji from India❤
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?
Is it possible to remove select words or numbers from a list of sentences which have those?
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 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.
Hello Sir, I am one query regarding Excel. I am unable to enable the "Analyze Data" option into excel home tab. Can you Please help me, how can I enable it??
I liked this particular video very much Because you provided exclusive things
That....was...crazy! I didn't know this existed. THX
Do we need to be paid member in chat gpt to leverage these features?
Blown away!
Awesome ! Thank you Kenji !
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.
I'd recommend counting the number of times a number repeats in a different cell, then use a different formula or color to identify the lowest number with the highest count
@KenjiExplains It says I have 50 AI calls for free within trial version. Is it total or 50 a day?
📝 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
I have excel 14.7.7 what are you using?
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.
Vídeo Sensacional. Parabéns
Really an awesome tutor 😊
bro, pls kindly advise formula for say in currency
ex : 1,000 be One Thousand
i hope u can advise the formula.
thank you
Thanks for this video, a wonderful and smooth explanation
Glad it was helpful!
whatever you have shared in this video is totally new for me, thanks a lot for sharing
Thank you!
I am getting an error message when I try. Does it need to be formatted exactly like this?
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
Its good . Dude this chatgpt excel can support persian language?
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.
The current functionality is not fully compatible with my requirements. Specifically, it only provides a single cell as the output.
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
Is this applicable online?
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 ?
What a great hack!! Thanks Kenji
thank you
It's Free upto 50 AI message... beyond that chargeable..can you suggest for completely free AI tool for excel
Hi, i can't find the ChatGpt in excel 2016. what else can i use????
This is awesome!
Fantastic Kenji
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
I'm excited to learn sir
Thank you, it is helpful
why dont you say if its free for life time or trail use only?
good and informative video
doesnt work for me - my organization has disabled access to office store so I cant "Add-In"
Simply brilliant
Literally amazing
Great video and examples
Glad you like them!
im not find ai add ins in my excel sheet
My home tab have no ad icons
Whats the point of that if you can just go to chat gbt
productivity 10X
Wow this is great
Course fee must be in Indian currency and rate like wise
How to convert number currency 1.200 USD to text
Amazing 👍🏿
Great video! Thanks!
Amazing
Amazing! Great quality!
Thank you!
Great information. Music is distracting.
Thank you for the feedback. Would you prefer it turned down or completely off?
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
This is super cool 👍
Yupp 🚀
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.
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.
NOT ABLE TO FIND THESE FORMULA IN MY EXCEL, PLEASE GUIDE
Better hope that translation is accurate.
Thank you. Wow more.
Thanks for watching!
how much is the full version one?
about 12$
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?
❤
But the question is is it free ?
of course not
lol - I can just do this on chat GPT! Why create all this on an excel when we're opening hundreds of DIFFERENT excels on a weekly basis?!
You literally can't use the same formula symbol for every single formula in your application
This add-in is not free for lifetime. One has to pay to Microsoft after the trial period.
only 25 ai calls are free
OMG
🚀🚀🚀
This is why I hate automation
Not working 🥲
wow!!!