You can take your existing Python knowledge, immediately apply it, and not have to become a finance pro, or learn all of these random formulas in order to be effective in a sheet.

Key benefits of ChatGPT-4o Omni for Excel automation: Streamlined data consolidation from multiple workbooks Intuitive natural language interaction Automated generation of Python code for complex ...

But it’s not an apples-to-apples comparison. While Python offers greater flexibility and automation, it’s no match to Excel’s point-to-click interface and ease of use for simple tasks.

The public preview of the Python integration on Microsoft Excel will be available to Microsoft 365 Insiders using the Beta Channel in Excel for Windows.

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