Introduction to Python for Microsoft Excel

Start using Python
To begin using Python in Excel, select a cell and on the Formulas tab, select Insert Python. This tells Excel that you want to write a Python formula in the selected cell.
Or use the function =PY in a cell to enable Python. After entering =PY in the cell, choose PY from the function AutoComplete menu with the Down arrow and Tab keys, or add an opening parenthesis to the function: =PY(. Now, you can enter Python code directly into the cell. The following screenshot shows the AutoComplete menu with the PY function selected.