Since 2018, Excel has undergone one of the biggest transformations in its history with the introduction of functions for working with dynamic arrays. Unlike traditional functions that return a single value, these functions can generate entire tables as a result. Because these tables are dynamic, any change to the data in the source is automatically reflected in the displayed result. How to format dynamic results?
Recently, in the lower right corner of every Excel or other Office document, you can notice a new floating icon that allows direct access to the Copilot application. When you hover the cursor over it, a context menu with several useful options automatically opens, while clicking on the icon or pressing the F6 key, on the right side of the Excel window, opens a panel that allows direct correspondence with Microsoft Copilot.
How to take the first few rows from a table? How do we make this a parameter that we can change? This feature can be useful when we simply want to retrieve the first few rows from a table, or when it contains e.g. some sales data, we can sort them in descending order by the column that contains the sales value, and then we extract the Top 5 items.
The TRANSLATE function became part of Excel in July 2024, and recently we have another useful function that you can use to detect the language in which a text is written. It’s a new DETECTLANGUAGE function, and you can use it in conjunction with the TRANSLATE function.
When you enter decimal numbers, depending on the Region settings, you will use a decimal point or a comma. In most cases, this is done once, and we don’t deal with this topic anymore. However, it may happen in practice that you import data, most often from a CSS file, where different characters are used to separate decimals and groups than those you use by your local settings. In this case, use the NUMBERVALUE function…