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 ...

Flawless workbook management Manage your sheets With Python scripts, you can even create new Excel workbooks, add or delete worksheets, merge data from different files, and more.

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