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

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

The power of Python trumps Excel workbooks.

One of the most useful new features that Microsoft has incorporated into Excel in recent years is the ability to incorporate Python code directly into a spreadsheet. While it has long been possible to ...