Some members of the Microsoft 365 Insiders program can now try out the combination of Python's data analysis and visualization libraries, Excel's features and the Anaconda Python repository. Image: ...

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.

For years, VBA (Virtual Basic for Applications) has been the go-to language for automating tasks and extending the functionality of Microsoft Excel. However, the rise of Python, coupled with its ...