Відео

Certifications ?

Qué idiomas soporta el complemento? Gracias

The 'AI Chat Copilot' feature is available in both the 'AI-aided Formula Editor' and 'Spreadsheet AI' add-ins. You can install either one. 3 ways to install the 'AI-aided Formula Editor' add-in (website: www.10studio.tech/docs/ai-formula-editor): - Go to appsource.microsoft.com/en-us/product/Office365/WA200001584, and click "Get it now". - In the Microsoft add-ins store in Excel, search "AI-aided Formula Editor", and click "Add". - Follow the link go.microsoft.com/fwlink/?linkid=2261819&templateid=WA200001584&templatetitle=AI-aided%20Formula%20Editor to open Excel Online, which will automatically add the add-in to your account. Similarly, 3 ways to install the 'Spreadsheet AI' add-in (website: www.10studio.tech/docs/spreadsheet-ai): - Go to appsource.microsoft.com/en-us/product/office/WA200006009, and click "Get it now". - In the Microsoft add-ins store in Excel, search "Spreadsheet AI", and click "Add". - Follow the link go.microsoft.com/fwlink/?linkid=2261819&templateid=WA200006009&templatetitle=Spreadsheet%20AI to open Excel Online, which will automatically add the add-in to your account.

The 'AI Chat Copilot' feature is available in both the 'AI-aided Formula Editor' and 'Spreadsheet AI' add-ins. You can install either one. 3 ways to install the 'AI-aided Formula Editor' add-in (website: www.10studio.tech/docs/ai-formula-editor): - Go to appsource.microsoft.com/en-us/product/Office365/WA200001584, and click "Get it now". - In the Microsoft add-ins store in Excel, search "AI-aided Formula Editor", and click "Add". - Follow the link go.microsoft.com/fwlink/?linkid=2261819&templateid=WA200001584&templatetitle=AI-aided%20Formula%20Editor to open Excel Online, which will automatically add the add-in to your account. Similarly, 3 ways to install the 'Spreadsheet AI' add-in (website: www.10studio.tech/docs/spreadsheet-ai): - Go to appsource.microsoft.com/en-us/product/office/WA200006009, and click "Get it now". - In the Microsoft add-ins store in Excel, search "Spreadsheet AI", and click "Add". - Follow the link go.microsoft.com/fwlink/?linkid=2261819&templateid=WA200006009&templatetitle=Spreadsheet%20AI to open Excel Online, which will automatically add the add-in to your account.

The 'AI Chat Copilot' feature is available in both the 'AI-aided Formula Editor' and 'Spreadsheet AI' add-ins. You can install either one. 3 ways to install the 'AI-aided Formula Editor' add-in (website: www.10studio.tech/docs/ai-formula-editor): - Go to appsource.microsoft.com/en-us/product/Office365/WA200001584, and click "Get it now". - In the Microsoft add-ins store in Excel, search "AI-aided Formula Editor", and click "Add". - Follow the link go.microsoft.com/fwlink/?linkid=2261819&templateid=WA200001584&templatetitle=AI-aided%20Formula%20Editor to open Excel Online, which will automatically add the add-in to your account. Similarly, 3 ways to install the 'Spreadsheet AI' add-in (website: www.10studio.tech/docs/spreadsheet-ai): - Go to appsource.microsoft.com/en-us/product/office/WA200006009, and click "Get it now". - In the Microsoft add-ins store in Excel, search "Spreadsheet AI", and click "Add". - Follow the link go.microsoft.com/fwlink/?linkid=2261819&templateid=WA200006009&templatetitle=Spreadsheet%20AI to open Excel Online, which will automatically add the add-in to your account.

The 'AI Chat Copilot' feature is available in both the 'AI-aided Formula Editor' and 'Spreadsheet AI' add-ins. You can install either one. 3 ways to install the 'AI-aided Formula Editor' add-in (website: www.10studio.tech/docs/ai-formula-editor): - Go to appsource.microsoft.com/en-us/product/Office365/WA200001584, and click "Get it now". - In the Microsoft add-ins store in Excel, search "AI-aided Formula Editor", and click "Add". - Follow the link go.microsoft.com/fwlink/?linkid=2261819&templateid=WA200001584&templatetitle=AI-aided%20Formula%20Editor to open Excel Online, which will automatically add the add-in to your account. Similarly, 3 ways to install the 'Spreadsheet AI' add-in (website: www.10studio.tech/docs/spreadsheet-ai): - Go to appsource.microsoft.com/en-us/product/office/WA200006009, and click "Get it now". - In the Microsoft add-ins store in Excel, search "Spreadsheet AI", and click "Add". - Follow the link go.microsoft.com/fwlink/?linkid=2261819&templateid=WA200006009&templatetitle=Spreadsheet%20AI to open Excel Online, which will automatically add the add-in to your account.

The 'AI Chat Copilot' feature is available in both the 'AI-aided Formula Editor' and 'Spreadsheet AI' add-ins. You can install either one. 3 ways to install the 'AI-aided Formula Editor' add-in (website: www.10studio.tech/docs/ai-formula-editor): - Go to appsource.microsoft.com/en-us/product/Office365/WA200001584, and click "Get it now". - In the Microsoft add-ins store in Excel, search "AI-aided Formula Editor", and click "Add". - Follow the link go.microsoft.com/fwlink/?linkid=2261819&templateid=WA200001584&templatetitle=AI-aided%20Formula%20Editor to open Excel Online, which will automatically add the add-in to your account. Similarly, 3 ways to install the 'Spreadsheet AI' add-in (website: www.10studio.tech/docs/spreadsheet-ai): - Go to appsource.microsoft.com/en-us/product/office/WA200006009, and click "Get it now". - In the Microsoft add-ins store in Excel, search "Spreadsheet AI", and click "Add". - Follow the link go.microsoft.com/fwlink/?linkid=2261819&templateid=WA200006009&templatetitle=Spreadsheet%20AI to open Excel Online, which will automatically add the add-in to your account.

The 'AI Chat Copilot' feature is available in both the 'AI-aided Formula Editor' and 'Spreadsheet AI' add-ins. You can install either one. 3 ways to install the 'AI-aided Formula Editor' add-in (website: www.10studio.tech/docs/ai-formula-editor): - Go to appsource.microsoft.com/en-us/product/Office365/WA200001584, and click "Get it now". - In the Microsoft add-ins store in Excel, search "AI-aided Formula Editor", and click "Add". - Follow the link go.microsoft.com/fwlink/?linkid=2261819&templateid=WA200001584&templatetitle=AI-aided%20Formula%20Editor to open Excel Online, which will automatically add the add-in to your account. Similarly, 3 ways to install the 'Spreadsheet AI' add-in (website: www.10studio.tech/docs/spreadsheet-ai): - Go to appsource.microsoft.com/en-us/product/office/WA200006009, and click "Get it now". - In the Microsoft add-ins store in Excel, search "Spreadsheet AI", and click "Add". - Follow the link go.microsoft.com/fwlink/?linkid=2261819&templateid=WA200006009&templatetitle=Spreadsheet%20AI to open Excel Online, which will automatically add the add-in to your account.

The 'AI Chat Copilot' feature is available in both the 'AI-aided Formula Editor' and 'Spreadsheet AI' add-ins. You can install either one. 3 ways to install the 'AI-aided Formula Editor' add-in (website: www.10studio.tech/docs/ai-formula-editor): - Go to appsource.microsoft.com/en-us/product/Office365/WA200001584, and click "Get it now". - In the Microsoft add-ins store in Excel, search "AI-aided Formula Editor", and click "Add". - Follow the link go.microsoft.com/fwlink/?linkid=2261819&templateid=WA200001584&templatetitle=AI-aided%20Formula%20Editor to open Excel Online, which will automatically add the add-in to your account. Similarly, 3 ways to install the 'Spreadsheet AI' add-in (website: www.10studio.tech/docs/spreadsheet-ai): - Go to appsource.microsoft.com/en-us/product/office/WA200006009, and click "Get it now". - In the Microsoft add-ins store in Excel, search "Spreadsheet AI", and click "Add". - Follow the link go.microsoft.com/fwlink/?linkid=2261819&templateid=WA200006009&templatetitle=Spreadsheet%20AI to open Excel Online, which will automatically add the add-in to your account.

this is looking like a great tool as for me who is just a beginer in this field , despite of my efforts i find data analysis field always brain storming or may be my basics are not clear. ok is it deafault now or we have to pay for it any subscription

Awesome !!!

The examples in the video are very basic. How does the tool benefit someone who is already a power user (i.e. extensive use of complex formulas, VBA, PowerQuery, etc.)?

Great Sir

Bravo Tie, you are definitely one of the most underrated spreadsheet specialist on youtube

Wow ! Great Works

muchas perspectivas para el trabajo rutinario fiscal y de auditoria en México

Fantastic!

Just used the tool today, and i will say it, i loved your product bro! Now i can finally read my big'ol formulas without ever getting confused on where i am on the script 😅 But i have a few questions about your add-on: Does it works 100% in the desktop/app version of Excel 365? Noticed that you used Excel Online to work with the Formula Editor tool, i was able to implement it in the desktop version and use it normally since i possess a licence of Office 365, but i noticed that some functionalities you presented weren't there for me to use, like formula hinting, optimization, error higlighting, quick fix and etc... And does it works with non-english formulas? I'm not sure why these funcionalities i mentioned above weren't working, maybe it has something to do with the language? I'm a Brazilian, so i've set Office 365 and my Microsoft overall enviroment to Portuguese Brazilian since it's my first language, so instead of writing a function as, for example, "IF(FOO;TRUE;FALSE)", i write it as "SE(BAR;VERDADEIRO;FALSO)" Also, i think that you could add some more cool things on your add-on, like a formula auto-complete system just like the one Excel has and an auto cell addressing also similar to the one Excel has

为什么我在excel365中不能实施这样的动态数组？同样输入B1=SORT(A1#)，返回的却是错误值#REF！

Hi Tie cheng, I have add Ai formula editor ,but its not working. can you help me out

Good work @Tie Cheng.

great product! though one problem I have encountered is that when the fomula is very long (in my case over 1000 characters), it seems formula editor no longer works and I have to use the 10studio demo site to format it. Hope you can fix this issue in the future. Otherwise the product is insanly helpful! Thanks a lot

I installed this add in and got it to work once. Every other time it tells me there is an add in error because I have no internet or network connectivity. Well, I am fully connected ... I have tried this on two completely different connections and I get the same error each time. Any advice?

i have been looking for something like this and using an add-on is a lot less daunting than trying to download the whole macro library and import to vbcode for example so ty!

Excellent video !! Thanks and congratulations. I wuold like to have the pdf document Excel Functional Programming - Explore Another Dimension of Spreadsheet Programming.

什么时候更新新视频啊

A very useful video and the application in the same way. I am a Formula Editor user for two years, but these days something is wrong. The app doesn't work. Please your support.

Hi Tie, but these days the app it doesn't work. What happened? Thanks for your prompt response.

very useful!

Oh my gosh. I forgot about the lambda in excel news till now, but found this when searching. This is a really, really good suite you all have made. I'm also super glad your team recognized the educational value in the editor too. I really hated exce and l for all the problems this suite addressed, but now it has the potential to be an extremely powerful, low barrier educational tool. Awesome.

Such a great introduction to arrays! Thank you!

Excellent video. This helps a lot to understand formula editor. Please continue your work, really appreciate it.

57 Views and 100 Subscribers severely undermines the talent you possess and utility of the Formula Editor. But kindly don't let them hold yours passion back. Yours time will come.....Very soon.

Hi Cheng, Thoroughly Appreciate what you are doing ! You are venturing into a field visited by only a few ! Kudos !!!!! I am going to study the documentation from today. Hope I will be able to consume it fully. One thing I want to know. Where can I find the version number of Formula Editor in Excel. Need to be sure that I am using the latest version. Kanwaljit

Dude, this is spectacular! Well done!

I install it, it shows nothing, plugin loading and shows white space

Thank you. You have developed an outstanding solution to many problems. I look forward to using FunFun

I am an Excel developer and the editor alone is worth the price of admission(pun). Solid product unfortunately niche market, most people can hardly figure out what they are actually doing in excel, innumeracy is a big problem in society.

Thanks for sharing. unfortunately, it has bug when we try to optimize the worksheet: Error: InvalidArgument: The argument is invalid or missing or has an incorrect format. Debug info: {"code":"InvalidArgument","message":"The argument is invalid or missing or has an incorrect format.","errorLocation":"Worksheet.getRange","statement":"var range202 = worksheet202.getRange(...);","surroundingStatements":["...","var worksheet201 = worksheets.getItem(...);","var range201 = worksheet201.getRange(...);","// Instantiate {range201}","range201.load([\"formulasR1C1\",\"values\"]);","var worksheet202 = worksheets.getItem(...);","// >>>>>","var range202 = worksheet202.getRange(...);","// <<<<<","// Instantiate {range202}","range202.load([\"formulasR1C1\",\"values\"]);","var worksheet203 = worksheets.getItem(...);","var range203 = worksheet203.getRange(...);","// Instantiate {range203}","..."],"fullStatements":["var workbook = context.workbook;","var worksheets = workbook.worksheets;","var worksheet = worksheets.getItem(\"ACT-Ori\");","var range = worksheet.getRange(\"B87:B87\");","// Instantiate {range}","range.load([\"formulasR1C1\",\"values\"]);","var worksheet1 = worksheets.getItem(\"ACT-Ori\");","var range1 = worksheet1.getRange(\"B126:B126\");","// Instantiate {range1}","range1.load([\"formulasR1C1\",\"values\"]);","var worksheet2 = worksheets.getItem(\"ACT-Ori\");","var range2 = worksheet2.getRange(\"B130:B130\");","// Instantiate {range2}","range2.load([\"formulasR1C1\",\"values\"]);

मैंने भी इस Topic पर video पोस्ट किया है। कृप्या एक बार देख ले , ताकि कुछ और knowledge मिल सके। और video अच्छा लगे तो comment जरूर करे।🙏

Thankyou sir

请问，这里的“新版”是指哪个版本呢？

Hi sir I can make a better thumbnail for you

Hello Sir! Please check your mail. Thanks.

Can we change the company name into Chinese?

你好，请问为什么我的excel2019数据类型这里只有股票，没有地理这个选项

如果也能ctrl+q 万能调出菜单就好了