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.

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.

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.

Learn how to create a web worker with Google Apps Script to enable background processing while keeping the UI responsive. This guide covers the inline worker pattern, which allows you to serve worker code directly from your Google Apps Script project and take advantage of module workers for ESM-only libraries.