How to Learn Financial Modelling From Scratch in 2026
By Thomas & Øyvind — NorwegianSpark
Last updated: April 2026
This tutorial is for educational purposes only and does not constitute financial advice. Always consult a qualified financial adviser before making investment decisions.
Understand what financial modelling is
A financial model is a spreadsheet that represents a company's financial performance and projects future outcomes. Used by analysts, investors, entrepreneurs, and bankers. Core models: DCF (Discounted Cash Flow) for valuation, LBO (Leveraged Buyout) for private equity, Three-Statement Model (P&L, Balance Sheet, Cash Flow) as the foundation for everything else. Understanding these three models covers 80% of what finance professionals need.
Learn Excel or Google Sheets to an advanced level
Financial modelling lives in spreadsheets. Required skills: INDEX/MATCH, VLOOKUP, pivot tables, data validation, array formulas, named ranges, conditional formatting, and keyboard shortcuts for speed. Free resources: Excel Jet, Chandoo.org. Accelerate with PopAI to auto-generate formulas while you learn — ask it to explain each formula it creates so you understand the logic.
Take a structured quantitative finance course
The Bayesian School of Technology offers a data science curriculum that directly applies to quantitative finance: probability, statistics, regression, Python for data analysis. Alternatively, CFA Institute's free resources cover fundamental financial analysis. Khan Academy covers the math foundations if you need a refresher. Budget 10-15 hours per week for 3 months.
Build your first model from scratch
Choose a public company you understand well. Download their last 3 years of annual reports (10-K for US companies, available on SEC EDGAR). Build a three-statement model: income statement projections, balance sheet, cash flow statement. Link all three statements together so changes flow through automatically. Expect this to take 20-30 hours the first time — it gets faster with practice.
Get feedback on your model
The best way to improve is peer review. Finance communities: Wall Street Oasis, r/financialmodeling, LinkedIn finance groups. Share your model and ask for specific feedback on your assumptions and structure. If English is not your first language, a Preply business English tutor who specialises in finance can help you present your work confidently in professional settings.
Build a portfolio of 3 models
One tech company, one consumer goods company, one financial services company. Document your assumptions clearly, explain your methodology, and note where your projections differ from consensus. Publish on LinkedIn or a personal site. This portfolio is more valuable for job applications than any certificate — it shows you can actually do the work, not just pass a test.
Frequently Asked Questions
How long does it take to learn financial modelling?
With 10-15 hours per week of focused practice, you can build competent models in 3-6 months. Mastery takes 1-2 years of regular practice. The key is building real models, not just watching tutorials.
Do I need a finance degree to learn financial modelling?
No — many successful financial modellers come from engineering, math, or science backgrounds. The quantitative skills transfer well. What matters is your ability to think logically about financial statements.
What software do financial modellers use?
Microsoft Excel is still the industry standard for 95% of financial modelling work. Python is increasingly used for data analysis and automation. Google Sheets works for learning but lacks some advanced features.
Is Python replacing Excel in finance?
Python is complementing Excel, not replacing it. Excel is used for model building and presentation. Python is used for data cleaning, automation, and quantitative analysis. Learning both gives you the strongest skill set.
What is the best online course for financial modelling?
It depends on your starting level. For complete beginners: Bayesian School of Tech for the quantitative foundation, then CFI or Wall Street Prep for finance-specific modelling. For experienced analysts: a focused Python for Finance course adds the most value.
Related Tutorials
How to Track Your Investment Portfolio With PopAI (2026)
Use AI-powered spreadsheets to analyse your portfolio performance, compare to benchmarks, and generate monthly reports.
How to Buy Your First ETF in 30 Minutes (Step-by-Step 2026)
Beginner-friendly step-by-step guide to buying your first ETF in 2026. From choosing a broker to setting up recurring investments.