Prep Course · Available now

Excel Fundamentals — Formulas for Finance

From relative and absolute referencing, to logic and lookup functions, to the core financial functions (NPV, IRR, PMT) — with an interactive lab and a real Excel exercise.

Start the lesson Download Excel template (blank)Download the solved model

If the file opens in read-only mode (Excel Online), use File → Create a copy → Download a copy to get an editable copy on your device.

Lesson 1

Cell Referencing: Relative vs. Absolute

Lesson 2

Logic & Lookup Functions: IF, VLOOKUP, INDEX/MATCH

Lesson 3

Financial Functions: NPV, IRR, PMT

Glossary

Case Study

Case Study: Al-Amal Manufacturing

Test yourself

Test your understanding of formulas and financial functions