The 6 Skills Every Financial Modeller Needs in 2026

Ask ten financial modellers what makes someone good at their job, and you’ll get ten different answers. Some will say Excel mastery. Others will point to attention to detail. A few will mention the ability to explain a model to a room full of non-technical stakeholders without losing anyone.

They’re all half right. Financial modelling isn’t one skill — it’s six, and most training programmes only ever teach one or two of them well.

Once you know what the six skills are, the next question is how to build them faster. The answer, more often than not, comes back to the same thing — a standard.

Why a standard changes the equation

Every one of these six skills gets easier when modellers aren’t reinventing decisions from scratch on every model. That’s the whole premise behind the FAST Standard, which F1F9’s founder co-authored: a shared set of conventions for how financial models should be structured, built and reviewed. When a team adopts a standard, entire categories of design decisions disappear — not because the work got easier, but because it stopped needing to be repeated.

With that in mind, here are the six skills — and where a standard like FAST removes friction at each stage.

1. Excel proficiency

This isn’t about knowing every one of Excel’s 450+ functions. It’s about knowing which 10–15 you actually need — the work-horse functions: simple, transparent, easy to understand — and using them consistently.

A proficient modeller sets up their environment deliberately: a considered choice of calculation mode, how the cell highlight box moves when you press Enter, editing in the formula bar rather than in the cell itself. These aren’t trivial habits. Being deliberate about where you edit formulas tends to carry over into being deliberate about everything else in a model.

VBA and macros have a place, but a good modeller restricts them to simple, transparent automation of repetitive routines — judging that simplicity and transparency beats macro routines that use everything VBA has to offer, just because they can.

2. Conceptual modelling

Conceptual modelling is probably the most misunderstood skill on this list, because it has nothing to do with Excel or spreadsheets. It’s the skill of describing what is to be modelled — the inputs, calculations and outputs, and how they fit together — before anyone opens a workbook.

Conceptual models get communicated in different ways: a conversation between the conceptual modeller and the spreadsheet engineer, a written brief, a wiring diagram on paper or screen, or dedicated software. Modellers often draw on experience from outside finance to do this well — accounting, treasury, banking, architecture, even philosophy can sharpen the logic flow of a model. Sector expertise compounds this further: a conceptual model built for one tranche of senior debt is often the strongest starting point for the next.

3. Model design

A good model designer can picture the entire financial model before writing a single formula. Design decisions exist at every level: who the end user is and what they expect, whether Excel is even the right platform, which modelling standards and conventions to follow, how many workbooks and worksheets are needed and in what order, where inputs sit, how outputs are presented, what quality-control checks are built in, and even how individual cells should look — fonts, colours, formatting.

This is the clearest place a standard pays for itself. A modeller working to FAST removes the majority of these decisions by adopting an established convention rather than deciding — and defending — their own approach on every engagement. The only risk left is choosing the right standard to begin with.

4. Model construction

Every financial modelling course worth taking teaches a repeatable process: model revenue one way, and operating costs will follow a similar pattern. Spotting those patterns is a core part of learning to build well. Good construction habits include:

• Clear, unit-labelled line items
• Row totals for every flow in or out of the business
• Consistent formula logic throughout
• Deliberate anchoring of cell references
• Calculations that are easy on the eye
• Clean, traceable references to earlier calculations

None of this is possible without basic mechanics. If you can’t touch-type, and you’re still reaching for the mouse instead of keyboard shortcuts, that’s the first resistance to break through — everything else on this list becomes far easier once you have.

5. Model review

Model review is about picking up someone else’s model — however it was built — and getting to grips with it fast. It draws on all the other skills, applied in a different direction: less building, more judgement.

Three things build this skill reliably:

• Learn to build models first. If you can build models and have a strong opinion on how to build them, you can apply that opinion to someone else’s work. The same navigation skills and shortcuts that make you fast at building also make you fast at reviewing — and building a shadow model to compare results is one of the most reliable ways to formally review a model.
• Develop professional scepticism. Assume there’s a mistake to find and an improvement to make. If a model’s structure isn’t immediately obvious and little thought has gone into the end user’s experience, that tells you something about the modeller as much as the model. Keep coming back to: why was this built this way when a better approach exists?
• Work from a review framework. Checklists and review software matter. The best frameworks are risk-based, weigh commercial outputs as heavily as technical calculations, and focus effort where it has the highest impact for the least time spent.

Reviewers working against a shared standard have an easier time on all three counts — deviations from FAST are visible immediately, rather than buried in a bespoke structure only the original modeller understands.

6. Presentation of results

If model review draws on all the other skills combined, presentation stands apart. It calls on a different competency altogether — not transparency of workings, but making the numbers tell a story.

A modeller with strong presentation skills will:

• Know their audience. Present what they expect to see. Plenty of rebuilt models keep the exact same output presentation even though a completely new calculation engine sits underneath — because that’s what the audience is used to reading.
• Have a sharp eye for design. Colour, white space, and visual impact matter. Expect to be ruthless about stripping non-essential information from every chart and graph, in the spirit of Edward Tufte and Stephen Few.
• Segregate presentation data. Keep the data behind charts in its own worksheet — a “Graphs” tab, for example — because the link between an Excel chart and its source data is never as robust as it should be.
• Use interface tools with care. Form controls and similar Excel features are valuable for building a usable interface, but only when built with the end user genuinely in mind.

Building the six skills together

None of these six skills develop in isolation, and none of them are optional if you’re building models that other people need to trust, use, and eventually take over. That’s the real argument for structured training and a shared standard: they don’t just make individual models better —

they make skill development itself faster, because modellers stop having to independently rediscover the same lessons on every project.