Overall, the choice between VBA and Python for Excel automation depends on your specific needs. Even though it's outdated, ...

Though more complicated as it requires programming knowledge, Python allows you to perform any manipulation, transformation, and visualization of your data. It is ideal for data scientists.

Microsoft's Stefan Kinnestrand, writing about “the best of both worlds for data analysis and visualization,” writes that this public preview of Python in Excel will allow spreadsheet tinkerers ...