“Actually an ordinary story, like Cinderella”… these are the words of an old hit from the ’80s, and they came to my mind as an illustration of what I want to describe in this text: a comparison chart of budgeted vs actual. If we use the display of data on the secondary axis, we can easily compare planned and realized values, which can be important for displaying intuitive reports.
Go To Special is a somewhat neglected, but sometimes very useful option that allows us to position ourselves in individual places in an Excel table according to their properties. These can be empty rows, formulas, precedents, dependents, cells with data validation, etc. In this text, you will learn how to start this option, and you will also see two examples of its application in practice.
How to add an empty row after each row of data in a table? This procedure is often necessary so that we can comment on reports that need to be printed. It can be achieved in several ways and one of the simplest is by usint the Sort option. In this text, you will learn how to perform this action.
Version History is a great feature that can be used by all Microsoft 365 subscribers who store files on a SharePoint or OneDrive repository. Storing files in the cloud brings a lot of benefits, one of which is the overview of all versions and the ability to restore a previous version of an Excel document that was worked on by one or more users.
Writing Excel formulas with the help of Name Manager can be a demanding job. When you write simple formulas, you will still somehow manage. With complex formulas or changing existing ones, there is a high chance that you will make a mistake. The LAMBDA feature allows you to create your own functions as names added in the Name Manager, and to make this job easier, Microsoft has created an Excel add-in for creating complex formulas: Advanced Formula Environment.