Python allows for automations that Excel VBA simply cannot perform. For instance, it can scrape data from websites, process that data, and subsequently insert it into an Excel sheet.

Back in late 2023, Microsoft announced Python integration in Excel. Like many, I was skeptical at first and continued to rely on VBA and built-in Excel formulas for data analyses and visualization.

Microsoft might not have a mobile platform but it has a few tricks up its sleeve to win in low-code app creation.

Excel is now table stakes while Python expertise has significantly outpaced the demand for Excel and VBA skills in the financial job market. Accessibility and Learning Curve ...