The larger a worksheet becomes, the more difficult it is to manage, and finding particular cells can prove difficult in the same way as finding a specific location in a vast landscape.
The solution to both problems is to have a good map; one which produces a compact and accurate representation of a larger reality. One of the drawbacks of Excel is that it has no built-in facility for generating such a map.
The Map functionality generates a graphical map of the structure of every sheet in a workbook or of a selection of the worksheets in a workbook, helping you to identify various worksheet features and to locate errors in the logic of the worksheets.
Visually map out contents, including formulas, numeric, logical constants, range names and more. See the logic behind a spreadsheet and gain a clear understanding of how it is functioning.
OAK colour codes the information you ask it to map, making it even easier and more convenient to quickly and accurately take in.
The map analysis worksheet OAK creates will clearly show you the consistency across rows and columns. Any inconsistencies or anomalies will be flagged for your attention.
It is simple to trace back inconsistencies from the map using OAK. The add-in will take you directly back to the original cell in the model where the error originated.
Map serves as an auditing tool, enabling quick detection of errors and inconsistencies in worksheets and creating a record of what you have done. This can be easily shared or printed to help explain the information to others effectively.
Many Excel add-Ins have functions similar to map spreadsheet data, but OAK’s stands out as the most impressive. Our feature reduces visual distractions and emphasizes the identification of input cells, their categories, and formula cells. OAK also highlights cells included in arrays. Dynamic array and spill formulas are clearly distinguished.
We offer a 30 day free trial, sign up today to try mapping in excel with OAK for yourself. We are confident that you will enjoy the way OAK can streamline your spreadsheet modelling process.
