skinny.

Latest / ModeLoop: Financial Modelling in Excel

Excel Formatting for Financial Models: Colour Coding & Number Formats (P2E2)

Good formatting makes a financial model clear, trustworthy and easy to audit. These conventions are the financial modelling best practices behind every professional model. This lecture covers the professional formatting framework used on real deals: colour coding (blue for inputs, black for formulas), number formats, units and layout conventions.

In this episode:

Colour coding: blue inputs, black formulas, green links

Number formats for thousands, millions and percentages

Consistent layout and column structure

Formatting that makes models faster to review

📖 Full blog post…

Log in to save or queue this episode.

The skinny

The skinny isn't ready yet — notes appear once the transcript is processed.