Game changer! I'll point it at some of my old, somewhat complicated, formulas I've never bothered to update (if it ain't broke...) and see what happens.
thanks for this useful video! This is going to be the future working with MS Excel - other AI aided features for other applications are on the way or already available (Power BI for example). Looking forward to your next videos. Cheers and kind regards from Berlin
This was helpful but it is suggesting that you upgrade to chat gpt 4. It also took a couple tries to get the exact formula I needed which the result was in two separate columns to separate text from numbers. For example, if you had a column with numbers and text and you wanted the formula to separate the numbers in one column and put the text in the cell next to it. Might take some getting used to depending on your level of experience with excel and formula's.
4:00, interesting, could use SUM instead of SUMPRODUCT. Both work for "and" aka "*", but both fail for "or" aka "+". Is there a way to make SUMPRODUCT work with "or"? If not, would you consider ROWS(FILTER( )) the best alternative?
I gave it a try and wasn't very impressed. First of all, it's in English and the functions will be in English too so they wouldn't work in my German Excel. I could (and often do) switch languages and hopefully they'll add other languages in the future. But I asked it to create a lookup. My data was in a table and I used the column header name to tell it which column I wanted. It did came up with a VLOOK but the column number was a 2 even though the one I wanted was in column 5. I remember seeing the first machine-based translations. They were awful. But the quality has really improved in the last 20 years. So I guess we'll have to give this add-on more time and it might become really useful
Hi Enny, we just released a new version with better support of non-English languages. Now, AI will generate formulas with functions in German if other formulas of your Excel are in German. And more accurate recognition of headers and labels is indeed important and a hard task, we continue to work on that. Thank you.
this is lovely , but i have a question can this be used to convert a column from text date to a proper date/time format for example from( 7th January 2023 ) to (1/7/2023) . Gracias as i anticipate your response
Glad you like it! The AI formula editor can't see the data in your spreadsheet, so no. You're best to use Power Query to fix your date formats: ruclips.net/video/0RN3FZv3w84/видео.html
Thanks for introducing, Downloaded the add-in and try. However, its violating the company policy and have to remove... May I know how to remove this "AI-aided Formula Editor" add-in? (i cannot found this add-in in the excel--> option --> addins)
That's a shame. To uninstall, go to the Insert tab > My Add-ins. In Office Add-ins, click the 3 dots ellipsis menu next to the Add-in > click Remove > Read the notice that appears regarding other devices and click Remove.
Again I've been set off on the path of "How do I get Add-ins to work" and another half day of frustration and no result. Well, except maybe my PowerShell and M365 Admin skills are improved. The Formula Editor looks good tho, from what I remember of that.
That depends on the add-in you want to add. If it always happens, it may be due to Internet setting. For example, try to use `TLS 1.2` in Internet Options.
Hi Sunil, at the moment the add-in is linked to "OpenAI Codex", which has been trained especially for programming and code generation. "OpenAI ChatGPT" is more for conversational and general purposes. In the future, the tool will be linked to several models (e.g., Bard of Google).
Iván, at the moment, you can append "write the formula in Spanish" after the description. Indeed, in later versions, we will be able to return formulas in the language of Excel of the users.
Hi Iván, we just released a new version with better language support. Now, AI formula generation accepts text descriptions in both English and non-English languages; AI will generate formulas with functions in the language of other formulas in your Excel.
Type in "ai-aided formula editor" and it should be third in the list when sorted by popularity. If you don't see it then it may not be available for your language.
I added the formula editor , but when I open it , what opens on the right side does not allow me to wrile. It says ai aided formula editor but nothing more
as with all AIs these days, don't hesitate to "get a degree in prompt engineering, bro" for me it was only useful at more quickly figuring out the 27km of nested if functions from people who love headaches more than I do (and are lazy employees, obviously not consultants) Nonetheless thank you for the video, it's always great to listen to you Mynda, really appreciated.
I clicked on the arrow button to send the answer to the cell (and I was parked in a particular cell) but nothing happens. However, when I hover over the generated formula it shows the correct answer. 😞
When a formula in the editor is syntactically wrong, there should be red-underlined warnings, then clicking on the arrow button will not write the formula to the selected well. Please check if it's your case.
I found this sometimes happened to me too, and it appears to be when I selected a different cell to the one I originally chose after generating the formula. The only way around it that I found was to start again.
I see what may happen. When a formula in the editor has different argument separator (e.g., semicolon) than your Excel (e.g., comma), there is no red-underlined warning, but it cannot be written to a cell because your Excel does not consider it valid. We will 1) force to generate a formula with the right separator; 2) show a warning if the formula in the editor is not syntactically correct with the separator of your Excel.
Not sure why it would be crashing. You can test other add-ins to see if you have the same issue, then you'll know if it's Excel or the add-in. You might just need to update Excel.
Hi, to uninstall an add-in, 1) Click the "Insert" tab, and then click "My Add-ins". 2) In Office Add-ins, click the 3 dots menu next to the Add-in. 3) Click Remove. 4) Read the notice that appears regarding other devices and click Remove.
Hello Julie, to uninstall an add-in, 1) Click the "Insert" tab, and then click "My Add-ins". 2) In Office Add-ins, click the 3 dots menu next to the Add-in. 3) Click Remove. 4) Read the notice that appears regarding other devices and click Remove.
Unfortunately, this add-in does not take regional settings into account. My computer is set to use semi-colon as list and formula separator, but this is not supported. So basically useless. Also not impressed by the formulas generated that are prone to errors and incomplete, and like you said still use "old" Excel syntax (Index/match and not Xlooklup for example) . Maybe revisit in a few months or years when things will be improved.
Hi Olivier, we just released a new version with better support of semi-colon as list separator for AI generated formulas. Previously, AI did not always generate a formula with the right list separator, now we systematically amend such formulas after AI generation. Otherwise, the editor always supports semi-colon as list separator. I would like to invite you to revisit the tool. Thank you.
*A lot of the new features in Excel are a complete waste of time! Excel should introduce functions that are time-efficient and practical, instead of gimmicks that most never need.*
This’ll definitely be useful for figuring other people’s complicated formulas out more quickly. Cheers!
Great to hear!
Game changer! I'll point it at some of my old, somewhat complicated, formulas I've never bothered to update (if it ain't broke...) and see what happens.
Have fun!
Thanks for finding this! I will check it out. I appreciate you explaining what to watch out for too.
My pleasure, Grainne!
Hi Mynda,
As always well prepared and informative, with lot of inspiration - thanks
Thanks so much, Ivan!
This is great stuff! Love the new format you're using for your into/explanations, by the way!
Awesome, thank you!
Very very cool, thanks Mynda!!
Cheers, Chris!
This is great! Thank you Mynda!
You're so welcome!
Love your vids, always learn something 👍
Awesome, thank you!
Wow. It makes joyful experience for advance excel user.
Glad you like it!
Hi Mynda. I like your new Intro format. So Pro.
Yay! Thank you! 😊
Another amazing topic for day...Thank you very much, Mam!... More power to you...
Thank you!
Thank you so much .
You're most welcome 😊
So Great! Thank you.
Glad you liked it!
Mynda, I'm going to publish my version in spanish, based on this video. Obviously I´m going to mention you.
Very kind of you, Sergio 🙏
Thank you so much for this
My pleasure 😊
Brand-new information as usual. Time to brake old habits)
Enjoy!
Thanks a ton ..this is going to be super useful
Great to hear!
Hi Mynda. Quality video as usual. I have recently created a spreadsheet with some very complicated SUMIFS. I wish I'd seen this video first.
Thank you!
Very helpful ideas.. Thanks
Most welcome 😊
Thank you, this is very helpful.
Great to hear!
Interesting and thanks. Watson personalized.
Thanks for watching! 😊
Muchas gracias por toda esa valiosa información.
My pleasure 😊
This is a game changer
Sure is!
Now, this implementation seems quite useful and handy. Nice. :-)
Glad you think so!
Well done Lady 🌻💎🌻
Thank you!
Thank you Mynda for this introduction. This appears promising, but wonder, how it will affect individuals abilities to learn and apply on their own...
Thanks, Vijay. I guess some people will be lazy and rely on the AI and for others it will accelerate their learning 🤔
awesomeeeeee ty
Glad you like it!
thanks for this useful video! This is going to be the future working with MS Excel - other AI aided features for other applications are on the way or already available (Power BI for example). Looking forward to your next videos. Cheers and kind regards from Berlin
Indeed. We already have some AI built into Excel in the form of the Analyze tool which produces charts and PivotTables.
Thank you for this interesting Video 📹 👍
Glad you enjoyed it 😊
WOW! Impressive 👏 I must test it in French and do a video for my channel 😉
Have fun with it, Frederic 😊
Spooky but cool. Will give it a try. Thanks for posting.
Have fun!
Perfectttttttt ❤❤
Thanks so much 🙏
Awesome
Thank you!
❤ next evolution I'll just think what I want 👍😎✊
😁now that would be scary!
This was helpful but it is suggesting that you upgrade to chat gpt 4. It also took a couple tries to get the exact formula I needed which the result was in two separate columns to separate text from numbers. For example, if you had a column with numbers and text and you wanted the formula to separate the numbers in one column and put the text in the cell next to it. Might take some getting used to depending on your level of experience with excel and formula's.
Thanks for the feedback. It's great to see you gave it a go. It's a work in progress. I'm sure as the AI evolves it'll only get better.
Cool
Glad you like it 😊
4:00, interesting, could use SUM instead of SUMPRODUCT. Both work for "and" aka "*", but both fail for "or" aka "+". Is there a way to make SUMPRODUCT work with "or"? If not, would you consider ROWS(FILTER( )) the best alternative?
Yes, the or operator is +, just as the and operator is *.
Hello, thanks for the video. I tried the add ins, however my IA aided formula is blank when it opens. Does it support Office 2019?
It should do, but others have reported that this app is no longer free, so I wonder if that's the issue.
I gave it a try and wasn't very impressed. First of all, it's in English and the functions will be in English too so they wouldn't work in my German Excel. I could (and often do) switch languages and hopefully they'll add other languages in the future. But I asked it to create a lookup. My data was in a table and I used the column header name to tell it which column I wanted. It did came up with a VLOOK but the column number was a 2 even though the one I wanted was in column 5.
I remember seeing the first machine-based translations. They were awful. But the quality has really improved in the last 20 years. So I guess we'll have to give this add-on more time and it might become really useful
Hi Enny, we just released a new version with better support of non-English languages. Now, AI will generate formulas with functions in German if other formulas of your Excel are in German. And more accurate recognition of headers and labels is indeed important and a hard task, we continue to work on that. Thank you.
this is lovely , but i have a question can this be used to convert a column from text date to a proper date/time format
for example from( 7th January 2023 ) to (1/7/2023)
. Gracias as i anticipate your response
Glad you like it! The AI formula editor can't see the data in your spreadsheet, so no. You're best to use Power Query to fix your date formats: ruclips.net/video/0RN3FZv3w84/видео.html
Thank you. It looks very easy to use. Is thus add in an excel add in or is a 3rd party that developed this feature? Thank you
It's a third party add-in.
@@MyOnlineTrainingHub thank you
Thanks for introducing, Downloaded the add-in and try. However, its violating the company policy and have to remove... May I know how to remove this "AI-aided Formula Editor" add-in? (i cannot found this add-in in the excel--> option --> addins)
That's a shame. To uninstall, go to the Insert tab > My Add-ins. In Office Add-ins, click the 3 dots ellipsis menu next to the Add-in > click Remove > Read the notice that appears regarding other devices and click Remove.
Again I've been set off on the path of "How do I get Add-ins to work" and another half day of frustration and no result. Well, except maybe my PowerShell and M365 Admin skills are improved.
The Formula Editor looks good tho, from what I remember of that.
Sorry to hear you're having trouble inserting add-ins. Frustrating!
Hello Mynda, Will the ai-aided formula editor work with Excel 2013? If so are there any issues that cause Excel to stop functioning?
Hi Dwight, Excel 2013 does not support Excel JavaScript API 1.2 that the add-in is built with. The add-in requires at least Excel 2016. Thank you.
HI, I'm getting an error like "Error loading the add-on" every time I want to download an addin. do you know why is that?
thanks a lot (:
That depends on the add-in you want to add. If it always happens, it may be due to Internet setting. For example, try to use `TLS 1.2` in Internet Options.
Hi Mynda,
How this add in is superior as comapred to chat GPT
Hi Sunil, at the moment the add-in is linked to "OpenAI Codex", which has been trained especially for programming and code generation. "OpenAI ChatGPT" is more for conversational and general purposes. In the future, the tool will be linked to several models (e.g., Bard of Google).
Hey when I m adding it into my excel , it is showing can't connect to the catalog , pls find me a solution for this
Perhaps you're not logged into Excel and or not connected to the internet.
Is it only available for formulas in English? Thank you Mynda.
Iván, at the moment, you can append "write the formula in Spanish" after the description. Indeed, in later versions, we will be able to return formulas in the language of Excel of the users.
@@tiecheng-excelprogramming2370 Thank you Tie Cheng.
Hi Iván, we just released a new version with better language support. Now, AI formula generation accepts text descriptions in both English and non-English languages; AI will generate formulas with functions in the language of other formulas in your Excel.
@@tiecheng-excelprogramming2370 Thank you!!
I enabled the add-in but submit is not enabled in editor .What can be the issue ?
Not sure, sorry. Best to reach out to the add-in creator.
Porque no se activa la opción submit en AI-aided Formula Editor
Not sure, sorry.
Muchas gracias
hello mam , I have small question that when I search AI-aided formula editor , I don't get the same? why? could you please guide me for the same
Type in "ai-aided formula editor" and it should be third in the list when sorted by popularity. If you don't see it then it may not be available for your language.
I'm guessing this addin is limited to 365?
I searched for it From Excel 2013. It did not appear, just the second entry.
Excel 2013 does not have it; at least try Excel 2016, 2019 or 365.
This has now gone to a subscription model. The free version now has limited AI access and only 15 queries a month.
Thanks for letting us know.
I added the formula editor , but when I open it , what opens on the right side does not allow me to wrile. It says ai aided formula editor but nothing more
There should be buttons at the top for 'AI Generator' and 'Cell Formula".
as with all AIs these days, don't hesitate to "get a degree in prompt engineering, bro"
for me it was only useful at more quickly figuring out the 27km of nested if functions from people who love headaches more than I do (and are lazy employees, obviously not consultants)
Nonetheless thank you for the video, it's always great to listen to you Mynda, really appreciated.
My pleasure 😊
Unable to search in Office Add-in, AI-aided formula editor not found
Hi Rahul, which version of Excel are you using? Additionally, you can always find it in Excel Online in a browser.
@@tiecheng-excelprogramming2370 Office 2016
I clicked on the arrow button to send the answer to the cell (and I was parked in a particular cell) but nothing happens. However, when I hover over the generated formula it shows the correct answer. 😞
When a formula in the editor is syntactically wrong, there should be red-underlined warnings, then clicking on the arrow button will not write the formula to the selected well. Please check if it's your case.
I found this sometimes happened to me too, and it appears to be when I selected a different cell to the one I originally chose after generating the formula. The only way around it that I found was to start again.
I see what may happen. When a formula in the editor has different argument separator (e.g., semicolon) than your Excel (e.g., comma), there is no red-underlined warning, but it cannot be written to a cell because your Excel does not consider it valid. We will 1) force to generate a formula with the right separator; 2) show a warning if the formula in the editor is not syntactically correct with the separator of your Excel.
My excel keep crashing when I try to insert add-ins, good tool, but I think Chat GPT does it better
Not sure why it would be crashing. You can test other add-ins to see if you have the same issue, then you'll know if it's Excel or the add-in. You might just need to update Excel.
How to uninstall the add-in?
Hi, to uninstall an add-in, 1) Click the "Insert" tab, and then click "My Add-ins". 2) In Office Add-ins, click the 3 dots menu next to the Add-in. 3) Click Remove. 4) Read the notice that appears regarding other devices and click Remove.
@@tiecheng-excelprogramming2370 THANKS.
How do I uninstall it?
Hello Julie, to uninstall an add-in, 1) Click the "Insert" tab, and then click "My Add-ins". 2) In Office Add-ins, click the 3 dots menu next to the Add-in. 3) Click Remove. 4) Read the notice that appears regarding other devices and click Remove.
@@tiecheng-excelprogramming2370 Thank you. I found it eventually. Keeping it and will try to use it.
this is no longer free?
That's a shame 😔
Unfortunately, this add-in does not take regional settings into account. My computer is set to use semi-colon as list and formula separator, but this is not supported. So basically useless. Also not impressed by the formulas generated that are prone to errors and incomplete, and like you said still use "old" Excel syntax (Index/match and not Xlooklup for example) . Maybe revisit in a few months or years when things will be improved.
Hi Olivier, we just released a new version with better support of semi-colon as list separator for AI generated formulas. Previously, AI did not always generate a formula with the right list separator, now we systematically amend such formulas after AI generation. Otherwise, the editor always supports semi-colon as list separator. I would like to invite you to revisit the tool. Thank you.
Not free anymore.
That's a shame!
*A lot of the new features in Excel are a complete waste of time! Excel should introduce functions that are time-efficient and practical, instead of gimmicks that most never need.*