Making your financial model look professional Back in school, teachers always gave a few extra marks to the students who set out their workings in...
Sparklines in Excel are great little visual representations of your data. They make it easier for users to gain insight into a whole block of...
The SUMIF function allows you to sum values in a given range, provided the corresponding cells in another range satisfy a chosen criterion. The SUMIFS...
The DATEDIF function is one of several hidden Excel legacy functions. We say hidden, it’s because Excel does not suggest any of these as part...
Microsoft Excel shortcuts are one of the best ways to increase your efficiency when modelling. Some modellers even place their mouse out of reach to...
Recently, we wrote a blog about staff modelling as an example of modelling that doesn’t rely on integrated financial statements or accounting knowledge. In our...
Simplifying a model is one of our favourite projects. There’s nothing more satisfying than taking a working model, which, for whatever reason, has become too...
If you build or work with financial models, your work will undoubtedly be reviewed sooner or later. In this blog, we will outline the various...
I’m sure at some point we’ve all had someone tell us: “don’t go outside with wet hair, you’ll get a cold!” or had the importance...
Inflation is very important in financial modelling. It’s an area that creeps into many models, whether they are integrated financial statements, or component/sub models. It’s...
A lot of modellers start out their career with hopes of building huge, industry-shaking models, only to have their dreams dashed early on. Assigned to...
Financial modelling has a myriad of uses, and yet more often than not, it’s come to be pigeon-holed as the modelling of integrated financial statements...
The NPV or Net Present Value of cashflows is a key metric in investment appraisal. It lets us look at the cashflows of a given...
We’ve all been there. A formula changes somewhere along a row or column and isn’t marked in any way to make you aware of it....
There are many routes into a financial modelling career, and they are evolving and changing every day. With each option having unique benefits and career...
Use these tips to save time and reduce the risk of error in your Excel formula. Long formulae are difficult to understand five minutes after...
Building a financial model can be a long and complex process. In a world where accuracy is key, ensuring that your model is fit for...
Nothing will beat structured, practical training when it comes to giving you the tools and skills required to become a quality financial modeller, but there...
For years, Microsoft Excel has been the go-to software for financial modellers, and despite many attempts to knock it from its pedestal, it’s not going...