9 April 2019

Read More

Exception Reporting

by Datasift
Exception reporting. What is it? How can it be used to maintain your business' health?
Imagine you are a wholesaler selling a range of cosmetics nationally. You have a Sales Manager in each state and a team of sales people reporting to them.
Using intelligence report...

26 March 2019

Read More

Introduction to naming ranges in Excel.

by Datasift
"Do what?", I hear you ask. Well, how many times have you had to jump around Excel trying to find out what an Excel formula is actually doing? Lets look at a simple example. =SUM($C$4:$C$9) this is adding up a range of cells. However, it does not tell you what the cells contain -...

9 March 2019

Read More

Calculate working days in Excel

by Datasift
Often in Excel models we need to calculate the number of working days between two dates. For example we have a sales figure generated between two dates and we want to calculate the sales per day so that we can test our forecast for reasonableness. For this we can use the function N...

4 January 2019

Read More

Money. Money. Money.

by Datasift
Cash. A small word that is massive to a business. If your cashflow is bad, it can drag the whole business down faster than most other things.   Consider doing some practical things to help your cashflow get better. Formulate a credit policy. Communicate it to your customers, ...

31 October 2018

Read More

Beware of scammers impersonating ATO

by Colin
Tax. No, its never popular but even less popular are scammers who use the taxman's name. The ATO has noticed an alarming new trend in scam activity involving scammers impersonating TAX and BAS agents. This new scam is effective because clientsare trusting of their representatives, so y...