• We are pleased to announce that the winner of our Feedback Prize Draw for the Winter 2024-25 session and winning £150 of gift vouchers is Zhao Liang Tay. Congratulations to Zhao Liang. If you fancy winning £150 worth of gift vouchers (from a major UK store) for the Summer 2025 exam sitting for just a few minutes of your time throughout the session, please see our website at https://www.acted.co.uk/further-info.html?pat=feedback#feedback-prize for more information on how you can make sure your name is included in the draw at the end of the session.
  • Please be advised that the SP1, SP5 and SP7 X1 deadline is the 14th July and not the 17th June as first stated. Please accept out apologies for any confusion caused.

Excel proficiency level as an Analyst ?

B

bpatel28

Member
Hi,

I will be starting as an Actuarial Analyst at Barnett Waddingham, I would like to say my excel skills are intermediate in the sense that I can confidently use V-lookups, Pivot Tables, Sort, Conditional Formatting, use of logical functions (IF, SUM IF, COUNTIF), aswell using Financial Formulas (NPV, IRR), and statistcal based ones.

Apart from what I've mentioned above, is there anything a trainee actuary / actuarial analyst would use on a regular basis which I haven't mentioned
 
HLookups, Match, Indirect, Named ranges are some additional ones....

but to be honest i would not worry at all about this because you will learn very quickly on the job as you will almost certainly spend most of your time using Excel!

And you know more than what i knew when i first started work. (I only knew how to draw some basic graphs which was needed for a GCSE project that i had done 5 years prior to starting my job!)
 
A knowledge of VBA can be helpful;. But as stated above, you have a really good base to start off from. They have found you worthy of a job offer, so relax. Firms like these have excellent development programs and I'm sure others in the office will be able to offer some on the job support. Don't be afraid to ask! Enjoy your new role.
 
And by the way, offices tend to have house styles and you will quickly pick these up too.
 
Thanks for the replies guys. Also I will be working in trustee consulting, so would you recommend any particular readings i should subscribe to ? that will be keep me updated about pension industry..
 
You must log in or register to reply here.
Back
Top