By using Python libraries in Excel, you can automate tasks, build dashboards, and more.

Open Excel, and you will see a new tab in the ribbon at the top that says PyXLL.

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

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.