When it comes to portability, Python is a clear winner. VBA code can be version-dependent. Besides, the VBA code written for Excel on Windows might not work on Excel for Mac.

If you’re decent in Python (or aspire to be) but don’t have the chops for advanced data work in Excel, Microsoft now offers the kind of peanut butter-and-chocolate combination that you may consider a ...