Actuarial pricing, capital modelling and reserving

Pricing Squad

Issue 9 -- December 2016

Welcome back to Pricing Squad!

Pricing Squad is a newsletter for fellow pricing practitioners and actuaries in general insurance.

Today's issue list seven Excel shortcuts which are worth learning if you do not know them already. Each of these shortcuts will save you 10 seconds every time you use it. Over time this will Alt = to a few extra days of your life.

Seven (+1) cool Excel shortcuts

Alt = or alternatively Alt +

Sum the column directly above this cell.

Ctrl [

Go to the cell underlying this formula.

F5 and then Enter

Go to back.

Ctrl '

Shows the content of all formulas this this sheet (as opposed to the results of these formulas).

Ctrl d

Copy and paste the cell directly above.

Ctrl r

Copy and paste the cell directly to the left.

Ctrl 5


Ctrl y

Repeat your last action.

Pricing Squad online

More good news for Pricing Squad subscribers. The back issues of Pricing Squad are now available online!

Go to, find the issue you want and provide your email address to read it.

Copyright © 2015 Jan Iwanik, All rights reserved. You are receiving this email because you are subscribed to updates from We publish data & analysis for informational and educational purposes only. You can unsubscribe from this list by emailing us.