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 ...

Most people assume Python in Excel is something you use for complex data analysis. I found it useful for a much simpler reason: it helped me deal with the spreadsheet jobs I normally leave until later ...