Yearly Archives: 2017

Creating excellent spreadsheets using the SAFER principles

The Safer Principles are summarised in the following chart. AS an accountant I also like to link this to key accounting principles (as described in the 2017 draft update of the IASB Conceptual Framework Update): For more detail see Using

Posted in Uncategorized

Weighted Average Using SumProduct()

A business will frequently want to know whether its Profits, Sales etc are growing or declining. This can be a difficult question to answer when results are variable and sometimes even a good chart doesn’t help.  Additionally,  it is useful

Posted in Uncategorized

Charts: Tips to Create Excellent Charts

A long standing saying is that pictures paint a thousand words.  A chart is one form of a picture and in Excel charts are one of the best tools for communicating information, particularly as a key component of a dashboard.   They can get

Posted in Uncategorized