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.

Too many worksheets?

If we choose to create a complex Excel document that combines all the elements of a business process, we will try to call everything nicely, mark it, color it … During this process, we will create multiple worksheets, and sometimes give them long names in order to describe them as accurately as possible. The trouble is that the document can then become overloaded. The goal of this “recipe” is to show you a simple trick to find the desired worksheet faster.