Naming Conventions
Executive Summary
Key Takeaways
- ✓ Naming conventions govern how worksheets, files, and versions are named, distinct from a named range, which labels an individual cell or range inside a formula.
- ✓ A consistent naming convention lets a reader identify what a worksheet or file is without opening it, and confirm which version of a model is the current one.
- ✓ Naming conventions are most effective when agreed with all contributors before a build begins, rather than retrofitted onto a model already in progress.
Definition¶
Naming conventions, in financial modelling, are the agreed rules a team applies to naming worksheets, workbook files, and version identifiers, so that a reader can identify what a sheet or file is, and confirm which version is current, without opening it. This is distinct from a named range, which is a specific Excel feature labelling an individual cell or range of cells for use inside a formula — naming conventions operate at the file and worksheet level; named ranges operate at the individual cell level.
Why It Matters¶
A model with inconsistent or ambiguous names — worksheets called "Sheet1" or "Copy of Model (2) FINAL" — is materially harder for a new reader to navigate and creates real risk of the wrong version being relied on for a decision. A consistent naming convention, agreed before a build begins, removes this ambiguity. See Workbook Design and Model Architecture for the full treatment of naming as part of overall model layout, and Named Range for the related, but distinct, cell-level naming feature.
Continue Reading¶
Prerequisites¶
- Financial Modelling Best Practices — the parent pillar
Related Technical Guides¶
Related Glossary¶
- Named Range — a related but distinct, cell-level naming feature
- Model Architecture
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What are naming conventions in financial modelling?
The agreed rules a team applies to naming worksheets, workbook files, and version identifiers, so a reader can identify what a sheet or file is, and which version is current, without opening it.
How do naming conventions differ from named ranges?
A naming convention governs the names of worksheets, files, and versions — the containers. A named range is a specific Excel feature that assigns a label to an individual cell or range of cells, used inside formulas. They are complementary practices addressing different objects in the model.
What should a file naming convention include?
Typically the model's name, a version number, and a date, so the current, final version can be identified without opening the file — see Workbook Design and Model Architecture for the fuller treatment of file and worksheet naming as part of overall model layout.
Related Articles
Workbook Design and Model Architecture
Workbook design and model architecture is the specific skill of deciding how a financial model's worksheets are ordered, how a reader moves through them, how cell types are visually distinguished, and how sheets and files are named. It is distinct from the broader engineering principles covered in Spreadsheet Engineering and the policy-level standards covered in Model Standards — this guide addresses the concrete layout decisions a model builder makes before entering a single formula. A well-architected workbook is not a matter of taste — it determines how quickly a reviewer, lender, or successor analyst can navigate the model and trust what they find.
Named Range
A named range is a label assigned to a specific cell or range of cells in Microsoft Excel (or another spreadsheet application) using the Name Manager. Once named, the label can be used in formulas instead of the cell's coordinate reference (such as B12 or Sheet1!B12), making formulas more readable and reducing the likelihood of reference errors. Named ranges can refer to a single cell, a range of cells, a constant value, or a formula. They are defined at either the workbook level (accessible from any sheet) or the sheet level (accessible only from a specific sheet).
Financial Modelling Best Practices — Standards Compared
Financial modelling best practice is not a single document but a landscape of named institutional standards, each publishing its own conventions for how a model should be structured, formatted, and documented. This page defines that landscape — what a named modelling standard actually is, how the FAST Standard and the ICAEW Financial Modelling Code differ in approach and scope, and how a practitioner chooses between them or applies more than one. It sits beside, not instead of, the Knowledge Centre's structural-foundation page on what makes an Excel financial model reliable — this page is about who has codified that discipline into a named standard, and how those standards compare to one another.