News

Microsoft Excel Will Now Let You Run Python Scripts as Formulas

Excel users will not have to install any additional software or add-on since Python integration will be part of Excel’s built-in connectors and Power Query

Microsoft is bringing High-level programming language Python to Excel, allowing Excel users to manipulate and analyze data sheets using Python code, allowing advanced data analysis, increasing automation, improving data visualization and much more.

“You can manipulate and explore data in Excel using Python plots and libraries, and then use Excel’s formulas, charts and PivotTables to further refine your insights,” said general manager of modern work at Microsoft, Stefan Kinnestrand.

“Now you can do advanced data analysis in the familiar Excel environment by accessing Python directly from the Excel ribbon,” he added.

Excel users who want to play around with their data using Python will not have to rely on any additional software or set up an add-on since Python integration will be part of Excel’s built-in connectors and Power Query.

Apart from the Python functionality, Microsoft is also adding a PY function which will allow Python data to be displayed on an Excel spreadsheet.

Partnering with Python repository ‘Anaconda’, Microsoft has also introduced popular Python libraries like pandas, statsmodels, and Matplotlib in Excel.

“I’m excited that this excellent, tight integration of Python and Excel is now seeing the light of day. I expect that both communities will find interesting new uses in this collaboration, amplifying each partner’s abilities. When I joined Microsoft three years ago, I would not have dreamed this would be possible,” said Python’s creator and Microsoft distinguished engineer ‘Guido van Rossum’.

Excited to try out Python codes in MS Excel? Well, the Python feature is rolling out as a public preview for Microsoft 365 Insiders Beta Channel and will be only limited to Windows, before Microsoft releases it onto other platforms at a later date.

Read more:

Sponsored
Abdullah Shahid

Share
Published by
Abdullah Shahid

Recent Posts

VPN Ban Could Cost Pakistan’s IT Industry $1 Billion, Warns P@SHA

The Pakistan Software Houses Association (P@SHA) has raised alarms about the severe impact of the…

9 hours ago

WhatsApp Trials Group Chat Mentions in the Latest Status Update Feature

WhatsApp is rolling out a new feature in its latest Android beta version, allowing users…

9 hours ago

PTA Chairman Confirms No Orders for Mobile Service Shutdown

ISLAMABAD: Chairman of the Pakistan Telecommunication Authority (PTA), Major General (retd) Hafeez-ur-Rehman, confirmed that no…

10 hours ago

35,000 Students to Receive Free Laptops Under Punjab Government Scheme

Punjab Chief Minister Maryam Nawaz Sharif has announced the launch of a new initiative aimed…

10 hours ago

Meta Introduces New Features to Messenger: AI Backgrounds, HD Video Calls, and More

Meta has unveiled a set of new features for Facebook Messenger, designed to improve call…

12 hours ago

PTA Seeks Stakeholder Input on VPN Registration

Islamabad (21st November 2024): PTA hosted a stakeholder consultation on VPN registration, with key participants…

13 hours ago