The Export-Import Add-in is one of a kind add-in for identifying and tracking cross sheet calculations (popularly known as Links-out / Links-in). If you are a financial modeller builder or a reviewer, this add-in is an absolute must. It automatically shades all exports and imports throughout the whole workbook with a click of a button. In financial modelling terminology - A line item that is used on / referenced by another worksheet in the model is called an Export. The dependents of an Export is an Import. It helps you find crucial errors in financial models which would otherwise go undetected in many cases. Download the free addin now.
Learn More Download
The Linking to other workbooks is a very common task in Excel, but sometimes you might find yourself with a workbook that has links you can’t find even though Excel tells you they exist. Excel provides no automatic way to find all external references that are used in a workbook, however, there are several manual methods you can use to find them. You need to look in formulas, defined names, objects, charts, conditional formats, data validations . . . huh.
But here's a wonderful add-in External Links Locator that get's the job done automatically for you and generates a report listing all such direct cell references.
Dashboarding is an art which requires gathering all the required outputs along with keeping the design simple. It also requires an understanding of the business requirement in order to display appropriate information. Even the placement of items is crucial, as unlike online dashboards provided by visualization tools like Power BI, Spotfire, Excel Dashboard needs to be built in such a way that it fits perfectly within the narrow screen. Too much screen coverage horizontally can make it hard to navigate on smaller screens. We have gathered some excellent and pretty dashboard design for you to use it in your models. We also build custom dashboards for your models. Follow the link to download.
Learn More