Python in Excel isn’t just for programmers—4 useful things you can do with it right now

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 cells, there’s a fourth way. It lets you perform complex data cleaning, sentiment analysis, and more—all without leaving the formula bar.