Financial modelling skills open doors across finance, from investment banking to FP&A and advisory. This podcast episode covers the benefits of learning financial modelling and the practical steps you can take to build those skills into your career.
Andrew Codd interviews Lance to help people understand the benefits of learning financial modelling and the practical steps people can take to embrace it in their careers.
Financial modelling careers: frequently asked questions
To automate the repeatable parts of modelling, we built EXL Cloud, our own SaaS modelling platform: driver-based 3-way models in Excel, connected to Xero, with a library of Claude skills that help build, check and report on the model while the modeller keeps control of the logic.
Why should finance professionals learn financial modelling?
Modelling turns business assumptions into forecasts that show how decisions affect profit, cash and the balance sheet. That skill is valued in investment banking, corporate finance, FP&A, advisory and CFO roles because it supports funding, valuation and planning decisions. It also builds a deeper understanding of how businesses make and spend money, which helps in almost any finance career.
Is modelling used in investment banking?
Yes. Investment banking relies heavily on models for valuations, mergers and acquisitions, capital raisings, IPOs and project finance. Analysts build them to test deal structures, estimate value and show how a transaction affects the business. The same skills transfer well into corporate finance, private equity, FP&A and advisory roles.
What practical steps help you build modelling skills?
Start with strong Excel skills, then learn a recognised modelling standard so your work is consistent and auditable. Build a simple 3-way model linking the profit and loss, balance sheet and cash flow. Practise on real scenarios, ask experienced modellers to review your work, and consider a structured course or qualification to fill gaps faster.
How long does it take to become a competent modeller?
Most people can build a basic 3-way model within a few weeks of focused practice if they already know Excel. Becoming confident with complex work, such as project finance or valuation models, usually takes months to years of hands-on experience. Regular practice on real business problems matters more than the number of courses completed.
Do you need a qualification to work in financial modelling?
No qualification is mandatory, and many strong modellers learned on the job. A recognised qualification can still help by giving you a structured learning path and evidence of your skills for employers. Whatever route you choose, a portfolio of well-built models and the ability to explain them clearly carry real weight.
Need a financial model built or reviewed for your business? See our Financial and Business Modelling services.
About the Author
Lance Rubin is CEO and Founder of Model Citizn, and founder and Chief Excel Officer of EXL Cloud, the SaaS platform that connects Xero to Excel with driver-based financial models, dashboards and Claude AI skills. He is a Chartered Accountant, FMI Certified Trainer, co-author of the CA ANZ Financial Modelling Study Guide, and creator of the AI-Powered Accountant programme on Maven, currently live at Level 1 with Level 2 in design, and author of the companion book “AI-Powered Accounting with Excel and Power BI” (Packt). He has worked at PwC, KPMG, Investec, and NAB, and is based in Melbourne, Australia.
Related reading: Best Practice Formula Construction for Financial Modelling and The Demand for Financial Modelling Skills Reaches new Heights.

