SPECIALISTS IN FINANCIAL MODELLING

Webinar: Data Visualisation And Presentation For Financial Analysts

Danielle Stein Fairhurst recently ran a new webinar which was streamed live from Dubai for Informa Middle East.  The recording is now available. As a diligent analyst once you’ve completed your analysis of your business or financial information, presenting the output...

Understanding Incremental Cash Flows and Sunk Costs

We recently held a Meetup for the Brisbane Modellers’ Meetup group and I’m pleased to say that the video is now available below.  The speaker  Eris O’Brien is a highly experienced modeller and at this informative presentation he took a look at the...

Webinar: Scenario Tools in Excel

The recording & transcript of our first Plum Webinar is now available!  This hour-long webinar was free to attend and during Part One of this webinar, online trainer, Danielle Stein Fairhurst led us on a short technical demonstration of how to create scenarios...

Skills Needed for Financial Modelling

When you decide your financial models are not as good as they should be, should you immediately send your team on an advanced Excel training course? Whilst this is certainly helpful, there’s a great deal more to financial modelling than being good at Excel! When...

Which version of Excel am I using?

No, it’s not a silly question and since the “Modern Excel” was introduced in 2010, the changes have been pretty subtle and it can be a little difficult to tell the difference. Open up your version of Excel.  If it looks like the image below, then...

The Golden Rules for Model Design

There are a few rules for model design that should be followed when designing the layout of a model. Most experienced modellers will follow these instinctively, as they are generally common sense. Extract from Using Excel for Business Analysis, Chapter Two Separate...

The Workbook Anatomy of a Model

Model design and structure can be one of the most difficult parts of building a financial model.  Typically, modellers will work from back to front when building their model. The output, or the part they want the viewer or user to see, will be at the front,...

What’s the difference between a Formula and a Function in Excel?

Ever been guilty of using Excel as a fancy calculator?  If so, you’d just be using a formula in Excel.  If you entered a calculation such as =A1+A2 or =452*12, then that’s just a formula.  If a formula is all you need, then that’s fine.  But Excel can do...