Back in late 2023, Microsoft announced Python integration in Excel. Like many, I was skeptical at first and continued to rely on VBA and built-in Excel formulas for data analyses and visualization.

The integration of Python in Excel is woven directly into the fabric of the software, thanks to the new ‘py’ function. This allows users to use Python seamlessly within the grid, eliminating ...

The public preview of the Python integration on Microsoft Excel will be available to Microsoft 365 Insiders using the Beta Channel in Excel for Windows.

Python in Excel is available for customers of the Business and Enterprise versions of Microsoft 365. However, the integration only works without restrictions under Windows at the start.

Guido van Rossum, Python's creator and now a Microsoft distinguished engineer, expressed his enthusiasm for the collaboration, stating, "I expect that both communities will find interesting new ...