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!
Excel has recently gained several new features that make it easier to focus on the content, i.e. the tables we work with. First, the menu with color palettes is now much larger and more noticeable, and the choice of colors is more adapted to visually impaired people or those who do not perceive the differences between colors well. Then there is a new option that allows you to focus on the cell, making it easier to work with large tables.