What’s New in Excel (February 2025)

Excel; Excel consulting; Powerapss

https://techcommunity.microsoft.com/blog/excelblog/whats-new-in-excel-february-2025/4373786

Welcome to the February 2025 update. We are excited to announce that Copilot in Excel with Python is now available on Windows platforms for all enterprise and consumer users. Also starting now, Excel users on Windows and web can get to Copilot faster from anywhere on the grid. Furthermore, Copilot can now bring web and organizational data into your spreadsheets—available for Windows and Mac Insider users.

Excel for Windows:
– Copilot in Excel with Python

Excel for Windows and web:
– Get to Copilot in Excel faster

Excel for Windows and Mac:
– Search and import data with Copilot in Excel (Insiders)

Excel for Windows

Copilot in Excel with Python
Copilot in Excel with Python is available worldwide on Windows platform for all enterprise and consumer users in English, Simplified Chinese, French, German, Italian, Japanese, Brazilian Portuguese, and Spanish languages. Copilot in Excel with Python can help you gain deeper insights without needing to be a Python expert. Read more here >

GIF showing an example of Python being used within Copilot

Excel for Windows and web

Get to Copilot in Excel faster
We’ve added a new Copilot button that lets you access Copilot from anywhere on the grid, so that you can stay in your flow. This button will appear next to your cell selection, and can be activated at anytime to see a list of suggestions. Selecting any of these options will open the Copilot side pane and automatically run that prompt as if you had typed it manually. And if you don’t need the Copilot icon, you can hide it until the file is reopened. This feature is currently rolling out to Windows and web users. Read more here >

The Copilot icon has been selected, showing a menu of Copilot prompts

Excel for Windows and Mac

Search and import data with Copilot in Excel (Insiders)
Copilot in Excel can now reference Word, Excel, PowerPoint, and PDF files, making the entire data collection and analysis process faster, simpler, and more intuitive. This new capability works for gathering information from sources such as web content, internal content, organization information, or data from another Excel file. Read more here >

Use Copilot to search through web results to insert into your Excel workbook

Check if a specific feature is in your version of ExcelClick here to open in a new browser tab https://onedrive.live.com/embed?resid=E07B6F5DD91EC58B%21261&authkey=%21AMNbD8E1w2sfb9c&em=2&wdAllowInteractivity=False&Item=%27Updated%20October%202022%27!A1%3AH39&wdHideGridlines=True&wdInConfigurator=True&wdInConfigurator=True&edesNext=true&resen=false 

Many of these features are the result of your feedback. THANK YOU! Your continued Feedback in Action (#FIA) helps improve Excel for everyone. 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 Twitter.

Special thanks to our Excel MVPs David Benaim, Bill JelenAlan Murray, and John Michaloudis 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 about Excel. Alan is an Excel trainer, author and speaker, best known for his blog computergaga.com and YouTube channel with the same name. John is the Founder & Chief Inspirational Officer at MyExcelOnline.com where he passionately teaches thousands of professionals how to use Excel to stand out from the crowd.

Excel consulting ; Excel Consulting – Consultoria em Excel e Office 365

Partilhar:

Mais publicações

Excel

Excel’s 12 Number Format Options and How They Affect Your Data

Using Excel’s number format tool means you can ensure your spreadsheet both looks the part and handles your data exactly how you want it to. In this article, I’ll explain what each number format is, how to use it, and how it affects your data.

Things to Know Before You Start

Each cell has its own number format, which you can see by selecting a cell and seeing the Number group in the Home tab on the ribbon.

Excel

What’s New in Excel (January 2025)

Welcome to the January 2025 update. We are excited to announce that Copilot is now available to Microsoft 365 Personal and Family subscribers in most markets worldwide.
Also, this month, expanded text analysis tools with Copilot in Excel, focus cell for Windows and Mac users, and dark mode now available to Windows Insiders users.

Excel Consulting Image Blog

Microsoft Excel Finally Has a Dark Mode on Windows

https://www.howtogeek.com/microsoft-excel-dark-mode-windows A long-awaited display feature of Microsoft Excel has finally arrived—Dark Mode. You can now work on your spreadsheets with a darker theme on Windows PCs. As far as modern technological trends go, Dark Mode is certainly towards the top of the list. Indeed, it seems that every platform and program—from Google Chrome and Microsoft Edge to YouTube and Wikipedia—offers the option to switch from a white background to a black one. But there’s good reason to opt for this visual transition. Dark mode supposedly helps to reduce eye strain, often requires less battery power, is more favorable to individuals with light sensitivity, and projects a modernized, appealing appearance. Now, Microsoft Excel has joined the list, with the new feature allowing you to darken your entire worksheet, including the menu ribbon and even the cells themselves. If the darkened user interface concept is new to you, it’ll take some getting used to—but it’s worth giving it a try. People who have made the switch in Microsoft Word say that Dark Mode is now their default setting. This display change comes just a few months after Microsoft added Focus Cell—another visualization aid that lets you track the active row and column more easily—to its popular spreadsheet program. To enable Dark Mode, click “Switch Modes” in the View tab on the ribbon. In its blog announcement post, Microsoft added, “To make sure you are using a supported Office theme, select File > Account > Office Theme, and confirm that either Black or Use System Setting is selected.” It went on to clarify, “If you select the Use System Settings option, you will also need to make sure that your Windows theme is set to Black.” When you enable Dark Mode in Microsoft Excel, it won’t affect how others see the spreadsheet if you collaborate in real time or share it via OneDrive or email. Similarly, using Dark Mode on your desktop won’t automatically turn it on when you view the spreadsheet on your phone. In fact, this feature is currently only available in Excel for Windows to Microsoft 365 Insider members on the Beta Channel running Version 2502 (Build 18508.20000) or later. However, as with most Microsoft 365 features in their testing phase, Dark Mode will likely become generally available once Microsoft has verified its effectiveness and ensured its performance and positive user feedback. Whether Excel for the web, Excel for Mac, or the Excel mobile app eventually adopt this new feature remains to be seen. Excel consulting ; Excel Consulting – Consultoria em Excel e Office 365

Excel

How do I calculate answers in Excel?

You can create a simple formula to add, subtract, multiply or divide values in your worksheet. Simple formulas always start with an equal sign (=), followed by constants that are numeric values and calculation operators such as plus (+), minus (-), asterisk (*), or forward slash (/) signs.

© 2024 Created by wpexperts.pt