Good things always come in the end, like Python in Excel

Advanced Excel users will have a new string in their bracket, and it’s a Python string! The already popular programming language will already be integrated into the spreadsheet.

For many Excel users, being able to use Python directly in their spreadsheet is finally a dream come true. Microsoft revealed the first public preview to allow this To use the programming language natively in the program. Python commands are available from the Excel ribbon, no installation or obscure settings required. ” With the built-in connectors in Excel and Power Query, it’s now easy to import external data into Python streams in Excel Microsoft explains.

The integration is in beta at the moment

This new feature is clearly aimed at more experienced Excel users (there are quite a few of them). And if they really wanted to be able to use Python in their favorite programs, there have been libraries and plugins for a long time. But the original integration will make everyone’s life easier…

Python in Excel will help analysts with data visualization, automatic learning, predictive analytics, data cleaning… However, we will keep in mind that the calculations are performed in the Microsoft cloud, not on premises. It is surprising to know that computers are powerful enough to support all of these processors.

Microsoft has partnered with Anaconda and is using the company’s Python distribution (running on Azure) to integrate the most popular Python libraries into the spreadsheet. To take advantage of it now, you must sign up for the Microsoft 365 Insiders program and use the Excel Beta channel. Only the desktop version of Excel is affected at this time.

source :

Microsoft