Here are the top excel formulas that will help you productively use the office application (i) SUM (ii) AVERAGE (iii) XLOOKUP (iv) VLOOKUP (v) HLOOKUP (vi) COUNT (vii) CONCATENATE (viii) SUBTOTAL (ix) MODULUS (x) LEN (xi) REPLACE (xii) POWER (xiii) CEILING (xiv) FLOOR

Here are the top excel financial formulas that will help you productively use the office application (i) XNPV (ii) XIRR (iii) MIRR (iv) PMT (v) EFFECT (vi) IPMT (vii) DB (viii) RATE