Should we use Array Formulas in everyday models?

The array formula is probably one of the most powerful tools in Excel – but also the most under-used.  For some reason it is a tool that is shunned by many – even advanced users – of Excel.  But just because most people don’t know how to use them, does that mean they should be avoided in a financial model?


Online training targets tight budgets

Plum Solutions is very pleased to announce the release of their first online course!  With more bad news regarding the economy every day, we are responding to market demand with this low priced training option.  Introduction to Financial Modelling in Excel is now available for the introductory price of $99 plus GST.  This course is aimed at those new to financial modelling and with limited knowledge of Excel.  It is also ideal for those wanting to undertake the popular Financial Modelling intermediate course but lacking confidence in their financial or Excel experience.

The demand for the face-to-face workshops is restricted to a those participants who live near Sydney, Melbourne and Brisbane.  A lot of students travel interstate to attend a course to because it was not offered at a time or location which suits them.   ELearning is not for everyone, and some people still prefer the face-to-face method.  When participants are completing a course online, we give them as much opportunity as possible to interact with the presenter, but of course they don’t get the intensity and camaraderie that exists in a full day training workshop.

Many participants, however, find the cost savings and convenience of online delivery outweigh the disadvantages.  Being able to complete the course in their own time is invaluable, as many are not given time off work to undertake professional development courses.  With corporate budgets tightening, employees are also finding their companies reluctant to pay for their training.  With redundancies on the rise, many people are paying for their own training to improve their skills and marketability.  By offering the courses online, costs such as room hire, catering and printing of manuals are reduced and these savings can then be passed onto the participants.

By offering the courses online, Plum Solutions are expanding their product offerings as well as appealing to a new market.  Social Networks such as Linkedin and Twitter are an important part of promoting the online courses.  A “Financial Modelling in Excel” special interest group was recently set up on Linkedin and within ten days over 100 people from 28 different countries had joined the group.   Online courses open up a whole new international market as long as they are written in such a way that they are not specific to Australia and are reasonably easy to understand for those with English as a second language.

2008/2009 Excel Income tax calculator

How much will you save under the new 2008/2009 financial year
taxation changes? As of 1st July 2008, the tax brackets are changing,
which means we all pay less income tax! Download our handy new
Excel-based tax calculator and find out roughly how much you will save.


Avoiding Excel Errors in Financial Modelling

“Hmm, these numbers don’t add up…”

Sound familiar? We’ve probably all said this at one time or another, and it can be a frustrating experience.

In this article, we’ll explain the pitfalls of financial modelling in Excel, and give you a few survival tips to help you get accurate and reliable results from your models.

Microsoft Excel is a very flexible, powerful and ubiquitous tool for the purpose of financial analysis, however, astute users understand the dangers of a poorly built financial model.