Some members of the Microsoft 365 Insiders program can now try out the combination of Python, Excel and the Anaconda Python repository.

Another really important thing that you need to know about Python in Excel is that Microsoft has created a special Python function that is used for interacting with Excel data.

Anaconda Inc., an open ecosystem for sourcing, building, and deploying data science and AI initiatives, announced the release of Anaconda Code within its Anaconda Toolbox for Excel. This new feature ...

How is it different from native Python in Excel? Some of you may be aware that you can run Python in Excel natively. However, it is dependent on a cloud-based Anaconda environment to execute code ...

With this new feature, users can type in Python code in the Excel app. The calculations are then run on a Microsoft cloud server and are returned to the Excel app, with plots and visualizations.

Microsoft is integrating Python into its Excel app. A public preview is available for Microsoft 365 subscribers now and all the Python code runs on the Microsoft Cloud.

Excel gets containerized, cloud-based Python analytics and visualization powers Visualization and analytics tools available in preview, but may be paywalled.

This will enable users to perform complex statistical analysis, advanced visualizations, predictive analytics, and machine learning in Excel.