Mit Python lassen sich in Excel große Datenmengen einfach analysieren. Zusammen mit der Copilot-KI können auch Einsteiger den passenden Code erzeugen.

Python’s Pandas library allows for advanced data manipulation, statistical analysis, and exploration directly within Excel, streamlining workflows.

Die pandas-Bibliothek bietet die Möglichkeit, mit Python Daten aus Excel-Arbeitsmappen auszulesen, zu bearbeiten und zu ändern.

“Now you can do advanced data analysis in the familiar Excel environment by accessing Python directly from the Excel ribbon,” Stefan Kinnestrand, the GM for Modern Work at Microsoft, explains.

Discover how Python in Excel transforms data analysis with advanced features. Is it worth the hype? Find out if it’s right for your workflow.

For example, the Panda library is a game changer for professionals who deal with a lot of data. You can analyze large datasets more efficiently than working directly with Excel cells.

Users will be able to enter Python code directly into cells using the new =PY function, as Python will be integrated directly into the Excel grid, with no need to install additional software.

Excel gets containerized, cloud-based Python analytics and visualization powers Visualization and analytics tools available in preview, but may be paywalled.