SPECIALISTS IN FINANCIAL MODELLING

Part 1: Modelling Timelines with Dynamic Array Functions in Excel

“Welcome to a new 5-part video series on the “Must-have Excel Functions for Financial Modelling”.
 
Most financial models have some kind of time element and usually they’re looking out into the future. And being able to do this quickly is going to save you a huge amount of time, particularly if you are competing in the Financial Modelling World Cup where time is of the essence, or if you are sitting, one of the Financial Modelling qualification exams from the Financial Modelling Institute. Watch as Microsoft MVP, Danielle Stein Fairhurst demonstrates how to use Dynamic Arrays and Date functions in Excel to create a flexible and dynamic timeline that can be used for building virtually any financial model from scratch..

(more…)

Excel Esports Battles | The Road to Las Vegas

When I meet someone socially and they are foolish enough to ask me about my work, I might talk for a little bit about financial modelling and usually they’ve never heard of it, so their eyes glaze over and they start looking at their watch. Hastily, I ask if they’ve ever used Excel and they start scanning the room for someone else to talk to. I have discovered that talking about competing and commentating in the Financial Modeling World Cup and Microsoft Excel Esport battles is more relatable and yes they still think I’m slightly odd, but they do remember me!

(more…)

LinkedIn Learning| Financial Functions in Depth

My very first course “Financial Functions in Depth” has just been released and I couldn’t be more excited about it. I had so much fun recording with the fantastic team at LinkedIn and I can’t wait to share it with you. There are so many functions now available in Excel and in this course, we cover the tools specific to Finance such as evaluating loans, payments, and interest; calculating depreciation; determining rates of return; calculating prices and yields as well as applying some of the new features of Excel for Microsoft 365 to financial data. (more…)

Developing Models to Prevent User Error

If you’ve had any experience building financial models for others to use, you’re probably familiar with the ways users can use and misuse your model. In fact, one of the key sources of financial model error occurs when a model is not used for its intended purpose or users enter invalid inputs which cause incorrect calculations and inadvertent output error. (more…)

Excel Model Review Tools you need to know

It is well-documented that up to 90% of spreadsheets contain errors and although any individual mistake may be small, they can quickly add up. Checking for errors is an important part of the financial model build and there are many native Excel tools that can be used for this purpose. (more…)

Excel for Microsoft 365 Game Changers

Excel today is not the Excel of yesterday. Dynamic Array Functions and Custom Data Types are just two of the relatively new must-know game-changing features. In this session, Microsoft trainer Mike Thomas gives us a tour of the most useful techniques, incorporating practical use cases that can help take your productivity in Excel to the next level.

(more…)

Panel Discussion: Women in Financial Modelling

At the recent Financial Modelling Summit, Danielle Stein Fairhurst hosted a panel discussion on the important topic of “Women in Financial Modelling” with ModelOff Champion Hilary Smart, top ranking FMWC competitor Stephanie Annerose and Partner at Mazars Rickard Warnelid. Not only are the financial modelling and Excel competitions still lacking in female competitors and champions, but there’s a shortage of female senior leaders in many companies, particular in the modelling space. (more…)

Financial Modelling Awards

We are pleased to announce that Danielle Stein Fairhurst has been awarded the 2022 Lifetime Achievement Award at the recent Financial Modelling Summit. The awards are held annually with the purpose of celebrating the financial modelling profession. The Lifetime Achievement Award is designed to recognise the recipient as one who has consistently served to move the profession forward whilst raising the profile of financial modelling.