Sparklines

Sparklines are feature that is used to visualize small data series. These are charts contained in the cell, which can be columns, loss/gain columns, or line charts. This new option was released in Excel 2010 and it quickly found its way into the development of corporate reports, where key performance indicators or business trends should be emphasized. It allows us to easily see potential problems within beautiful and clear reports.

Document properties

Each document we create in Excel contains information about the name of the author as well as other properties that are automatically generated, and they say: when the document was made, when the last time it was changed and who changed it, what size was it, where it was finds, etc. After saving a document, if we want to share it with other users, it’s useful to check compatibility, accessibility and whether it has hidden information…

Tracking changes

Tracking changes to a document is used when multiple users are working in its editing. It is done so that we can see which user has made the changes, so that we can remove errors or make other changes that will improve the final version. This option only applies to shared documents. Even if we did not share it, after activating the tracking changes option it will become a shared document.

Autosave

Have you ever happened to lose data due to power failure or accidental voltage drop? I believe that this happened to all of us at least once. The only way to overcome data loss is to create a habit of periodically saving the document on which you work. But as far as you are dilligent, sometimes it can happen that this is not enough and you will be left without the fruits of your work. The solution is automatic document saving!