Page 4 - Power Query News Today

Microsoft has given Excel a major upgrade, unveiling Python in Excel to give users access to the power of Python's data tools.

Some members of the Microsoft 365 Insiders program can now try out the combination of Python, Excel and the Anaconda Python repository.

Microsoft announced today that it is integrating the Python programming language into its ubiquitous Excel spreadsheet software. The public preview of this groundbreaking feature is available today for Microsoft 365 Insiders in the Beta Channel, initially limited to Windows users.

Microsoft launched the public preview of Python in Excel which will allow users to type Python directly into an Excel cell without any setup required.

With native Python integration with Excel, users will be able to use the new “PY” function to input Python code directly into Excel cells.

New Python integration for Excel should boost data visibility and analytics

Microsoft released the public preview of Python in Excel today, allowing advanced spreadsheet users to combine Python scripts and Excel formulas in the same workbook. This feature will first be released to Microsoft 365 Insiders in Excel for Windows beta. While the feature will initially only be available in Excel desktop, Microsoft says Python calculations …

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.

Microsoft integrates the Python programming language into Excel - SiliconANGLE

Microsoft Azure’s new, unified data platform aims to be your one-stop shop for analytics and machine learning at scale.