Excel is the backbone to any custom built financial model, and one of the core attributes of a financial modeller is to have good technical Excel skills.  When struggling with their financial models, some managers’ first reaction is to send their staff on an advanced Excel course to improve their modelling skills.  However, with training budgets under constant scrutiny you really need to make sure that you get the best value out of your training options.

Is a training course what you need?

When considering an Advanced Excel course, there are a few points you should consider:

  1. As financial modellers, our use of Excel is quite narrow.  I know it’s hard for us to conceive, but there is a whole world of Excel use outside the finance industry!  Statisticians, database programmers, and engineers to name a few are able to use Excel’s advanced functions to create non-financial spreadsheets.  Most Advanced Excel courses are very broad, and will cover functions and capabilities which do not apply to your needs as a financial modeller.  You may learn a few tricks, but the time and money spent could be invested elsewhere.
  2. Research show that a large percentage of the skills learned in training courses are not retained.  Will you really remember everything that you learned?  A programme of continuous, applied learning is often more effective than an intensive training course.
  3. Are your Excel skills really the problem?  Following best practice and mastering the logic behind a financial model is more important than building in complex formulas, and for the most part you will want to keep formulas as simple as possible.

Alternatives to attending a public ‘Advanced Excel Course’

Other options to improve your financial modelling skills without going on an Advanced Excel Course include:

  1. Take an interest in what your work colleagues have done and how they did it – you can always learn from the techniques of others.
  2.  Read other peoples’ models!  Writers read books, actors watch movies to learn techniques.  Sometimes the best way to learn is to see what someone else has done.  Try taking someone else’s model apart and see how they built it.
  3. Read specialist financial modelling publications – there are often useful articles about specific techniques or subscribe to online “Excel Tips” email newsletters

Select the right training option for you

These strategies are great for continually improving your Excel and financial modelling skill set, and they certainly won’t break the budget, but what if you really need to give your skills a quick boost to get you ready for that new project coming up?  There are a number of options available:

  1. Try to find a course specifically aimed at Excel for financial modellers, and even better – find one dedicated to your industry.  Although good financial modelling skills are relevant across many different industries, there is nothing like specialised training dedicated to the modelling issues inherent in your own industry.  In recent years many more specialist financial modelling courses have become available, and most major cities have public courses available.
  2. If your company is able to arrange a group in-house training course, this will be even better as you may be able to use the templates and models actually used within your organisation.  You also have the added advantage of choosing a time and location that suits you.
  3. If you can afford a private session, this is the most convenient and time-efficient method as you can ask questions and only cover topics that are useful to you.  Many specialist training companies provide Excel one-on-one mentoring sessions.
  4. In addition, there are some fantastic publicly online resources including tutorials, articles, blogs, forums and videos specialising in Excel and Financial Modelling which can be done in your own time rather than taking an entire day or two out to attend a course.

So, do you really need an ‘Advanced Excel Course’?

In summary, an advanced Excel course would certainly benefit someone who plans on extensively using Excel in their role for multiple purposes.   However, if your main objective is to become an expert financial modeller, focus instead on mastering the few tools you need such as logic and methodology, rather than expending time and money to learn tools you won’t use.