Microsoft today announced the public preview of Python in Excel, which will allow advanced spreadsheet users to combine scripts in the popular Python language and their usual Excel formulas in the ...

This can lead to opportunities for combining and strengthening your team's technical skills with Excel, SQL or Python-related data models.

With this new feature, users can type in Python code in the Excel app. The calculations are then run on a Microsoft cloud server and are returned to the Excel app, with plots and visualizations.

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

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