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, calculations will go in the middle, and source data and assumptions should go at the back. The image below shows an example of what your tabs in a well-structured model might look like.


Excel Top 10 Tricks

I’ve been showing this video supplied by Microsoft in my training recently, and lot of people have asked me for a copy, so here it is! Some of my favourite new features in Excel 2016 are:


Using Excel in the Age of Big Data

We are constantly being told that we are living in the Information Age.  The Industrial Revolution marked the beginning of the Industrial Age and similarly, the Digital Revolution started the Information Age.