Excel Musings
RICI: Excel Musings – Sorting and Randomising
Welcome to another edition of R1C1 – Excel Musings. In this edition I want to share some thoughts on sorting lists of data, and its opposite, randomising the order of…
Excel Musings
Highlights
Excel Musings
R1C1 Excel Musings – Defined Names
Welcome to another edition of R1C1 – Excel Musings! The previous edition on array formulas was well received judging by the responses I received to the included Excel challenge. I hope…
Excel Musings
R1C1: Excel Musings – Array Formulae
Formulae lie at the heart of what makes Excel such a powerful calculation tool and although standard Excel formulae can solve most problems, situations still arise when we need extra intermediate…
Excel Musings
R1C1: Excel Musings – Monte Carlo Simulation Without VBA
THIS ARTICLE IS THE FIRST IN A SERIES – PART OF A NEW REGULAR COLUMN, FEATURING THE MUSINGS OF DAN MAYOH… As professionals in the actuarial field many of us use…
