The company is using the Anaconda Python distribution -- running in Azure -- to bring the most popular Python libraries to Excel, including the likes of Matplotlib and seaborn for data visualization.

Some members may not see Python in Excel as an option yet; Microsoft stated this beta will be rolled out in waves. Users with the Public Preview will be able to see Python in the Excel ribbon menu.

The company is using the Anaconda Python distribution — running in Azure — to bring the most popular Python libraries to Excel, including the likes of Matplotlib and seaborn for data ...

Python and Excel can only really talk to each other through limited functions—xl () and =PY ()—that can only return code results, not macros, VBA code, or other data, Microsoft claims.

I didn't get much done While I was able to get a few things done using Python in Excel, my productivity was greatly constrained by my lack of familiarity with Python and the best Excel features.