Excel for Finance
The formulas every finance job uses, practised in a live spreadsheet that checks your work.
Excel · 5 courses
Excel courses with practice exercises
These Excel courses teach the spreadsheet skills that finance, accounting and analyst jobs take for granted, and they teach them by making you type the formulas yourself. Every lesson is a lab in an Excel-like grid that runs in your browser, so you need no Excel licence. A coach checks each cell the moment you finish, including whether you used a formula or just typed in the number, and explains what went wrong.
Start with the free Excel for Finance course: percentages, absolute references, IF, SUMIFS, XLOOKUP, rounding and payment terms, with a free certificate at the end. Excel Essentials covers the basics for complete beginners, from data entry to a monthly sales report. Advanced Excel Formulas takes you to multi-criteria lookups, SUMPRODUCT, array maths and financial functions, and Excel Charts & Data Visualization teaches you to choose and build the right chart, from combo charts with a secondary axis to histograms and waterfalls. Excel What-If Analysis builds scenario selectors, one- and two-variable data tables, Goal Seek by hand and tornado charts for any model. The courses suit students, career changers and anyone who uses Excel at work and wants to stop guessing.
Courses in Excel
Excel Essentials: Beginner to Advanced
From your first formula to lookups, text, dates and SUMIFS: 10 hands-on labs, every cell checked instantly.
Advanced Excel Formulas & Functions Masterclass
Two-way and multi-criteria lookups, SUMPRODUCT, array maths, text, date, statistical and financial formulas – 10 hands-on labs ending with a broken report you repair, every cell checked instantly.
Excel Charts & Data Visualization
Column, bar, line, pie, stacked, combo, scatter, histogram and waterfall charts plus conditional formatting and sparklines: 10 hands-on labs, every chart checked by the Coach.
What-If Analysis: Scenarios, Data Tables & Goal Seek
Build input-driven models, scenario selectors, one- and two-variable data tables, goal seek by bisection, break-even solving, tornado charts and a Monte-Carlo-style simulation, every cell checked live.
Guides with worked examples
SUMIFS Examples: Sum with Multiple Criteria in Excel
SUMIFS examples with real data: two criteria, a date range, greater than, wildcards, "not equal" and COUNTIFS, plus the mistakes that return 0.
XLOOKUP vs VLOOKUP: Differences and When to Use Each
XLOOKUP vs VLOOKUP side by side: exact match defaults, lookups to the left, not-found values, approximate matches and compatibility, with a worked example.
How to Make a Waterfall Chart in Excel (2 Methods)
How to make a waterfall chart in Excel: the built-in chart with Set as Total, and the stacked-column method for older Excel. Example with formulas.
How to Make a Histogram in Excel: Bins, Chart & COUNTIFS
How to make a histogram in Excel: the built-in chart with bin width and overflow bins, a COUNTIFS bin table, FREQUENCY and the ToolPak. Excel example.
How to Calculate WACC in Excel: Formula & Example
Calculate WACC in Excel step by step: CAPM cost of equity, after-tax cost of debt and market-value weights, with a worked example (8.95%).
How to Calculate VAT from Gross: Reverse VAT Formula
Calculate VAT from a gross amount: net = gross ÷ (1 + rate), VAT = gross − net. Excel formulas, examples at 20%, 19% and 5%, and the classic mistake.
Frequently asked questions
Do I need Microsoft Excel for these courses?
No. Every lab runs in an Excel-like spreadsheet in your browser. The formulas use the same English function names and syntax as Excel, so everything you practise works in Excel and Google Sheets too.
Is there a free Excel course with a certificate?
Yes. Excel for Finance is free from the first lesson to the final exam, and passing the exam gives you a verifiable certificate at no cost. In the other Excel courses the first one or two lessons are free.
Which Excel course should I take first?
If formulas are new to you, start with Excel Essentials. If you already know SUM and IF, start with Excel for Finance, then continue with Advanced Excel Formulas, the charts course or What-If Analysis.
More categories
Open your first lab in under a minute
Free lessons work without an account. Sign up to save your progress.