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.
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:
Structured Reference Tables have been around for a while, but have become a lot more powerful in recent versions of Excel. They can be extremely useful when using Excel for the purpose of data analysis and modelling but I’m always surprised by the number of people coming along on my training courses who’ve never heard of them, let alone seen them used.
Many analysts and modellers would agree that public speaking is not their favourite part of the job and whilst it might be fun to imagine your senior management in their underwear, it’s probably more helpful to be prepared by following these basic tips.
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.
(more…)
So you think you can model, hey? Challenge your friends and colleagues to the very first Financial Modeling World Championships. Plum Solutions is very proud to support this inauguaral event.
Register here
Now that Excel 2013 preview is available, I thought it was time to do another poll to see what version of Excel business users are on now. It’s been around 18 months since the last poll on Excel Version Usage, and I was interested to see if there had been more of a shift towards the new versions of Excel.
