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
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?
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.
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.
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.
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).
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.
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.
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 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.
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
I downloaded the add-in, but mine doesn't work. It just gives me a blank, white box on the right when I open it. I then downloaded another AI add-in (Rosie). I gave Rosie a long, complex SUMPRODUCT formula. I already know what the formula does and how it works, but I wanted to see how Rosie explains it anyway. I am impressed by how Rosie could identify abbreviations I used in Table Headers and referred to those headers by their full name (not the abbreviation I have actually written in the header cells). But because I already know how the formula works, I know that I can explain it better than Rosie 😅 I would really love to get the add-in (the one you showed us) working so I can compare it to Rosie. I think yours would work better than Rosie 😊
Sounds like the functionality of this add-in may have changed since the video was recorded. You can try reaching out to the add-in creator for support.
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.
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.
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.
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.
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.*
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.
This’ll definitely be useful for figuring other people’s complicated formulas out more quickly. Cheers!
Great to hear!
Hi Mynda. I like your new Intro format. So Pro.
Yay! Thank you! 😊
Very very cool, thanks Mynda!!
Cheers, Chris!
Hi Mynda,
As always well prepared and informative, with lot of inspiration - thanks
Thanks so much, Ivan!
Thanks for finding this! I will check it out. I appreciate you explaining what to watch out for too.
My pleasure, Grainne!
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!
WOW! Impressive 👏 I must test it in French and do a video for my channel 😉
Have fun with it, Frederic 😊
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 🙏
Brand-new information as usual. Time to brake old habits)
Enjoy!
Wow. It makes joyful experience for advance excel user.
Glad you like it!
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!
Now, this implementation seems quite useful and handy. Nice. :-)
Glad you think so!
Thank you so much .
You're most welcome 😊
This is great! Thank you Mynda!
You're so welcome!
Very helpful ideas.. Thanks
Most welcome 😊
This is a game changer
Sure is!
Well done Lady 🌻💎🌻
Thank you!
This is great stuff! Love the new format you're using for your into/explanations, by the way!
Awesome, thank you!
Spooky but cool. Will give it a try. Thanks for posting.
Have fun!
Thank you, this is very helpful.
Great to hear!
Interesting and thanks. Watson personalized.
Thanks for watching! 😊
Love your vids, always learn something 👍
Awesome, thank you!
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.
Another amazing topic for day...Thank you very much, Mam!... More power to you...
Thank you!
So Great! Thank you.
Glad you liked it!
Thanks a ton ..this is going to be super useful
Great to hear!
Thank you so much for this
My pleasure 😊
Muchas gracias por toda esa valiosa información.
My pleasure 😊
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 *.
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 🤔
Thank you for this interesting Video 📹 👍
Glad you enjoyed it 😊
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.
@@tiechengspreadsheets 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.
@@tiechengspreadsheets Thank you!!
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.
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.
❤ 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.
Perfectttttttt ❤❤
Thanks so much 🙏
awesomeeeeee ty
Glad you like it!
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).
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.
Awesome
Thank you!
Porque no se activa la opción submit en AI-aided Formula Editor
Not sure, sorry.
Muchas gracias
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.
Ai and chat gpt in which version of excel to add ins
Add-ins work in all current versions of Excel.
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!
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.
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.
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.
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.
@@tiechengspreadsheets Office 2016
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.
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".
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.
I downloaded the add-in, but mine doesn't work. It just gives me a blank, white box on the right when I open it.
I then downloaded another AI add-in (Rosie). I gave Rosie a long, complex SUMPRODUCT formula. I already know what the formula does and how it works, but I wanted to see how Rosie explains it anyway. I am impressed by how Rosie could identify abbreviations I used in Table Headers and referred to those headers by their full name (not the abbreviation I have actually written in the header cells). But because I already know how the formula works, I know that I can explain it better than Rosie 😅
I would really love to get the add-in (the one you showed us) working so I can compare it to Rosie. I think yours would work better than Rosie 😊
Sounds like the functionality of this add-in may have changed since the video was recorded. You can try reaching out to the add-in creator for support.
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.
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.
Cool
Glad you like it 😊
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.
@@tiechengspreadsheets Thank you. I found it eventually. Keeping it and will try to use it.
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.
@@tiechengspreadsheets THANKS.
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.
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.*
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 😊