Vikash KhanalFinance Manager · Trade Finance & Compliance

Free course · Foundation · 6 lessons · about 90 minutes

Excel and financial modelling for finance teams

A practical, self-paced course for accountants and finance managers who build MIS, budgets and cash-flow models in Excel. You will learn how to lay out a model others can trust, use the functions finance teams rely on, reconcile and clean data, build a linked budget model and a 13-week cash forecast, and present scenarios and MIS that people actually read.

Progress: 0 of 6 lessons
What you will be able to do
  • Design a model with separate inputs, calculations and outputs and built-in error checks
  • Write lookup, conditional-sum, date and dynamic-array formulas with correct syntax
  • Reconcile two ledgers and clean data using formulas, Power Query and pivot tables
  • Build a linked budget model with working capital, depreciation, debt and a balance sheet check
  • Prepare and roll forward a 13-week cash flow forecast with variance analysis
  • Run scenario and sensitivity analysis and review a model before it is shared

Final test and certificate

15 questions drawn from a bank, marked on the server. Score 11 or more (70%) for a certificate of completion with a public verification link and an “Add to LinkedIn” button.

Go to the final test

General information for learning, not professional advice. Laws, rates and standards change: confirm with the official source or your adviser before acting. Last reviewed 15 November 2026.