Microsoft have announced that they're combining our two favourite tools: Python will be available within Excel:
Now you can do advanced data analysis in the familiar Excel environment by accessing Python directly from the Excel ribbon. No set up or installation is required. Using Excel's built-in connectors and Power Query, you can easily bring external data into Python in Excel workflows.
Microsoft. "Introducing Python in Excel: The Best of Both Worlds for Data Analysis and Visualization"
You'll be able to use hundreds of Python libraries from within Excel. That includes SciPy and Networkx. Hopefully, libraries like Pyomo and OR-Tools will become available too.
The feature is being rolled out in Microsoft 365 progressively, so look out for it becoming available in your version of Excel soon.
For more information: Introducing Python in Excel: The Best of Both Worlds for Data Analysis and Visualization
