Building a Financial Model – Use Spreadsheet Cell Maps to Detect Errors

Use Spreadsheet Cell Maps to Detect Errors

CellmapsWhen building a financial model, using cell maps at various points in the spreadsheet can quickly help identify cells that have been wrongly copied in a financial modeling project.

For instance, a cell map may help a good financial analyst quickly identify a constant in an array of calculation formulas on a spreadsheet, thereby alerting the financial analyst that a calculation formula has been pasted incorrectly.

Look at the illustration for an example of a spreadsheet cell map.

Visit Finance 3.0 - don't miss out on this high quality financial learning opportunity

Comment on this article