For decades, if you wanted to do heavy data lifting in Excel, your options were nested formulas, VBA macros, or a trip into the Power Query Editor. But with Python now accessible directly from Excel ...

With the newly introduced 'PY' function, you can write Python scripts directly in cells, and the written scripts will be executed on the Microsoft Cloud and the results will be displayed in the sheet.

Ever wished you could do more with Microsoft Excel? Microsoft just announced the release of a public preview of Python in Excel, which would allow users to add Python code directly into a spreadsheet.