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.