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.

With Python in Excel, users will be able to type Python code directly into an Excel cell. The Python calculations will run on Microsoft’s cloud servers and be delivered back to the Excel sheet.

Ever wished you could do more with Microsoft Excel? Microsoft just announced the release of a public preview of Python in Excel, which would allow users to add Python code directly into a spreadsheet.