M icrosoft just announced new feature for Python in Excel that lets you analyze images in your spreadsheets. You no longer need outside tools—you can manipulate, analyze, and pull information from ...

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

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

In such instances, all I have to do is select the data in Excel and write Python scripts inside the Jupyter Notebook to perform the relevant function.

Users with the Public Preview will be able to see Python in the Excel ribbon menu. Those users can bring external data into Python using Power Query and built-in Excel workflows.

This will enable users to perform complex statistical analysis, advanced visualizations, predictive analytics, and machine learning in Excel.