The Modeller's Miscellany - #64

Office scripts now available on desktop.

· Modellers Miscellany

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

This week's Miscellany is heavy on the Excel updates. The Mac version of Power Query has had a significant upgrade with the ability to import data from local files. Read more.

Article // What does the future hold for financial modelling standards?

Last week we talked about financial modelling standards, what they are, and why they matter. If you missed it you can read it here.

In part two of our three-part series, we continue speaking to modelling standards experts Richard Wärnerlid, Andrew Berkley and David Lyford-Smith, who joined us for a live webinar about standards back in January. Read more.

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. 

Check out Money: The True Story of a Made up Thing by Jacob Goldstein (who also reports for the excellent Planet Money podcast).

Roundup // Modeller's Miscellany Top 10 from 2021. 

Let's take a look back at ten of the most read article from the last six months of the Modeller's Miscellany, featuring gaming, covid, Meatloaf, and of course Excel. Read more.

The Modeller's Miscellany Jobs

Senior Commercial Analyst (Corporate Development) – Woodside Energy – Perth, Australia

Senior Commercial Analyst (Corporate Commercial) – Woodside Energy – Perth, Australia

Virtual Financial Planning & Analysis Intern (Fall 2021) - Warner Bros - Burbank, CA

Financial Analyst - Inmar Intelligence - Winston-Salem, NC

Investment / Financial Analyst - PowerTree - London, UK

And finally // Ready player zero.

As a demonstration of the new Office Scripts feature, Microsoft created this Game of Life simulator


Get the Miscellany delivered straight to your inbox every Sunday.

No spam. No silliness. Just modelling goodness.

All Posts

Almost done…

We just sent you an email. Please click the link in the email to confirm your subscription!