SPECIALISTS IN FINANCIAL MODELLING

Five Rules for Building Impressive Excel Dashboards

Dashboard reports allow managers & executives to get a high-level overview of the business in one snapshot. When it comes to making dashboards, Excel is an excellent choice. You can create powerful, insightful and good looking dashboards using Excel, thanks to features like Pivot Tables, Formulas, Charts and simple UI (user interface).
Today, I want to share with you five rules that can make your Excel dashboards impressive.

(more…)

Which LOOKUP?

LOOKUP functions, especially VLOOKUPs are very commonly used in financial modelling – sometimes a little too commonly used!  Knowing when and how to use them – and use them well is a critical skill for any financial modeller.   Let’s explore some of the problems with LOOKUP functions and how to make their more robust.

(more…)

Happy New Year! Which version of Excel are you using?

Seeing as we’re now heading into 2011 I’m interested to know which version of Excel most users are on.  It’s been a while since any research was done on the topic, so I decided to set up a Linked In Poll to canvass our subscribers on the subject.  I think we’ll be surprised to see how many users are still on 2003!

Take the Poll

(more…)

What to look for in a Financial Modeller

When you decide your company’s financial models are not as good as they should be, is the first thing you do; send your staff on an Advanced Excel course?  Whilst this is helpful, there’s an awful lot more to Financial Modelling though than being good at Excel!

Do you need an Excel Jockey, a Finance Wizard, or a Financial Modeller?

(more…)

Six reasons your spreadsheet is NOT a financial model

I’ve often been asked the difference between a spreadsheet and a financial model, and there is a fine line of definition between the two. In a nutshell, an Excel spreadsheet is simply the medium that we can use to create a financial model. (Of course there are other programs besides Excel that can be used for modelling, but that’s another story!)

(more…)