Excel TRANSLATE Function (yes, it's new and it's pretty cool!)

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.

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.

➡️ Join this channel to get access to perks:

🎬 LINKS to related videos:

🚩Let’s connect on social:

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

[stringp]

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!!

[analysiscloud]

Great! I wrote an Azure Cognitive Services translator 3 years ago for Excel! Good to see Microsoft catching up!

[vlymvvg]

I am greek and the translation is correct! Thank you so much for your videos!

[pHazAwai]

This is what ive been waiting for. Thanks

[konstantinostomadakis]

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

[TinfoilHat]

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!

[GurayVural-nzlk]

Excellent function and very well explained. Thank you Leila!

[Van_Wilder]

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

[JoaoSantos-jbul]

Useful function very well explained! Thank you, Leila! Greetings from São Paulo, Brazil!

[vesaruusunen]

Great feature. Hope this arrives soon to our tenant. Usually it takes a year.

[marckirsch]

Awesome new stuff. Thanks for sharing.

[oyetunjioluwafemiemmanuel]

Thank you always for keeping us abreast

[isalmankhan]

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👍🏻👍🏻👍🏻

[jamesvanderham]

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.

[westleyempeigne]

That’s really useful for those who work in places where there are teams in different countries!

[MrLexhoya]

This is what GSheets better had over Excel... so happy it's landing on Excel now too

[cnav]

Pretty neat function. Now MS needs to create a similar function (or functions) that can change date and time formats based on national standards.

[MRO-Management]

Looking forward to this release as it will help me with my mobile application translations

[alexanderschmidt]

This is great, I go between English, German and Spanish all the time!
And BrBa is also my favorite show!

[workdre]

It would be very useful for this dynamic functionality to be ported over to Word,