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.
The address of a cell in Excel is formed by combining the column label and the row number. For example, the address A1 indicates that it is a cell that is in the first row of column A. However, we can also assign an address in another way- by using the row number label and the column number. Thus, cell A1, in this alternative notation, would have the address R1C1. How to change the way the address is assigned and can it be of practical use?
Automatic saving of Excel documents has been around for a very long time. If you go to Excel Options, in the Save section, you will see the option to Save Autorecover Information Every… and the number of minutes after which the saving is performed. However, this works if your computer resets or for some other reason stops working. With the advent of the OneDrive repository and storing documents on it, we got a new, better Autosave…
Although Excel recognizes only two types of data: numbers and text, sometimes you’ll be working with Boolean values, such as TRUE and FALSE expressions. There is a simple trick to convert these values into ones and zeros respectively, so that you can add them more easily, and you will find out how to do this in a short “recipe” that follows.
More recently, Microsoft Copilot, an AI-based assistant, has become an integral part of Excel in all its versions. Now it can help you, in English or another language, analyze data, create charts, offer you the appropriate Excel function, or show you its syntax. To put a long story short, it can make your daily work much more productive!