We recently announced Python in Excel, bringing one of the most powerful programming languages for data analysis to your spreadsheets. We’ve heard your excitement about leveraging AI with Python in Excel, and today we are thrilled to share how we are combining two of the most exciting new features in Excel so you can create powerful analytics with unprecedent ease with Copilot support for Python in Excel.
Python code generation with Copilot in Excel
In addition to helping you write formulas, format your data, and do data analysis, Copilot in Excel will help you analyze and explore your data in a new way: writing Python code. Just use everyday language to describe what you want to do with your data, and Copilot will generate and insert working Python code in the Excel grid for you.
Video overview of Copilot leveraging Python in Excel
Whether you are new to Python or an experienced user, Copilot helps you achieve more with your data in Excel by accessing advanced analytics. You can use Copilot as a learning tool, to unlock productivity, and as creative inspiration. Here are some of the benefits of using Copilot and Python in Excel:
Forecasting model using Python in Excel, built with Copilot in Excel
Visualization using Python in Excel, built with Copilot in Excel
Data processing using Python in Excel, built with Copilot in Excel
Machine Learning model predicting the weather using Python in Excel, built with Copilot in Excel
Microsoft 365 Copilot embraces our AI principles and Responsible AI Standard, and it follows our commitment to data security and privacy. Python in Excel runs in a secure container on the Microsoft Cloud with enterprise-level security as a compliant Microsoft 365 connected experience: Data security and Python in Excel - Microsoft Support.
Copilot support for Python in Excel will be available in preview later this year.
To use Copilot and Python in Excel, you will need access to Python in Excel (How to enable the Python in Excel preview - Microsoft Support) and Microsoft 365 Copilot (Microsoft 365 Copilot – Microsoft Adoption). It will initially be available in Excel for Windows in English.
Tune into our Ask Me Anything session on Reddit, r/excel, for questions, answers and more information on Python in Excel.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.