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.


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…)

Full 3-way Financial Modelling using Dynamic Arrays

Best practice financial modelling in Excel has always been to enter your formulas in blocks. Enter a formula, then copy this across and possibly down also, making sure you have your absolute and relative references set correctly.

This is very useful because it is faster to build a model, easier to enter lots of formulas, less error-prone and easier to audit, all very desirable things when you’re constructing a financial model! Excel’s dynamic array functions take this concept to a whole new level because they automatically copy themselves. The dynamic array functionality has improved recently & now, with a bit of thought & planning, it can be applied to building a full financial model.


Virtual Debate: Fractional, Virtual or Outsourced CFOs

What’s the difference between a fractional, virtual or outsourced CFO? How much strategic planning, forecasting and financial modelling do they actually do, or are they just glorified bookkeepers over-charging at CFO rates? A good CFO will build forward-looking financial models to help businesses make better decisions but an external consultant marketing themselves as a fractional, virtual or outsourced CFO can simply manage day to day cashflow, month end and process payroll, receivables and payables, so misrepresenting and devaluing the role of the CFO. (more…)

Problem-solving with Financial Models 

Excel is a versatile piece of software and the techniques used to build financial models can also be applied to solve other problems using Excel. Many modellers compete in various competitions which explore the use of Excel for recreational problem solving where we can often develop or pick up new techniques and methods that prove useful in traditional modelling situations. (more…)

Jazz up your models with Excel formatting techniques

The best way to get people to pay attention to your models and reports is to present them professionally by changing the standard Microsoft settings and applying tasteful colours, borders and fonts. Formatting, however, is notoriously time consuming and it’s sometimes overlooked by the busy modeller. In this virtual meetup, we look at some quick and easy ways to use standard Excel for Microsoft 365 features to make your models look fabulous! (more…)

Should you use Macros in Financial Modelling?

Macros in Financial Modelling

Many aspiring modellers think that they need to be proficient in macro building in order to become serious financial modellers. Whilst it’s not a bad idea to have a working knowledge of macros—and the language they are built in, Visual Basic for Applications (VBA)—it’s certainly not critical for a financial modeller to become a super VBA programmer. As we know, the best sort of financial model uses the simplest tools and introducing macros to a financial model brings a whole new level of complexity.


Virtual Meetup I Are Excel’s Power Technologies suitable for Financial Modelling?

When people think about financial modelling or forecasting in Excel, what comes to mind is worksheets loaded with formulae, built in a report-focussed layout. Watch as Ken Puls showcases examples of using Excel’s Power Technologies to build Financial Models and Forecasts for clients. From data shaping with Power Query to DAX in Power Pivot, these tools play an essential role in modern financial modelling solutions.