This’ll definitely be useful for figuring other people’s complicated formulas out more quickly. Cheers!

@MyOnlineTrainingHub

Жыл бұрын

Great to hear!

Thanks for finding this! I will check it out. I appreciate you explaining what to watch out for too.

@MyOnlineTrainingHub

Жыл бұрын

My pleasure, Grainne!

This is great stuff! Love the new format you're using for your into/explanations, by the way!

@MyOnlineTrainingHub

Жыл бұрын

Awesome, thank you!

Hi Mynda, As always well prepared and informative, with lot of inspiration - thanks

@MyOnlineTrainingHub

Жыл бұрын

Thanks so much, Ivan!

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.

@MyOnlineTrainingHub

Жыл бұрын

Have fun!

WOW! Impressive 👏 I must test it in French and do a video for my channel 😉

@MyOnlineTrainingHub

Жыл бұрын

Have fun with it, Frederic 😊

Love your vids, always learn something 👍

@MyOnlineTrainingHub

Жыл бұрын

Awesome, thank you!

Very very cool, thanks Mynda!!

@MyOnlineTrainingHub

Жыл бұрын

Cheers, Chris!

Hi Mynda. I like your new Intro format. So Pro.

@MyOnlineTrainingHub

Жыл бұрын

Yay! Thank you! 😊

Another amazing topic for day...Thank you very much, Mam!... More power to you...

@MyOnlineTrainingHub

Жыл бұрын

Thank you!

This is great! Thank you Mynda!

@MyOnlineTrainingHub

Жыл бұрын

You're so welcome!

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.

@MyOnlineTrainingHub

Жыл бұрын

Thank you!

Now, this implementation seems quite useful and handy. Nice. :-)

@MyOnlineTrainingHub

Жыл бұрын

Glad you think so!

Brand-new information as usual. Time to brake old habits)

@MyOnlineTrainingHub

Жыл бұрын

Enjoy!

Wow. It makes joyful experience for advance excel user.

@MyOnlineTrainingHub

Жыл бұрын

Glad you like it!

Thanks a ton ..this is going to be super useful

@MyOnlineTrainingHub

Жыл бұрын

Great to hear!

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

@MyOnlineTrainingHub

Жыл бұрын

Indeed. We already have some AI built into Excel in the form of the Analyze tool which produces charts and PivotTables.

Thank you so much .

@MyOnlineTrainingHub

Жыл бұрын

You're most welcome 😊

Thank you, this is very helpful.

@MyOnlineTrainingHub

Жыл бұрын

Great to hear!

So Great! Thank you.

@MyOnlineTrainingHub

Жыл бұрын

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.

@MyOnlineTrainingHub

Жыл бұрын

Very kind of you, Sergio 🙏

Thank you so much for this

@MyOnlineTrainingHub

Жыл бұрын

My pleasure 😊

Spooky but cool. Will give it a try. Thanks for posting.

@MyOnlineTrainingHub

Жыл бұрын

Have fun!

Very helpful ideas.. Thanks

@MyOnlineTrainingHub

Жыл бұрын

Most welcome 😊

Well done Lady 🌻💎🌻

@MyOnlineTrainingHub

Жыл бұрын

Thank you!

Thank you for this interesting Video 📹 👍

@MyOnlineTrainingHub

Жыл бұрын

Glad you enjoyed it 😊

awesomeeeeee ty

@MyOnlineTrainingHub

Жыл бұрын

Glad you like it!

Interesting and thanks. Watson personalized.

@MyOnlineTrainingHub

8 ай бұрын

Thanks for watching! 😊

Muchas gracias por toda esa valiosa información.

@MyOnlineTrainingHub

Жыл бұрын

My pleasure 😊

Thank you Mynda for this introduction. This appears promising, but wonder, how it will affect individuals abilities to learn and apply on their own...

@MyOnlineTrainingHub

Жыл бұрын

Thanks, Vijay. I guess some people will be lazy and rely on the AI and for others it will accelerate their learning 🤔

Perfectttttttt ❤❤

@MyOnlineTrainingHub

Жыл бұрын

Thanks so much 🙏

This is a game changer

@MyOnlineTrainingHub

Жыл бұрын

Sure is!

Awesome

@MyOnlineTrainingHub

Жыл бұрын

Thank you!

❤ next evolution I'll just think what I want 👍😎✊

@MyOnlineTrainingHub

Жыл бұрын

😁now that would be scary!

Cool

@MyOnlineTrainingHub

Жыл бұрын

Glad you like it 😊

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

@MyOnlineTrainingHub

Жыл бұрын

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: kzread.info/dash/bejne/YoaClaiTppbdaJc.html

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?

@MyOnlineTrainingHub

Жыл бұрын

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?

@MyOnlineTrainingHub

5 ай бұрын

It should do, but others have reported that this app is no longer free, so I wonder if that's the issue.

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.

@MyOnlineTrainingHub

11 ай бұрын

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.

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

@MyOnlineTrainingHub

Жыл бұрын

It's a third party add-in.

@anaballesteros-sosa4007

Жыл бұрын

@@MyOnlineTrainingHub thank you

Hello Mynda, Will the ai-aided formula editor work with Excel 2013? If so are there any issues that cause Excel to stop functioning?

@tiecheng-excelprogramming2370

Жыл бұрын

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.

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)

@MyOnlineTrainingHub

Жыл бұрын

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.

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

@tiecheng-excelprogramming2370

Жыл бұрын

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.

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.

@MyOnlineTrainingHub

Жыл бұрын

Sorry to hear you're having trouble inserting add-ins. Frustrating!

Hi Mynda, How this add in is superior as comapred to chat GPT

@tiecheng-excelprogramming2370

Жыл бұрын

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 (:

@tiecheng-excelprogramming2370

Жыл бұрын

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.

Is it only available for formulas in English? Thank you Mynda.

@tiecheng-excelprogramming2370

Жыл бұрын

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.

@IvanCortinas_ES

Жыл бұрын

@@tiecheng-excelprogramming2370 Thank you Tie Cheng.

@tiecheng-excelprogramming2370

Жыл бұрын

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.

@IvanCortinas_ES

Жыл бұрын

@@tiecheng-excelprogramming2370 Thank you!!

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

@MyOnlineTrainingHub

Жыл бұрын

Perhaps you're not logged into Excel and or not connected to the internet.

I enabled the add-in but submit is not enabled in editor .What can be the issue ?

@MyOnlineTrainingHub

4 ай бұрын

Not sure, sorry. Best to reach out to the add-in creator.

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

@MyOnlineTrainingHub

Жыл бұрын

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.

@tiecheng-excelprogramming2370

Жыл бұрын

Excel 2013 does not have it; at least try Excel 2016, 2019 or 365.

Porque no se activa la opción submit en AI-aided Formula Editor

@MyOnlineTrainingHub

9 ай бұрын

Not sure, sorry.

@edgarbeimarajatazambrana1824

9 ай бұрын

Muchas gracias

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

@MyOnlineTrainingHub

Жыл бұрын

There should be buttons at the top for 'AI Generator' and 'Cell Formula".

Unable to search in Office Add-in, AI-aided formula editor not found

@tiecheng-excelprogramming2370

Жыл бұрын

Hi Rahul, which version of Excel are you using? Additionally, you can always find it in Excel Online in a browser.

@rahulsharmakota

Жыл бұрын

@@tiecheng-excelprogramming2370 Office 2016

This has now gone to a subscription model. The free version now has limited AI access and only 15 queries a month.

@MyOnlineTrainingHub

Жыл бұрын

Thanks for letting us know.

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. 😞

@tiecheng-excelprogramming2370

Жыл бұрын

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.

@MyOnlineTrainingHub

Жыл бұрын

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.

@tiecheng-excelprogramming2370

Жыл бұрын

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.

How to uninstall the add-in?

@tiecheng-excelprogramming2370

Жыл бұрын

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.

@formadordinismedeiros

Жыл бұрын

@@tiecheng-excelprogramming2370 THANKS.

My excel keep crashing when I try to insert add-ins, good tool, but I think Chat GPT does it better

@MyOnlineTrainingHub

Жыл бұрын

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 do I uninstall it?

@tiecheng-excelprogramming2370

Жыл бұрын

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.

@julie_chen

Жыл бұрын

@@tiecheng-excelprogramming2370 Thank you. I found it eventually. Keeping it and will try to use it.

this is no longer free?

@MyOnlineTrainingHub

7 ай бұрын

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.

@tiecheng-excelprogramming2370

Жыл бұрын

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.

@MyOnlineTrainingHub

Жыл бұрын

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.

@MyOnlineTrainingHub

Жыл бұрын

My pleasure 😊