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.

We agree it is simple, but actually, it isn’t so much Python per se, it is some pretty cool libraries (SciPy, in particular) that do all the hard work. That may be splitting hairs, but it is ...

Today, the company announced it is adding support for the Python coding language in Excel. The feature is currently available as a public preview for Microsoft 365 Insiders in the Beta Channel.

It’s slow, cumbersome, and prone to errors. Now imagine combining Excel’s familiar interface with the analytical power of Python—suddenly, your workflow transforms. With this integration ...