Also, Python isn’t limited to automation in Excel only. It opens up a host of other programming possibilities for you. Python is useful in web development, data science, machine learning, and more.

Yes, Python can effectively replicate and often surpass Excel’s functionality with greater power, flexibility, and scalability. However, it’s not everyone’s cup of tea.