In the last post introducing Python, I demonstrated how to make a simple app using variables and conditional statements. In order to do anything really powerful in a given programming language though, ...

The power of Python trumps Excel workbooks.

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