Formulas You'll Master
| Function | What it does | Example |
|---|---|---|
| SUM | Sum a range | =SUM(A1:A10) |
| AVERAGE | Mean of a range | =AVERAGE(B1:B12) |
| IF | Conditional logic | =IF(A1>0,"Profit","Loss") |
| SUMIF | Conditional sum | =SUMIF(A:A,"Q1",B:B) |
| COUNTIF | Conditional count | =COUNTIF(C:C,">0") |
| XLOOKUP | Modern lookup | =XLOOKUP(E2,A:A,B:B) |
| PMT | Loan EMI | =PMT(8.5%/12, 240, -2500000) |
| NPV | Net Present Value | =NPV(10%, CF1:CF5) − initial |
| IRR | Internal Rate of Return | =IRR(-initial, CF1:CF5) |
Build a 3-year revenue forecast
Create conditional-formatted P&L
Simulate scenarios with data tables
Format financial reports to a Big-4 standard
Design a KPI dashboard for a small business
Automate loan amortisation schedules