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

Yes, Python can effectively replicate and often surpass Excel’s functionality with greater power, flexibility, and scalability. However, it’s not everyone’s cup of tea.

Also, Python isn’t limited to automation in Excel only. It opens up a host of other programming possibilities for you. Python is useful in web development, data science, machine learning, and more.

Python is now integrated into Excel via Microsoft 365, allowing users to write Python code directly in spreadsheets using the `=PY` formula, enhancing data analysis and visualization capabilities.

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

Microsoft is integrating Python into its Excel app. A public preview is available for Microsoft 365 subscribers now and all the Python code runs on the Microsoft Cloud.