Video není dostupné.
Omlouváme se.
Excel TRANSLATE Function (yes, it's new and it's pretty cool!)
Vložit
- čas přidán 15. 08. 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.c...
Learn how to use the amazing new Excel TRANSLATE function to translate text and instructions into over 100 languages. Perfect for business forms, input sheets, team instructions, and more!
There is also a DETECTLANGUAGE function that detects the language of the text.
⬇️ Download the Excel practice file here: pages.xelplus....
What You'll Learn:
- How to add a language dropdown in Excel
- Step-by-step guide to using the Translate function
- Practical examples of translating text dynamically
- Tips for using the Detect Language function
00:00 How to Translate in Excel
01:04 Excel TRANSLATE Function
03:27 Detectlanguage Excel Function
03:54 Practical uses of TRANSLATE Function
05:58 Translate Data Entry Sheets
08:13 Wrap Up
Why You'll Love The TRANSLATE Function:
- Makes working with international teams easier
- No more manual translation-save time and effort
- Everything stays dynamic and up-to-date
Availability: These functions are currently available to Beta Channel users running Windows version 2407 (Build 16.0.17808.20000) or later.
📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.c...
➡️ Join this channel to get access to perks:
/ @leilagharani
🎬 LINKS to related videos:
How to Use Excel XLOOKUP: • How to Use the NEW & I...
5 Excel Functions EVERYONE Needs: • 5 Excel Functions EVER...
👕☕ Get the Official XelPlus MERCH: xelplus.creato...
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.co...
🎥 RESOURCES I recommend: www.xelplus.co...
More resources on my Amazon page: www.amazon.com...
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
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 :(