Are actuaries and other “power users” of Excel using their ingenuity to solve solutions with a relatively limited set of functions… or are they ignorant of other functions that may be better suited to the particular use case?
The Problematic Convenience of Spreadsheets
Spreadsheets are a much-loved tool within the actuarial community. A recent survey conducted by the Institute and Faculty of Actuaries found that 98% of respondents use Microsoft Excel to perform various day-to-day tasks. But how useful are they?