Microsoft has launched yet another significant integration for Excel. This time, it’s the new Python integration that will expand the software’s capabilities.
Launched through Public Preview on August 22, it will allow direct access to Python within Excel’s interface. That means, Excel users can now input Python code directly into cells using the new “PY” function.
Also, the collaboration with Anaconda will enable native integration, thereby eliminating the need for any additional installations. For data professionals, this new integration shall empower them to work with multiple tools for data cleaning, predictive analytics, and machine learning within Excel.
Microsoft believes that the new integration will simplify the utilization of Python within Excel, and enhance its capabilities for seamless data analysis and manipulation. All calculations will be performed in the Microsoft Cloud, and the results and visualizations will be returned to the worksheet.
Python libraries like scikit-learn and statsmodels can also be utilized for different tasks, including machine learning and forecasting. Further, the feature will also support Excel’s existing tools such as formulas, PivotTables, and charts which in turn will facilitate seamless workflow integration.
The access to this new feature is available to Microsoft 365 Insiders through the Beta channel within Excel. The Python integration is expected to roll out to Excel for Windows initially and later to other operating systems.
Whether it’s scaling on Python’s versatility or Microsoft Excel’s accessibility, Inferenz is right at the center of innovation to help businesses succeed with their tech goals. As a leading name in the IT sphere, we lay maximum focus on scalability, performance, and cost control. Blessed with a team of innovative experts who consistently enhance technologies to deliver optimal solutions, we are a trusted partner for bespoke digital, scalable, and sustainable tech solutions.
To know more about the latest happenings of the tech world, follow Inferenz.