The Modeller’s Miscellany #99
“The most contrarian thing of all is not to oppose the crowd but to think for yourself.”
– Peter Thiel
A round-up of guidance on the Advanced Formula Editor
The new Excel Advanced Formula Editor is a big step forward. Not only does it make it easier to create Lambdas, it also makes them shareable via Github. Paul Barnhurst has written a useful article on his Excel reviews site bringing together the best guidance currently available on the new formula editor add-in. Read more.
The ultimate keyboard shortcut collection
Workflow efficiency on any app requires a grasp of the important keyboard shortcuts. Key Combiner is a web application that lets you organise, learn, and practice the keyboard shortcuts you use most often, as well as being able to browse public libraries for dozens of apps. It also helps you learn and memorise keystrokes to help you build muscle memory. Find out more.
A Github repository of laws and principles
Dave Kerr has created a Github repository of frequently cited law and principles. It’s just brilliant. A few of my favourites:
Hofstadter’s Law: It always takes longer than you expect, even when you take into account Hofstadter’s Law.
Hanlon’s Razor: Never attribute to malice that which is adequately explained by stupidity.
Kernighan’s Law: Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
Project Finance Careers Hub launch
Paul Graham is the co-founder of tech incubator YCombinator. His essays are gems of clear thinking and insight. Posted for free on his charmingly old website. They are all worth reading. Some favourites: Write simply, A project of one’s own and How to think for yourself.
Consensus and how experiments and societies end
“Consensus, or the ability of different people to agree to the same set of facts and conclusions, is the key property of any functioning social system. When it works, decisions are rapidly made, morale is high, direction is clear and social organizations can be quite resilient and effective. A lack of consensus leads to stasis and sclerosis, of trying to “build” consensus rather than doing the actual work of execution.” Read more.
Modeller’s Miscellany Jobs
Financial Modelling Associate, MW Advisory Consulting – Birmingham, UK
Strategy Associate – Standard Chartered Bank – Singapore
Infra, Renewables and Energy Associate – Taurus Search – New York, United States
Financial Modelling Executive – EY – Edinburgh, Scotland
Finance Analyst (Entry-level) – Vodafone – Milan, Italy
Associate, Strategy Consulting – Singular Group – Munich, Germany
Financial Modelling and Investment Memo Writer – EMV Capital Ltd – London, UK