What’s New in Excel (January 2025)

https://techcommunity.microsoft.com/blog/excelblog/whats-new-in-excel-january-2025/4357005

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 for Windows, Mac, and web:
– Text Analysis in Excel

Excel for Windows and Mac:
– Focus Cell
– TRANSLATE & DETECTLANGUAGE Functions

Excel for Windows:
– Dark Mode in Excel (Insiders) #FIA
– Improvements to five text functions (Insiders) #FIA
– New Forms Integration for Windows #FIA

Excel for Windows, Mac, and web

Text Analysis in Excel
We’re introducing a new suite of text analysis capabilities that makes Excel a one-stop shop for analyzing your text data, whether you want quick and easy insights or deep analysis. Combined with Excel’s power for numerical analysis and data visualization, you’ll be able to get actionable insights from text like never before. By using Copilot in Excel, Python in Excel, or the new text functions you’ll be able to quickly manipulate and analyze textual data more easily.
Read the full blog here >

Copilot can scan your text data and return a summary of the text and a list of themes

Excel for Windows and Mac

Focus Cell
Focus Cell applies vibrant highlights to the corresponding row and column of the active cell and increases the active cell’s border thickness. This makes the active cell more visible and facilitates easy identification of data across the same row and column.
Read more here >

Animation showing Focus Cell in an Excel worksheet

TRANSLATE & DETECTLANGUAGE Functions

We are introducing two new functions designed to simplify and automate translations directly within your spreadsheet.  Read more here >

TRANSLATE() – a function that translates a text from one language to another.

GIF showing the TRANSLATE function

DETECTLANGUAGE() – a function that detects the language of the specified text.

GIF showing the DETECTLANGUAGE Function

Excel for Windows

Dark Mode in Excel (Insiders) #FIA
This highly requested feature aims to reduce eye strain, increase energy efficiency, improve accessibility, and enhance the overall user experience with dark mode in Excel for Windows. This feature is currently available to Windows Insiders users. Read more here >

Improvements to five text functions (Insiders) #FIA
Based on your feedback, we have made some improvements to five of our text functions (LEN, MID, SEARCH, FIND, and REPLACE) that will make them work better with Unicode characters – plus, introduce Compatibility Versions, which will allow us to improve functions without changing the results in existing files.
Read more here >

New Forms Integration for Windows #FIA

Users can now sync responses to the Windows app. In addition, users can now create a new Microsoft Form directly within an Excel workbook, linking the form to the workbook seamlessly. This was previously available for Web users, with Mac support coming soon.
Read more here >

GIF showing how to create a new linked form from the Excel desktop app

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 Jelen, Alan 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’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.

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

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.

Como fazer uma tabela no Excel?

Selecione as células que contêm os dados. Clique em Página Inicial > Tabela > Formato como tabela. Se você não marcar a caixa Minha tabela tem cabeçalhos , Excel para a Web adicionará cabeçalhos com nomes padrão como Coluna1 e Coluna2 acima dos dados.

What’s New in Excel (January 2025)

Excel for Windows, Mac, and web

Excel for Windows and Mac

Excel for Windows

Partilhar:

Mais publicações

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

Microsoft Excel Finally Has a Dark Mode on Windows

How do I calculate answers in Excel?

Como fazer uma tabela no Excel?

Serviços

Consultoria em Excel e Office 365

Desenvolvimento em PowerApps e PowerBI

Dashboards Interativos

Gestão e Integração de Bases de Dados

Links Úteis

Política de privacidade

Termos e condições

Contactos