## About this lesson

An explanation of the reason models should be consistent, and key elements of a workbook that should be consistent.

## Exercise files

Download this lesson’s related exercise files.

CRaFT - Consistency.xlsx11.6 KB CRaFT - Consistency - Solution.xlsx

12.1 KB

## Quick reference

### CRaFT - Consistency

Understand ‘Consistency’ in the CRaFT methodology.

### When to use

A key concept in financial modeling ‘Consistency’ can help model developers decide how best to design financial models. Models constructed consistently are easier to understand as users become familiar with both their purpose and content. This will in turn give users more comfort about model integrity and make it easier to add / remove business units, categories, numbers of periods, scenarios, etc.

### Instructions

- Use model formulae sparingly and ensure it is kept consistent.
- Ensure periods and formats are kept consistent between worksheets.

#### Keeping formulae consistent

An efficient and consistent way of copying formulae across rows and down columns is as follows:

- Highlight the range of cells
- Type the formula into the formula bar
- Hold CTRL + ENTER to copy the formula across and down the range

To find inconsistent formulae within a range of cells

- Highlight the range of cells
- Hold CTRL + BACKSLASH (\) – to check for inconsistent formula between rows
- Hold CTRL + SHIFT + BACKSLASH (\) – to check for inconsistent formula between columns

The use of anchoring (dollar signs - $) to keep formulae consistent when copying formulae across rows or down columns

- Click into a formula
- Select F4 to include $ into the formula
- Continue to select F4 to toggle the $ between the formula – everything to the right of the $ will be held constant

Lesson notes are only available for subscribers.