Microsoft Excel Announces Python Integration, Can Experience

Microsoft says that Python calculations are currently only available in the desktop version of Excel and can run in the cloud.

Currently, users who want to experience Python calculations on Excel can get the latest Excel builds by joining the Microsoft 365 Insider program and choosing the Beta channel.

Microsoft Excel Announces Python Integration, Can Experience Picture 1

With Python natively integrated into the Excel grid, users can use the new "=PY" function to enter Python code directly into Excel cells. Users can seamlessly use Python in Excel formulas, charts, and PivotTables.

By integrating Python functions in Excel, users can use Python libraries such as pandas, matplotlib, and scikit-learning… for data visualization, data cleaning, machine learning, and predictive analytics.

Microsoft Excel Announces Python Integration, Can Experience Picture 2

Excel's built-in Python comes from the Anaconda distribution.

'Integrating the Anaconda distribution of Python into Microsoft Excel is a breakthrough that will transform the workflow of millions of Excel users worldwide,' said Peter Wang, Anaconda CEO and Co-Founder. change. In addition, users can use tools such as Microsoft Teams and Outlook to share work files containing Python code with team members.

Kareem Winters

Update 24 August 2023

You should read it

May be interested

How to convert images to PDF in Python
you can easily build an image to pdf converter in python . here are detailed instructions.
Protect Python scripts against reverse engineering with Pyarmor
you don't want critical python scripts to be reversed by malicious actors. here's how you can protect it.
How to make a plagiarism detector in Python
build a plagiarism detection engine that can help you understand string matching, file operations, and the user interface. you also discover natural language processing techniques to enhance applications.
How to create a library book borrowing system in Python
the book borrowing system helps librarians conveniently manage books and borrow books in the library. here is a tutorial on how to create a library book borrowing system in python .
How to make Hangman game in Python
hangman is a popular word guessing game and you can make it yourself easily. here are instructions for making hangman game in python.
How to set up Python to program on WSL
get started with cross-platform python programming by setting up python on the windows subsystem for linux. here's how to set up python for wsl programming.