How to use Excel translate function

Published: 01 January 1970
on channel: Akerele Oluwasogo (Mr Excel)
306
9

Excel Video: How To Translate Language In Excel

During the lock down in 2020, I got a contract of $1000 from a client.

He is a Nigerian but based in China.

I was given a project to analyze and visualize the result in Excel.

But the problem was, the data was in Chinese language,

I can't reject the job because the pay was much

Who no like better things. 😂 😂

But the problem is, how do I analyze a data that I don't understand?

Thank God for my knowledge of Excel,

Then I remember there is a feature in Excel called EXCEL TRANSLATE.

Excel Translate is a function which helps to convert any sentence or word in one language to another.

There are three translation options available, one is the online dictionary, second the dictionary available when downloaded and third is the machine translation.

Now you must be wondering why and where is it used so widely?

Well the answer is as follows

Many companies like call BPO, Pharmaceutical, Medical, and other companies deal with their products and demands internationally.

For such industries, the translate function comes as a savior to use and get reliable information. Also, it can handle and convert multiple data at a time.

Watch the example in the video to learn how the Excel Translate is used.

Drop your comment and share

Do you want to learn Data Analytics using Excel, Power BI and SQL to land high paying jobs?

Join our MARCH COHORT. It is 5 weeks program (weekend class)

The training starts on Saturday 9th of March, 2024

Physical and virtual class available

Call us on 08062468296 or click on www.leadleapconsult.com to register

Choose Lead-Leap Data Analytics School


Watch video How to use Excel translate function online without registration, duration hours minute second in high quality. This video was added by user Akerele Oluwasogo (Mr Excel) 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 306 once and liked it 9 people.