With native Python integration with Excel, users will be able to use the new “PY” function to input Python code directly into Excel cells. Microsoft has partnered with programming language repository provider, Anaconda, to allow Python code to run in Excel without any additional setup. The move is designed to help data practitioners use data inside the application for data analytics and machine learning. “With Python in Excel, you can type Python directly into a cell, the Python calculations run in the Microsoft Cloud, and your results are returned to the worksheet, including plots and visualizations,” Microsoft said in a blog post. The announcement from Microsoft assumes significance as a majority of enterprise data globally is still stored in Excel sheets and data practitioners often find it difficult to use Python within Excel without adds-ons, or additional setups. Several attempts have been made to make it easier to use Python code within Microsoft Excel. In 2014, Zoomer Analytics developed Xlwings, a BSD-licensed Python library that connects to Excel and allows Excel spreadsheets and Python applications to interact directly. In 2017, Continuum Analytics, makers of Anaconda, released Anaconda Fusion, a system for connecting the enterprise-grade version of Anaconda with Microsoft Excel 2016 and higher versions. With this integration, data scientists could expose their work to Excel users with Python code and data available in Jupyter notebooks. Other paid add-ons such as PyXLL can also help integrate Python into Excel. However, with native Python integration with Excel, users will be able to use the new “PY” function to input Python code directly into Excel cells and perform tasks such as data cleaning, predictive analytics, and machine learning due to support from tools such as formulas, PivotTables, and Excel Charts, the company said. “Using Excel’s built-in connectors and Power Query, users can easily bring external data into Python in Excel workflows,” it added. Enterprises will be able to make use of Python libraries such as scikit-learn and statsmodels to apply popular machine learning, predictive analytics, and forecasting techniques including regression analysis and time series modeling, Microsoft said. Python in Excel, which is currently in public preview, is available to users running Beta Channel on Windows, the company said, adding that the feature will first roll out to Excel for Windows, starting with build 16.0.16818.20000, and then to other operating systems. To use Python in Excel, users will have to join the Microsoft 365 Insider Program. “While in Preview, Python in Excel will be included with your Microsoft 365 subscription. After the Preview, some functionality will be restricted without a paid license,” the company said. Related content news analysis Apple earnings: About that iPhone 'slump' in China Based on information from Thursday's earnings report, it seems that data pointing to an iPhone slump in China were over-baked. By Jonny Evans May 03, 2024 9 mins iMac iPhone Apple news Microsoft begins to phase out ‘classic’ Teams Microsoft is encouraging Teams customers to move to the new, faster version of the collaboration app; the older version will be switched off next year. By Matthew Finnegan May 03, 2024 3 mins Microsoft Teams Collaboration Software Productivity Software news analysis Apple confirms it will open up the iPad in Europe this fall The latest efforts to comply with Europe’s Digital Markets Act mean developers can offer to side load apps to both iPhones and iPads in the EU. Apple has also taken steps to improve what it offers to smaller and non-commercial developers in the By Jonny Evans May 02, 2024 6 mins iPad Apple Mobile Apps news Udacity offers laid-off US workers free access to its courses for 30 days Sign-ups will be available over the next 30 days By Lucas Mearian May 02, 2024 4 mins Technology Industry IT Jobs IT Skills Podcasts Videos Resources Events SUBSCRIBE TO OUR NEWSLETTER From our editors straight to your inbox Get started by entering your email address below. Please enter a valid email address Subscribe