To use python directly in Excel you got to pay the montly fee of the personal subscription at least and enter in the Office 365 insider community, use the beta channel, upgrade to the latest version. You will find python in the formulas. If do not see the python icon in the formulas, try to close excel and reopen it. I had to struggle to see it.
Subscribe to the newsletter for updates
Tkinter templates
My youtube channel
Twitter: @pythonprogrammi - python_pygame