Excel-maker Microsoft and Anaconda, a key distributor of Python tools, unveiled a collaboration this week that will see Python integrated with Excel. The new Anaconda Python Distribution in Excel, ...

Discover how Python in Excel transforms data analysis with advanced features. Is it worth the hype? Find out if it’s right for your workflow.

Still using Excel for your data analysis? Learn how to leverage Python so you can work with larger datasets and automate repetitive tasks.

For instance, PyXLL-Jupyter can integrate data from your Excel workbook into a Jupyter Notebook using a single command. This enables you to analyze massive datasets quickly.

Microsoft explains that the new functionality leverages the Anaconda distribution of Python, an enterprise geared to data scientists and engineers that is also beginner-friendly.

Excel gets containerized, cloud-based Python analytics and visualization powers Visualization and analytics tools available in preview, but may be paywalled.