Export/Import Add-in (for financial models)
Shades all inter-sheet links with RED (Links-out) or BLUE (Links-in) in the whole workbook.
The FAST modelling Export-Import Add-in is one of a kind add-in for identifying and tracking cross sheet calculations (popularly known as Exports / Imports or Links-out / Links-in). If you are a financial modeller builder/reviewer, this add-in is an absolute must.
This add-in automatically shades all exports and imports throughout the whole workbook with a click of a button. Contains variety of options like
-Choice of Shading colors
New ribbon options added in the latest version.
Your business relies on information in spreadsheets and financial models to make key business decisions. But Errors happen easily; more so if a business is not using standards and procedural controls.
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. F.A.S.T, a fastest growing best practice modelling standards, says to "Mark exports with red font and imports with blue font".
Why marking export is crucial?
a. they tend to be significant line items on the sheet and the immediate visual identification of that is useful; and
b. deletion of these line items is going to cause repercussions elsewhere in the model that will have to be managed.
c. Further, this helps when you need to understand a model structure and gets you the answer for questions like which cells flow to output sheet, which are inputs, which are local calculations, etc.
What you lose if you don't have export/import markings?
- You loose ability to identify important lines within a sheet
- Ability to know whether the calculation block is redundant or not.
- No idea if a calculation is present in the same sheet or other sheet.
- No Information about incorrect or missing line-linkages across sheets.
- Ability to spot blank cell references across sheets, which are difficult to find, and pose a significant risk to the model.
This add-in is like an X-Ray Report of the financial model, highlighting important lines and revealing the modelling structure.
Well, if you want to find out what this add-in can do download the trial version from the link above.
Or buy it from eloquens ... to get access to additional but crucial options, including any free future updates.
- 1) Open Excel and Go to File->Excel Options->Add-ins.
- 2) In Manage drop-down select Excel Add-ins and press Go.
- 3) Now go to Browse and navigate to the Add-in file. Press Open and then Ok.
This should bring up the FL Add-in Tab in the Ribbon.
This business tool includes
.xlam Excel add-in (Compatible with Windows Excel 2010, 2013 and 2016 versions)
Acquire business license for $10.00
Add to cart
Add to bookmarks
- Shae Seppi, MBA(last updated: 25/12/2018 16:27)
- J M Niaj(last updated: 23/09/2017 08:53)Its a boon for Financial Models
People using this tool also downloaded
Free Multi-purpose Excel Modelling Tool (Add-in)Free Microsoft Excel modelling add-in containing a wide range of tools for navigation, formatting and excel modelling.toolmacroexcelvbaadd-inexternal linksmodellingmulti-purposefind errorsmisspelled cells1,125 remove_red_eyefreeby Kevin Yassine
Basic Animator/Simulator in ExcelThis is all about the first step to consider Microsoft Excel as Framework for the as Simulator or as Animator.chartexcelvbasimulator#animationplotteranimator33 remove_red_eye
External Links Report Add-InExternal links report add-inexceladd-inexternal links163 remove_red_eye
Excel Financial Modelling CourseFinancial modelling using different scenarios to create robust structure, report setup, to create Excel magic.budgetingforecastingfinancial modellingexcelwebcastvideowebinar181 remove_red_eye$300.00by Marcus Small
An Introduction to VBA CourseThis course will help you understand the fundamentals of VBA so you can program all by yourself.learningexcelvbacustomizationcodeapplicationsautomationcourseadvanced skills103 remove_red_eye$80.00by Marcus Small
Multiple Email Sending TemplateAn easy-to-use template to send a generic or customized email to multiple email addresses at the same time.templateexcelvolumeeasyvbaemailmultiple emailsendoutlookmany86 remove_red_eye$10.00by Kevin Yassine
How to Use the Scenario ReporterThis effective scenario reporter is accompanied by a clear and easy-to-follow PDF guide and YouTube Tutorial.variablesscenariosexcelsheetvbareporterautomatization35 remove_red_eye
QuickRows. Excel made easy! (Excel Add-In)A multipurpose tool to select rows, totalize tables, link or append sheets and standardize tables inside Excel.excelvbaaddindata miningbig dataexcel addinregular expressionspivot tablesdinamic tables30 remove_red_eye$299.00by Jose Corona
How to make Financial Models Easier to Understand, Use and Audit (5 tips)A guide with 5 tips to build Financial Models easy to Understand, Use and Audit.guidebest practicetipsfinancial modelingfinancial modellingexcelfinancial modelsspreadsheetsNew!
Any questions on Export/Import Add-in (for Financial Models)?
The user community and author are here to help. Go ahead!