You already know how cool the F11 quick chart is right? In this 2 minute tutorial we show how to make it even more useful by quickly and easily adding additional line items to the chart. It’s actually really cool (in a geeky modelling way of course!)
Welcome to the Course In today’s tutorial we set the scene for the rest of the course by outlining our assumptions. We just want you to be sure that this course is for you before you spend any time on it. Enjoy today’s lesson!
When building a financial model, it’s tempting to start with the inputs and work forward from there. Today we’ll discuss why that’s the wrong place to start.
Today is giveaway day. Our book of format macros will make applying consistent, meaningful formatting to your models quicker and easier.
It’s homework day. We’re going to be looking at what makes a model difficult to read and what can we do to make it easier.
Today, Yatin, one of our modelling team, tries the assignment. It takes him around 10 minutes to unpack that one formula and understand what’s going on.
It’s time for something different. Today we have an interview with Ray Panko – a specialist in the study of “human error”. Please note that today’s material is audio only.
Over the last few days we’ve understood more about the source of errors in models. Now we show you how to approach modelling differently to increase transparency and reduce errors. You’ll also learn a new technical term – “financial model rage”.
Calculation blocks don’t just make models easier to read – they also makes it easier for us to find our way around a model.
Today we’re going to ask the question – is it OK to link to an existing link? Or should we always link back to the source ingredient. It’s a critical distinction.
Yesterday we learned to avoid daisy chains in our models. Today we’ll look at how to do that easily.
Remember that awful calculation we made you look at for your home assignment a few days ago? Today we look at it again – this time in a FAST layout to see if it’s easier to read.