Excel model can be as simple as adding up two values in cell or so complicated to cover multiple sheets or even multiple workbooks. Ideally, as suggests experts, the excel model should be spilt into parts and named so that its liability to error can be reduced and error detection process becomes easier.
Just in context of such large and complicated model, it is often desirable to make a table of content sheet or a sheet we can use to navigate through the model. Such a sheet contain links to all of the sections of a model, usually sheets, that makes shuffling through them easier and makes your model look more professional, increases traceability of information and robust against errors.
Most of the time, we use our pointing devices, mouse and/or keyboard to navigate through a sheet. But today we will learn a trick that will allow us to move from one point to another one using “hyperlinks”
Wikipedia describes the one as “a link from a hypertext file or document to another location or file, typically activated by clicking on a highlighted word or image on the screen.” and we are going to do the same here.
FORMULAS WE WILL USE:
We will use two formulas …