Microsoft announced that Python is now a part of Excel! Guido van Rossum mentioned on Twitter that he helped the Excel team add Python to the popular spreadsheet application.
You can get Python in Excel if you have the ability to access Public Preview versions of Office.
This new feature allows you to write Python directly in a cell. For some reason, the Python code will run in Microsoft Cloud rather than locally, so an internet connection is required for this to work. When the cloud is done running, it will return the results, including your plots or other visualizations.
Python in Excel is using the Anaconda distribution of Python rather than the regular Python from Python.org. What that means is that you have many popular scientific packages included automatically, such as pandas, Matplotlib, scikit-learn, etc.