The Modeller's Miscellany is a weekly bulletin of cool stuff for financial modellers. Sign up below to receive it in your inbox every Sunday.
Excel // Office Scripts now available on desktop.
Office Scripts is an automation feature-set in Excel that allows users with all levels of programming experience to automate their repetitive workflows. Previously only available on the web version of Excel, Office Scripts are now available for anybody with a commercial or education license for Office 365. This has the potential to be a game-changer for anybody doing repetitive tasks in Excel. Read more.
Excel for Mac // Update to Power Query
Article // What does the future hold for financial modelling standards?
Book // The surprising history of money.
It's surprising how few of us really understand what money actually is. Recently I've become fascinated by the history of money; how different civilisations tried at different times to solve the money problem, and what the future of money might look like. Some curious money facts:
- The first paper money was created in China in the 11th Century.
- The Mongols were the first to remove the link between paper money and precious metal. Anyone who refused to use the paper money was tortured and beheaded.
- The Swedes were still only using coins in the 17th century, but they were made of copper and were more than half a metre long.
- In 1837 the U.S. was without a national paper currency. States started passing laws that allowed anybody who met certain requirements to start a bank and print their own money; leading to 8,237 different kinds of money.
Roundup // Modeller's Miscellany Top 10 from 2021.
The Modeller's Miscellany Jobs
And finally // Ready player zero.
Get the Miscellany delivered straight to your inbox every Sunday.
No spam. No silliness. Just modelling goodness.