GOOGLETRANSLATE is built into Google Sheets, and because Excel files can be opened on Google Sheets this allows translation on a cell by cell basis of either Excel and Google Sheets files. I show how to use the GOOGLETRANSLATE and DETECTLANGUAGE functions and how to create custom functions to leverage these and make it super easy to translate into French, Japanese or any language.
0:00 Introduction
0:41 GOOGLETRANSLATE
1:45 DETECTLANGUAGE with translate
2:05 Error handling with IFERROR
2:30 Create custom function
4:59 Using in Excel files
