Skip to main content

13 posts tagged with "Excel"

Excel features and tips

View All Tags

Python in Excel Review

· 6 min read

Microsoft's Python in Excel has now reached GA. It enables the user to input Python code and it will return the result as either a Python object or Excel values. You can read in more detail how to use this function in the official documentation.

The Python in Excel feature is only available to Microsoft 365 subscribers, and access to the higher performance runtime requires a separate add-on license.

The purpose of this post is to focus on the strengths and potential weaknesses of this implementation and to explore alternatives.

Excel TRANSLATE Function

· 3 min read

Microsoft announced a new Excel TRANSLATE function that allows users to translate text directly within their spreadsheets. This function is similar to the GOOGLETRANSLATE function in Google Sheets and provides a convenient way to work with multilingual data in Excel. In this article, we'll explore the syntax and usage of the TRANSLATE function in Excel.

It is currently available to Beta Channel users on Windows and Mac. It is unclear if this will offer unlimited free use once it reaches GA.

GOOGLETRANSLATE for Excel

· 2 min read

This post explores a GOOGLETRANSLATE function for Excel that brings Google Sheets' translation capabilities to Excel. Unlike the Google Sheets version, this implementation translates text locally on your computer using machine learning models, ensuring your data stays private without requiring any API calls or external services.