Financial Modelling Articles
03 September, 2011
Should you use Macros in Financial Modelling?
To celebrate the launch of Chandoo’s next batch of VBA classes, I thought I’d take look at the use of macros in financial modelling.
24 August, 2011
Are you a Generalist or a Specialist Financial Modeller?
One of the fantastic things about financial modelling is that it is applicable across so many different industries. Good financial modelling skills will always stand you in good stead no matter which industry or country you are working in! A financial modelling consultant or generalist will prob
23 August, 2011
In-house Training versus Public Courses
Considering holding a course in-house? There are many advantages of arranging an
08 June, 2011
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.
07 May, 2011
How Long Does it Take to Build a Financial Model?
Whether you are a consultant building a model for a client, or an internal modeller, you or the person who has commissioned the model build will – understandably – want to know how long it will take. The answer is never straight-forward, as like many other tasks it really depends on how long you have got (and there’s never enough time!) and how much detail you need to go into.
04 May, 2011
Best Practice in Financial Modelling
Whilst not the most sexy topic for a blog article, this is probably the thing that I'm asked most about by clients. Because many modellers are self-taught, a lot of them don't necessarily adhere to best practice. Or perhaps they do - but don't realise why they are doing it! I thought it might be helpful to lay out my views on the topic, and as always, I'd welcome any reader input...
22 March, 2011
Excel Poll Results are in!
Thanks to all of the subscribers who contributed to our ‘Which Excel version are you using?’ poll – results are in, and we have some very interesting feedback!
27 January, 2011
Flood Relief Appeal: "Extreme Events Seminar"
Navigator and Allens Arthur Robinson are hosting fundraising events across three cities - London, Sydney and Perth - in aid of the Premier’s Disaster Relief Appeal to help those affected by the 2011 floods disaster.
10 January, 2011
Excel School - Second Intake
We got some really great feedback from those who attended Chandoo's online Excel course in September - registrations are opening again on 12th January if you missed out on the last round!
Those who've been following me for a while will know that I'm a big fan of using online resources as much as possible.
31 December, 2010
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!