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.
- 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 Best Practice includes
.xlam Excel add-in (Compatible with Windows Excel 2010, 2013 and 2016 versions)
Acquire business license for $50.00
Add to cart
Add to bookmarks
- Rate this Downloadable Best Practice
Write a review
- Harbhajan Singh84(last updated: 14/09/2019 09:52)
- 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 Best Practice 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-in3,142add_shopping_cartfreeby Kevin Yassine
De-select Active Cell from a selection with a VBA MacroDe-select a cell from a collection of selected cells/ranges in an Excel worksheetcellmacroexcelvbautility240add_shopping_cartfreeby Michael Martin
BXL Org Chart Add-inCreate beautiful organization charts from Excel data in seconds.excelvbaadd-inor chartorganization chart150add_shopping_cart$9.50by Craig Hatmaker
Automatic Email Sending (with attachments) Excel VBA/Macro TemplateSend Multiple Emails Automatically to Customers with File attachments via EXCEL & OUTLOOK. VBA MACROmacroexcelvbaemail197add_shopping_cart$20.00by Rahim Zulfiqar Ali
Let it snow! Excel@ChristmasLet it snow in Excel!macroexcelvbachristmaslooping209add_shopping_cartfreeby Gary Knott
FMM - Financial Model MapFMM is a excel add-in to generate a formulae map of the Financial Model which help in reviewing complex financial modelsmacrofinancial modelvbamodel reviewexcel add-in446add_shopping_cart$99.00by Financial Modeler
Production Order and Inventory Control DEMODemo version of Production Orders and Inventory Control Spreadsheet!stockchartdashboardexcelvba226add_shopping_cartfreeby Marcus Servatti
Excel Financial Modelling CourseFinancial modelling using different scenarios to create robust structure, report setup, to create Excel magic.budgetingforecastingfinancial modellingexcelwebcast1,156add_shopping_cart$300.00by Marcus Small
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 modelling359add_shopping_cartfreeby Matthew Bernath
BXL FormatAdd corporate branding to any Excel workbook in less than 30 seconds.modelingexceladd-inmodellingformat1,022add_shopping_cart$10.99by Craig Hatmaker
External Links Report Add-InExternal links report add-inexceladd-inexternal links486add_shopping_cartfreeby Anurag Kushwaha
Any questions on Export/Import Add-in (for Financial Models)?
The user community and author are here to help. Go ahead!