Excel foundations and formula fluency: a free course
Learn Excel references, logic, SUMIFS, lookups and data cleanup through nine lessons, desktop labs and a checked sales-file case with an editable workbook.
THE FINX JOURNAL LEARN BY DOING
Better models.
Clearer thinking.
Practical guides to Excel and financial modeling. Work through the details, understand the mistakes, and build with more confidence.
Keep building your understanding
PAGE 2
Financial numeracy and business economics: a free course
Learn financial percentages, growth, time value, unit economics and decisions under uncertainty through nine lessons, original diagrams and a worked business case.
Budget vs forecast: update expectations without rewriting the plan
Learn the difference between a budget and a forecast with a dated monthly case: a variance bridge, two forecast versions and the annualizing trap.
Fixed charge coverage ratio: define the obligations before calculating
Calculate fixed-charge coverage under two stated conventions, reconcile debt service, and test a fictional covenant without double-counting lease payments.
INDEX MATCH with multiple criteria: solve a finance lookup exercise
Practice INDEX MATCH on a fictional ledger: entity, account and date criteria, a duplicate combination, a missing one and a text-stored date — with worked answers.
Remove duplicates in Excel: protect legitimate finance transactions
A payments ledger where look-alike rows are real transactions. Derive the composite key, preview removals with COUNTIFS, and reconcile control totals before anything is deleted.