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.

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.

Anaconda, the company behind the Python distribution of the same name, has announced a new Python extension for Excel. Anaconda Code makes it possible to execute Python code from Excel on your own ...