Это видео недоступно.
Сожалеем об этом.
Excel TRANSLATE Function (yes, it's new and it's pretty cool!)
- Добавить в
- Мой плейлист
- Посмотреть позже
- Поделиться
Поделиться
HTML-код
Размер видео:
- Опубликовано: 15 авг 2024
Комментарии • 209
Следующие
Автовоспроизведение
Introducing REGEX Excel Functions - Extract, Clean, and Format Data Easily! (NEW!)Leila Gharani
Просмотров 274 тыс.
6 Excel Tools Most Users Never Think to Use (Files Included)MyOnlineTrainingHub
Просмотров 172 тыс.
How to Make Money with Excel SkillsLeila Gharani
Просмотров 420 тыс.
OFFLINETV PLAYS TRUTH OR DRINKOfflineTV
Просмотров 1,1 млн
【MV】Breaking Dimensions【hololive English Original Song】hololive English
Просмотров 409 тыс.
Hawaii: Last Week Tonight with John Oliver (HBO)LastWeekTonight
Просмотров 2,2 млн
Dominik Mysterio’s Relationship w/ Liv Morgan, Betraying Rhea Ripley, Logan Paul Tag Team: 425IMPAULSIVE
Просмотров 1,2 млн
5 Excel Secrets You'll Be Embarrassed You Didn't KnowExcel Campus - Jon
Просмотров 151 тыс.
How to use AI for Web Scraping with Excel and Google SheetsPeter Mangan
Просмотров 16 тыс.
Say Goodbye to IF Statements in Excel with SWITCHTeacher's Tech
Просмотров 488 тыс.
How to Screenshot on Windows 11 📸 - Cool New UpdatesLeila Gharani
Просмотров 113 тыс.
You Won't Believe These Crazy PIVOT TABLE Hacks!Leila Gharani
Просмотров 686 тыс.
10 Excel Formulas That Will Set You Apart (+Cheat Sheet)MyOnlineTrainingHub
Просмотров 244 тыс.
Excel Tutorial for Beginners | Excel Made EasyLeila Gharani
Просмотров 2 млн
Excel's NEW Checkboxes Are Incredibly Cool! Here's whyLeila Gharani
Просмотров 511 тыс.
17 Amazing Excel Features Hiding In Plain SightExcel Campus - Jon
Просмотров 101 тыс.
would you eat this? #shortsZach Choi ASMR
Просмотров 723 тыс.
КУДА ДАЛЬШЕ ДВИНУТСЯ ВСУ? БЕСЕДА С ЮРИЙ ФЕДОРОВФЕЙГИН LIVE
Просмотров 536 тыс.
احتفظي ببصمة حبيبك في قلادة جميلة واحتفظي بذكرياتك إلى الأبد ❤️إبداعات حرفية
Просмотров 2,3 млн
Insane Coffee trick EXPOSED 😱☕️ #shortsWian
Просмотров 5 млн
İrlanda'da Filistin bayrağını indirmek isteyen kişi böyle durduruldu #shorts #filistin #keşfetUlusal Kanal
Просмотров 1,9 млн
Получили тысячи $$ на "старье".АУКЦИОН КОНТЕЙНЕРОВ В США
Просмотров 436 тыс.
Яшин - интервью после тюрьмы / вДудьвДудь
Просмотров 7 млн
Download the Excel practice file I use in the video here 👉 pages.xelplus.com/excel-translate-file
To understand how a new function gets rolled out by Microsoft: www.xelplus.com/excel-versions/
Hey Leila - CourseCareers sent an email about a paid partnership! Let us know what you think!
My Excel doesn't have this Translate function in it.
What version are you using?
How can we get this function in our version of Excel?
www.youtube.com/@primaryfriends6522
@@mattcoursecareers I'm sure my team will get back to you.
Confirming that the Greek translation is accurate. Thank you again for one more great tutorial and for all you do for the excel and the entire business community!!
That's good to hear Thank you. Appreciate it.
Wow very cool Leila!
@@LeilaGharani Greek here Leila. Actually the translation is not 100% accurate. It translated the "It's great that you stay up to date" as "It's great to stay up to date". It gave the word "να", instead of the correct "που". This changes the meaning from actually "targeting" the audience, to a more generic form, an observation you'd say. Nevertheless, knowing that Greek is not the easiest language on the planet, this is still a big step for 365. Cheers and thanks!
@@LeilaGharani
What version of Excel does this?
Ελλαδάρα!!
Great! I wrote an Azure Cognitive Services translator 3 years ago for Excel! Good to see Microsoft catching up!
I am greek and the translation is correct! Thank you so much for your videos!
That is pretty cool. I just hope that the TRANSLATE function is added to Excel 365 for Mac pretty quickly. [EDIT] It came in this morning so, very nice!
This formula will help me a lot. Right now in order to automate the translation in a file I have created a mapping from english to Greek which is massive.
Thnx Leila :)
This is what ive been waiting for. Thanks
So cool. Before watching this video, I just know use translation machine like Google Translate or Immersive Translate to help me translate what I need. But now, I have known a new tool to help me translate Excels. Thanks for your sharing ❤.
Glad it was helpful!
Great video. In your last formula, I had an idea that Instead of Xlookup and checking against other ranges, you could have used the switch function, that way you don't need the languages and codes in other cells. But that would probably only be beneficial when you only have a handful of languages. Xlookup would probably work better if you want to have an updateable language list.
Useful function very well explained! Thank you, Leila! Greetings from São Paulo, Brazil!
Thank you! Thanks for watching.
Absolutely brilliant - I can’t believe it has taken Microsoft this long to introduce this function. I will be using it to help with me studying Portuguese
chat gpt would be more practical!
@@manosvenianakis9323 you peaked my interest ;-) how would you go about using ChatGPT for language learning in the most automated and productive manner?
Excellent function and very well explained. Thank you Leila!
You're The Best in the world👍🏻👍🏻👍🏻
I wish I could use excel like you do😅
Constantly learning from you, keep up the great work😍😍😍
Thanks for sharing👍🏻👍🏻👍🏻
Great feature. Hope this arrives soon to our tenant. Usually it takes a year.
Exactly! The moment I hear "it is coming to Excel" I think that maybe someday...
As always you show us the best of new functions in a very clear way.
The question I was asking myself was.... "What if I don't know what source language is?"
The text I will translate is in A1, C3 has the language I want the formula to translate, and sheet2 b2:b10 has the table of languages.
The answer I came up with is this:
=TRANSLATE($A21,DETECTLANGUAGE($A21),XLOOKUP(C$3,Sheet2!$A$2:$A$10,Sheet2!$B$2:$B$10))
Did I forgot to say I'm your fan?
That’s really useful for those who work in places where there are teams in different countries!
Awesome new stuff. Thanks for sharing.
This is great, I go between English, German and Spanish all the time!
And BrBa is also my favorite show!
Thank you always for keeping us abreast
Amazing function thanks Leila, also can we have a seriece of sessions about Macro learning, i am exited and realy need Macro in my job, but do not have the foundation to start.
Looking forward to this release as it will help me with my mobile application translations
Many thanks for showing us how to use this great new function. Do you have any information when this will be available for normal office users?
Hi Leila , I can assure you that Greek translation works great ( word of a Greek guy LoL) . By the way it's always a pleasure watch your videos
A much needed formula from long time👍
That's neat. Could have used this years ago working internationally on migration projects.
This is what GSheets better had over Excel... so happy it's landing on Excel now too
Me too. Was about time. :)
Pretty neat function. Now MS needs to create a similar function (or functions) that can change date and time formats based on national standards.
Saya harus coba..terima kasih ilmunya
Another awesome video! Thank you Professor Gharani! I honestly don’t know how I’ve managed my Excel production for so long without your expertise, clarity in explanations, and incredible insights and tips! Thank you truly!
Very cool ... and once again have Prof Leila to thank for bringing it to my attention ... thank you ... 😍
Thank you for stopping by!
Hi Leila , just confirming all these updated video are they also updated in your black belt course as i have unable to find all those updates.
It would be very useful for this dynamic functionality to be ported over to Word,
Yay! so excited for this to come to Excel so I don't have to go over to google. I use this for translating survey questions/outlines to import into Forms. Hopefully one day, Forms will do the auto translating for me!
There are three (3) points I will ask you about. My version of Office is the latest version 2024:
1- How do I get a “translate”? She doesn't exist 😮
2- Also, the new “Check Box” does not exist 🤔
3- In the latest update to Office, an icon disappeared. This icon is at the top next to Exit, which collapses the top menus to enlarge the workspace. It has three options and looks like an arrow, as I remember. It is very important. Why did it disappear? ✨
................................................................................................
There is another topic regarding delaying the function. I asked you about it and you answered that by using VBA, I wanted to do without VBA. I wish this task existed in Excel without Vba 🤩🤗
Both TRANSLATE and the new checkboxes are currently still in beta. You need to join Office Insider beta channel to get it now.
pretty cool! thanks for the tutorial, but you didn't mention if this fomula relies on internet or use built-in dictionary.
Leila thanks so much for your very helpful videos, I've been trying to set a formula in excel 365 to return last selling price of each product for each customer to be used for their returned items, can you help me? bearing in mind that each product has various selling prices based on customer and selling date. Thanks a lot
It seems as if in a lot of the formulas in this video, as shown on the screen, there are unnecessary space-characters before and after commas (where the comma is a delimiter between arguments of a function). Again, what SHOULD happen if such a Cell-Entry is attempted is that Excel should balk, some kind of error-message or error-result in the Cell. The reason this is so important is a colleague of mine who lost half a day's work trying to work with text formulas. What she SHOULD have typed was something in the pattern of
=SUBSTITUTE(A4,"Buyer",D4)
to replace the word "Buyer" in a sentence in Cell A4 with the word in Cell D4. But Excel's toleration of errant space-characters had left her with some sort of vague sensibility or impression (not probably the most conscious of thoughts) that the commas that are used as delimiters are like the U.S. English commas in "red, and white, and blue". They're not. One must WISH that Excel had used some other character as a delimiter, such as the pipe ("|"). Then this confusion wouldn't have been created, and she'd have typed
=SUBSTITUTE(A4|"Buyer"|D4)
correctly the first time. But because of the U.S. way of doing punctuation in English, she kept on trying things like
=SUBSTITUTE(A4,"Buyer,"D4)
in the belief that U.S. English grammar requires the comma to go INSIDE the quote-mark. Since the text "Buyer," (ending in a comma) didn't OCCUR in Cell A4, and since the SUBSTITUTE function doesn't give any indication of anything awry (nor should it) if the sought-for text isn't found in the text in question, all of her SUBSTITUTE-formula Cells contained the exact text as the Cell they were working on. And she didn't notice it until hours later. Then she got a bit frantic and thought the failure was owing to missing space-characters (which would also be required in English grammar), so, in vain she tried correcting to
=SUBSTITUTE(A4,"Buyer," D4)
and
=SUBSTITUTE(A4,"Buyer, " D4)
and other combinations of things that didn't work. If Excel had been intolerant of confusing commas-as-delimeters with commas-in-English-grammar, and therefore intolerant of any notion that such commas need space-characters, she'd never have gone down the wrong road of unconsciously believing that the two should work the same way with respect to quote-marks that end literal text, and she wouldn't have had to scramble with the deadline and rush the fix once I arrived with the explanation.
what version does this function come with please I don't seem to have it on my latest version
Same with me
This is cool, I should probably learn how to use excel first 😅
I will love it for translating my datasheets!! Actuel I work with formulars …. pffff …. 😅
i have office 365 but i don't have translate function although i have updated it but don't have it!
I'm surprised by how accurately it translates the input!
very insightful
Thanks for the great content as always.
Thank you!
Good video and demonstration of the new functions.
But I’d rather have full (dynamic) array support in all functions, including in data validation and conditional formatting.
That’s a repeat statement, I know. ;-)
Great feature!
Your videos are amazing what is the settings you use for exporting please
Always cool
The best channel
Looking good (as always).
Thank you for your good Information.
Our pleasure!
this is best function. how to have this function in my excel?
Thank you 😊
Does TRANSLATE create dynamic spilled arrays? Nice new feature!
Thank you Leila (Y)
Translation of acronyms??? For example, SWOT = Strengths, Weaknesses, Opportunities, and Threats.
What about a dictionary of proprietary abbreviations / acronyms? And going between languages? I deal with this on an almost daily basis for work (foreign automaker + 2nd country foreign supplier, both in yet another country). I’m interested in seeing this work!
The translation in Greek is absolutely correct!!! 🇬🇷 🇬🇷 🇬🇷 ❤
Για ξανακοίτα τη μετάφραση καλύτερα. Κανονικά θα έπρεπε να λέει "Είναι υπέροχο ΠΟΥ ενημερώνεστε για τις εξελίξεις", δηλαδή να αναγνωρίζει ότι εσύ φροντίζεις να είσαι ενημερωμένη και όχι να λέει "Είναι υπέροχο ΝΑ ενημερώνεστε για τις εξελίξεις", δηλαδή σαν να σε προτρέπει να ενημερώνεσαι. Μπορεί να φαντάζει ασήμαντο λάθος, όμως δίνει άλλο νόημα στην πρόταση. Αυτό σημαίνει ότι η μετάφραση δεν είναι τέλεια.
Tnx love from Bangladesh 🎉
need more videos on powerbi
Is this only for Enterprise customers? I am on the version you list in the description and in the Beta Channel.
Also will this feature work offline?
Thanks for this video. It's great.
This is how i export the outlook calender: File > open & export > import/export > export to file > comma seperated values > calendar. How do you do that in the new outlook?
Ur looking nice keep up
Thanks Leila
Hi, is their a way to get the 'Date Taken' from a Picture, using VBA,
So as to create a List of 'Picture Names' & 'Date Taken' ❓
P.S. Love your Videos ❤️
Some programming systems allow the usage of lookup tables for localization. Each row would have the text to show in the relevant button or window, and each column would have the translation for the enduser's selected language. Is there a way to have placeholders that should not be translated besides using quotes, such as [COMPANY NAME]?
Video is good, translating can be useful as viewed in the video, just never thought about how useful it could be. Question would be, how accurate are the translations from one language to another? 😺👌🥰 👩💻⭐️💎
THX.
Happy to learn
Dear Leila, I have a problem with Pivot Table. Every Month I update the header of resource, my Pivot Table resume usually disappear and I have to move header I want to make resume into sum column on the bottom right column. The trick I do is to make second row as template and first row as header I can change every month. I never change the second row. And I insert one line in the top of Pivot and I make a formula connected to header I want to change. If you have alternate trick, please to let me know. Thank you so much
Sorry, if my question is not related to your content
if it is a living document where team members are inputting information into the spreadsheet, in order for the translation to continue working, would they have to input it in the hidden cells where the text lives? Or can they put it where the translated part is displaying?
Wouldn't it be cool if there was a formula to change from future tense to past tense? That would allow my to complete the pre-conference request form and automatically complete the post-conference report.
This will be super useful for forms and policy documents. When is this feature being released?
There is no fixed release date. It will depend on the feedback of the beta testers.
I think there is issue when use translate function to translate date, even the cell in date format, translate function will change it to value I mean if S6 = 1-Jul-2024 (date format) and when TRANSLATE(TEXT($S$6,"en","ar") the result is 45484.
I fix this issue by using text function for example =TRANSLATE(TEXT($S$6,"dd mmm yyyy"),"en","ar") I assume S6 = 1-Jul-2024
conclusions translate function lead to mute format text
Hi Leila
Do you know when the Group By Function and Check box feature going to be in 365 Office version ( Not Insider )
Thanks
What an amazing addition! Does the new function include Arabic?
if you go to 3:20 in the video - you will see Arabic in the dropdown. So, to answer your question - "Yes"
Need this for outlook lol
i have this in my excel
Does TRANSLATE require internet connectivity? Is it doing the translation locally or via the net?
Does it send all data to the cloud and require online connection to open the files?
Thats cool but now when will excel allow the usage of the English function names in German localized version of excel? I’m sick of having to keep those function names lists up to date with every new function added to excel. Like your videos. Cheers
you should be a model ,your a stunner
I wonder if this Function is running locally or running over the internet... I don't think we have local translation files for excel...
How to get the translate function please, as it's not on my excel spreadsheet 😢
AWESOMEEEEEEE!
Using Office 2024 I made some changes to the same work in the video to support Arabic but it stopped working for all languages!!! Any idea why?
How do I update my excel? I've the office 365 and pay yearly but I don't have this function yet.
I’ve checked for the translation feature in my Microsoft 365, but I couldn’t find it. Is an update required to access this function?
is the =translate() available in all verson, my office 365 is not supporting !!
Isn't reverse translation a possibility to check?
Hello leila, could you please tell me how to combine text and number in one cell . noted that the cell will be A1 AND A2 (A1 TEXT AND A2 NUMBER ) HOW TO DEAL WOTH THIS CASE
=A1&A2 if you don't want any separator symbols between the text and number.
Otherwise: =A1&" "&A2 if you want a space between the text and number.
If you want any other separator then simply put any symbol you want between quotations.
How add home tab analyze data please help me?
Hello, my Excel doesn't have the Translate function, I have discovered. How can I get it on there in my Microsoft Surface laptop?
I have download the file but it seems in a protect view and I cannot make any changes, please advise
thanks for the info, but why I can't use the function, I already update my excel 365, but it's still resulting #NAME? T_T
Let´s try: "Sim o video foi muito útil, resta saber que versões já incluem esta função" Have you understood or the translate function will come to use?
Haha, nice try. It will be available only in Microsoft 365.
I have faced a problem. i have sales qty column in multiple table. sum all tables sales qty colum as well as sales target qty. and made another measure sales qty / sales target qty. all tables has division product wise 4 years sales data. now i want to count how much product sales ach% is greater than 100% for division? can you help me?this is a powerbi dax problem
In which version of excel is this function available
Thanks very much for the video! I have been waiting for this function for longtime. I just checked my Excel 360, the function is not there yet, does it release to public?
Currently only Office Insider Beta Channel users running Windows version 2407 (Build 16.0.17808.20000) or later.
@@LeilaGharani Thanks for your information, your channel is the best one!
With machine translation, there is of course the risk of hidden errors, but compared to having to maintain multiple sets of the same text, the benefits probably outweigh the downside.
I think so too. Especially if you need to maintain instructions in a couple of languages.
A very useful case. Does excel need Internet access to translate?
Yes, it's using Microsoft translation services.
Makes another bit of the add-in I wrote to use Azure Translation in formulae redundant :(