I jumped into Python in Excel to see what it could do with some of the data I was testing. While I was able to complete certain functions, I also discovered that there are definitely limitations ...

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.

And Python is not just good for big numbers. Textual analysis often offers rich potential for stories too, and Python excels in this area thanks to libraries such as “ NLTK ” and “Gensim”.