If you're preparing for actuarial exams like CM1 or CM2 Paper B, your Excel skills can make or break your performance. Excel isn't just a tool — it's a weapon when used right.
Master these 7 essential Excel functions to speed up calculations, minimize errors, and boost your Paper B scores.
1. NPV() – Net Present Value
Quickly calculate the present value of a series of cash flows.
Use it when you need to discount multiple future payments at a constant interest rate.
2. XIRR() – Extended Internal Rate of Return
Ideal for cash flows that are irregularly spaced.
Unlike IRR(), XIRR() accounts for exact dates, making it crucial for real-world financial modeling.
3. IF() – Basic Conditional Logic
The backbone of decision-making formulas.
Whether it’s to automate grading systems or handle different scenarios, IF() is a must-know.
4. VLOOKUP() / XLOOKUP() – Data Lookup Champions
Efficiently retrieve information from large tables.
XLOOKUP() is newer and more powerful, but VLOOKUP() is still widely used and often tested.
5. INDEX() + MATCH() – Dynamic Data Retrieval
Take your lookups to the next level by combining these two functions.
More flexible than VLOOKUP(), especially when columns move or datasets grow.
6. ROUND() – Clean, Professional Results
Never leave messy decimals!
Use ROUND() to control the number of decimal places and present clean, professional work.
7. ABS() – Absolute Value Made Easy
Simplifies modulus operations by returning the positive value of any number.
Vital for actuarial models involving deviations, losses, or absolute changes.
Pro Tip:
Master Excel keyboard shortcuts — it could save you 10–15 minutes during Paper B, which is often the difference between passing and failing.