Before going over their fundamental differences, let's address the main question. Yes, Python can do virtually everything Excel can. But it’s not an apples-to-apples comparison.

Microsoft 365 business customers can now use Python code directly in Excel, but currently only on Windows and with code execution in the cloud.

Excel gets containerized, cloud-based Python analytics and visualization powers Visualization and analytics tools available in preview, but may be paywalled.