M
Microsoft Excel
Welcome to the September 2023 update. This month, we are thrilled to share that Python in Excel is now available to all Enterprise, Business, Education, and Family and Personal users running Beta Channel on Windows, starting with build 16.0.16818.20000 – and then to the other platforms at a later date. Also, we are excited to introduce the Python Editor from Excel Labs and Copilot support for Python in Excel.
Tune into our upcoming Ask Me Anything (AMA) session on Reddit, r/excel, for questions, answers, and more information on Python in Excel. Submit your questions when the AMA goes live on September 27 at 9 AM PT, and join us live for answers and discussions on September 28 between 9-10 AM PT.
Excel for Windows:
Excel for Mac:
1. Python in Excel (Insiders Beta)
Python in Excel makes it possible to natively combine Python and Excel analytics within the same workbook - with no setup required. 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. This feature is now available to all Enterprise, Education, Family, and Personal users running Beta channel on Windows. Read more here >
Seamlessly aggregate and visualize your data with Python in Excel
2. Python Editor from Excel Labs (Insiders Beta)
The Python Editor is a new addition to Excel Labs that allows you to write and edit Python formulas in Excel using a dedicated code editor with similar capabilities as those available in Python notebook environments. Read more here >
Python Editor from Excel Labs
3. Copilot Support for Python in Excel (Coming soon)
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.
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.
Copilot support for Python in Excel will be available in preview later this year. Read more here >
4. Data Validation Autocomplete
AutoComplete for dropdown list helps speed up the discovery of the right Data Validation values at the first attempt, reducing time spent scrolling through the dropdown list, dealing with Data Validation errors, or writing complex code to enable it. Read more here >
Data Validation Autocomplete
1. Data Validation Autocomplete (Insiders)
AutoComplete for dropdown list helps speed up the discovery of the right Data Validation values at the first attempt, reducing time spent scrolling through the dropdown list, dealing with Data Validation errors, or writing complex code to enable it. Read more here >
Data Validation Autocomplete
Your feedback helps shape the future of Excel. Please let us know how you like a particular feature and what we can improve upon—"Give a compliment" or "Make a suggestion".. You can also submit new ideas or vote for other ideas via Microsoft Feedback.
Subscribe to our Excel Blog and the Insiders Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on X, formerly known as Twitter.
Special thanks to our Excel MVPs David Benaim and Bill Jelen for their contribution to this month's What's New in Excel article. David publishes weekly YouTube videos and regular LinkedIn posts about the latest innovations in Excel and more. Bill is the founder and host of MrExcel.com and the author of several books bout Excel.
Continue reading...
Tune into our upcoming Ask Me Anything (AMA) session on Reddit, r/excel, for questions, answers, and more information on Python in Excel. Submit your questions when the AMA goes live on September 27 at 9 AM PT, and join us live for answers and discussions on September 28 between 9-10 AM PT.
Excel for Windows:
- Python in Excel (Insiders Beta)
- Python Editor from Excel Labs (Insiders Beta)
- Copilot Support for Python in Excel (available in preview later this year)
- Data Validation Autocomplete
Excel for Mac:
- Data Validation Autocomplete (Insiders)
Excel for Windows
1. Python in Excel (Insiders Beta)
Python in Excel makes it possible to natively combine Python and Excel analytics within the same workbook - with no setup required. 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. This feature is now available to all Enterprise, Education, Family, and Personal users running Beta channel on Windows. Read more here >
Seamlessly aggregate and visualize your data with Python in Excel2. Python Editor from Excel Labs (Insiders Beta)
The Python Editor is a new addition to Excel Labs that allows you to write and edit Python formulas in Excel using a dedicated code editor with similar capabilities as those available in Python notebook environments. Read more here >
Python Editor from Excel Labs3. Copilot Support for Python in Excel (Coming soon)
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.
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.
Copilot support for Python in Excel will be available in preview later this year. Read more here >
4. Data Validation Autocomplete
AutoComplete for dropdown list helps speed up the discovery of the right Data Validation values at the first attempt, reducing time spent scrolling through the dropdown list, dealing with Data Validation errors, or writing complex code to enable it. Read more here >
Data Validation AutocompleteExcel for Mac
1. Data Validation Autocomplete (Insiders)
AutoComplete for dropdown list helps speed up the discovery of the right Data Validation values at the first attempt, reducing time spent scrolling through the dropdown list, dealing with Data Validation errors, or writing complex code to enable it. Read more here >
Data Validation AutocompleteCheck if a specific feature is in your version of Excel Click here to open in a new browser tab |
Your feedback helps shape the future of Excel. Please let us know how you like a particular feature and what we can improve upon—"Give a compliment" or "Make a suggestion".. You can also submit new ideas or vote for other ideas via Microsoft Feedback.
Subscribe to our Excel Blog and the Insiders Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on X, formerly known as Twitter.
Special thanks to our Excel MVPs David Benaim and Bill Jelen for their contribution to this month's What's New in Excel article. David publishes weekly YouTube videos and regular LinkedIn posts about the latest innovations in Excel and more. Bill is the founder and host of MrExcel.com and the author of several books bout Excel.
Continue reading...