Best Reference For Python for Excel

[richlocus]

Hello:
In my eager attempt to dive into Python for Excel, I purchased the book called "Python for Excel" by Felix Zumstein. After I started reading it I realized that it is not the new interface being developed by Microsoft. From what I can tell, it is an interface written by Felix and based on a package written by him called "xlwings". I doubt that this has any relationship to what is being released by Microsoft for integrating Excel with Python.

So.... do you know when the Python function will be released on Microsoft 365 Excel? From what I can tell, it is seamlessly integrated into the formula section of Excel, just like any other formula, using the formula "=PY()"... except it is a doorway to the extensive features of Python.

Could you assist in providing some references for Microsoft's release of Python within Excel? Also, if any of my assumptions listed above are not correct please revise my understanding.

Thanks!

Rich Locus

[HansV]

It is currently only available to some of the Office Insiders - users who get the beta development version of Microsoft 365. Microsoft hasn't announced yet when it will be rolled out to 'standard' users.

Introduction to Python in Excel
Getting started with Python in Excel
Creating Python in Excel Plots and Charts
Python in Excel DataFrames
Using Power Query data with Python in Excel
Open-source libraries and Python in Excel
Troubleshoot Python in Excel errors

[richlocus]

Thank you Hans!
Rich Locus

[HansV]

New (but only if you already have Python in Excel):

Introducing the Python Editor from Excel Labs