Geeky News talks About Microsoft Integrating Python in Excel

Surrey, United Kingdom Sep 19, 2023 (Issuewire.com) – Geeky News, a leading source for insightful technology articles, is delighted to announce the release of its latest feature article, “Microsoft Integrates Python in Excel.” This piece discusses Microsoft’s recent milestone achievement–the successful integration of Python into its renowned spreadsheet platform, Excel. This integration is revolutionising data analysis and visualisation for millions of users worldwide.

Microsoft, a global pioneer in software innovation, has made a significant leap in empowering Excel users by seamlessly integrating Python. Python, of course, is one of the world’s most widely used high-level, general-purpose programming languages. This strategic move reflects Microsoft’s commitment to enhancing user experiences and promoting a more intuitive approach to data analysis and visualisation.

According to Microsoft, Python in Excel has been released as a Public Preview accessible through the Insiders Beta Channel. The feature was initially available for Excel for Windows users, starting with build 16.0.16818.2000. However, Microsoft plans to extend this integration to users on other platforms in the near future.

The article highlights Microsoft’s commitment to providing a user-friendly experience with Python in Excel. Python can be accessed directly from the Excel ribbon, enabling advanced data analysis without the need for third-party software or add-ons. Excel’s Power Query and Connectors features can also be leveraged to seamlessly import external data into Python in Excel workflows.

Microsoft’s collaboration with Anaconda, a leading enterprise-level Python repository, is poised to deliver enhanced capabilities. Anaconda Distribution for Python will be integrated within Excel, offering core Python functionalities and access to over 400 curated packages, facilitating efficient data analysis and visualisation within the Excel interface.

Python in Excel, operating within Microsoft Azure, will enable users to access common Python libraries such as stats models, pandas, Matplotlib, and Seaborn for advanced statistical modelling, data analysis, and data visualisation.

Microsoft has introduced a new PY function in Excel, allowing data from Python to be seamlessly displayed within the Excel workbook grid. This feature enhances the synergy between Python and Excel, creating a unified and powerful data analysis environment.

Guido van Rossum, the creator of Python and an engineer at Microsoft, expressed his excitement about the collaboration, saying, “I’m excited that this excellent, tight integration of Python and Excel is now seeing the light of day. I expect that both communities will find interesting new uses in this collaboration, amplifying each partner’s abilities.”

Collaboration is made effortless with Python in Excel, enabling users to seamlessly share Python analytics and Excel workbooks in Microsoft Outlook or Microsoft Teams. Comments and @ mentions further streamline collaboration. And, colleagues can co-author workbooks as they would in Excel, regardless of whether they have Python in Excel activated or not.

Emphasising data security, Python in Excel operates on the Microsoft Cloud, ensuring an “enterprise-level security as an M365 connected experience.”

The article acknowledges that while Excel remains the most popular spreadsheet platform, some tasks, such as creating specialised charts, can be challenging. For professionals seeking to create quality presentations with stunning Excel charts directly from PowerPoint, using high-quality PowerPoint add-ins like think-cell is recommended.

However, Microsoft’s commitment to fortifying the user experience and enhancing productivity is evident in its latest Excel upgrades.

To read the full article, please visit:

https://www.geekynews.co.uk/microsoft-integrates-python-excel/.