View profile

Spreadsheet Deep Dive - MMM #19

Thomas Konings
Thomas Konings
Hi there,
Still extremely busy with exam season. By the time you read this I’ll be getting ready to set the Analysis of Strategy A exam and I’ve got an Accounting exam tomorrow. Last week I focused on finance, also my exam last Friday, and started keeping an eye on the /r/financialmodelling subreddit. I’m excited to share some of my finds with you.
📃 In today’s mashup:
  • ⭐Highlight: Excel shortcuts on steroids
  • 🎓Skills: Spreadsheet Competency Framework
  • 💽Data: Normal Distributions Everywhere (literally)
  • ⏭️Next
Have a great week!

⭐Highlight: Excel shortcuts on steroids
I came across this really cool macro pack or productivity add-in for Excel that’s provided by Gridlines as part of their free course: Essential Financial Modelling. It’s no secret that I’m a big Excel fan and I really like my shortcuts (to the point that I modified my keyboard to record macros on the fly).
Anyway, if you want to get better at financial modelling, and want to build models super quickly, check out the free course below.
Essential Financial Modelling | Gridlines Training Academy
🎓Skills: Spreadsheet Competency Framework
We all claim to have “Excellent Microsoft Office skills” on our CVs but how can we quantify that? This week I came across the Spreadsheet Competency Framework by ICAEW (the Institute of Chartered Accountants in England and Wales) which categorizes spreadsheet users into different competency levels.
This is particularly useful when conducting job interviews, however you can also assess yourself against it and see what the steps are to reach the next level. It’s a really comprehensive document so a good one to save for future use.
💽Data: Normal Distributions Everywhere
An interesting Reddit post showing the distribution of elevation on our planet. You can clearly see two normal distributions, one for the oceans and one for the continents.
Distribution of elevation and depth across the world [OC] : dataisbeautiful
Today was hopefully the last of the shorter newsletters, as I’d also like to get back to writing my own blog posts again. With exam season nearing its end there should be more time available for these side-projects.
Have a great week!
Did you enjoy this issue? Yes No
Thomas Konings
Thomas Konings @tkon99

Every Monday morning I will send you an email with things I discovered during the week that I found helpful. Ranging from interesting theories to practical Excel tips and insightful articles I read, this newsletter will make your Monday a little bit better for sure!

In order to unsubscribe, click here.
If you were forwarded this newsletter and you like it, you can subscribe here.
Created with Revue by Twitter.
50 Crispin St., E1 6HQ, London, United Kingdom