SPECIALISTS IN FINANCIAL MODELLING

Using Excel on a Mac for Financial Modelling & Analysis

The usage of Excel on a Mac is increasing and according to an online poll we ran last month on Linked In, more people are using Excel on a Mac than are still using the old Excel 2003, a gap which is likely to widen. Windows Excel 2013 is being released soon and is already available for preview, although this is unlikely to have much effect on the Windows vs.
(more…)

Which Version of Excel are you Using? Poll Results 2012

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.

(more…)

Happy Leap Year with the EOMONTH Function

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…)

Should you use Macros in Financial Modelling?

Whilst it’s not necessary to become a super VBA programmer in order to be a good financial modeller, it’s not a bad idea to have a working knowledge of macros – and the language they are built in, Visual Basic for Applications (VBA).   The best sort of financial model uses the simplest tools, and introducing macros to a financial model brings a whole new level of complexity.  For example, users wanting to run your macro will need to their security settings in order to allow macros to run, and if you are u
(more…)