Comparative review

Sometimes it is necessary to open two Excel files and perform a comparative review. This can be done in several ways but one of the most effective is by using the View Side By Side option. In the text that follows, you will see how this option is used, and as an example, we will take two files containing lists of employees with the value of their salaries in two comparative years.

Export of documents

We are accustomed, when we want to change the type of Excel document, to save it under another name. However, in some recent versions of Excel, this operation is further facilitated. If we enter the Backstage view there we will find the Export menu that allows you to export directly to PDF or change the file type. Also, you can also directly add documents to Power BI.

Error Checking Options

Excel has built-in functionality that allows automatic error checking when entering values ​​in cells. Where he recognizes or finds error, a small green triangle in the upper left corner of the cell and a warning icon (a yellow diamond with an exclamation point) will appear. If you click on the icon then a menu will open that explains why the error occurred and offers a way to overcome it.

Bulleted lists

Bulleted lists are functionality that is more commonly used when working with MS Word than with Excel. There is no adequate translation into Serbian, but it is about the lists of items that we quote “under theses”. Excel does not support automatic numbering, but with the option to insert symbols, we can add squares, circles, and other bullet symbols to achieve the desired effect.

Drawing borders

This is, I must admit, a very fun option and totally different from what you get used to when working with Excel. On the other hand, if you are not skilled in formatting the table framework, it can help you to draw the tables in which you will enter the data. This option has not always been in Excel, so I believe that many experienced users do not know that it exists. Below you will find out more about drawing the framework of the table.