Share this blog
The Financial Modeler- Conditionnal Format Controls – Part Deux
- Spotting Errors
- How to Model Depreciation
- Improve Table Visualization using OFFSET and Conditional Formatting
- OFFSET Function Tutorial
- Getting More From Your Pivot Tables
- Conditional Formats Control – The Warm-Up
- Improve your model now! #REF Editions
- Back to School – The Excel Model
- R1C1 Enlightenment
Tag Archives: Best Practices
Seven tips to develop a structured model
Create A Modular Design For Your Model
Don’t put everything on a single worksheet. Separate your model’s components on multiple worksheets, i.e. Revenues, COGS, Other Costs, Financing, Amortization etc…
Keep Your Sheet Names As Short As Possible
It will help keep formulas legible and you’ll see more sheet tabs at once which will help browse within the workbook. [...]
Best Practice Fundementals – Inputs
One of the most common mistake in model development is the lack of clear distinction between inputs and calculations. Even worse are inputs hidden within formulas.
Let’s look at the following simple example which computes the present value of two distinct scenarios.
Without looking at each cell, one can only guess what are the inputs. It could [...]
Spotting Errors