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…
Excel has recently made it easier to work with formulas that use arrays and constants – you no longer have to save them by pressing CTRL+SHIFT+ENTER! We can now use lists of values, given in curly brackets, as function arguments. This is great news, and the possibilities are manifold. In the following post, you will be able to see the real application of this feature…