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...

1 September 2018

Read More

How to set the Sum function as the default in a PivotTable

by Colin
Let's address a very important issue faced by many people that use Microsoft® Excel®. Sometimes when working with PivotTables, the Count function is set as the default instead of the Sum function. This can be frustrating as you then have to set each column value to Sum. Here's ...

25 June 2018

Read More

How to use Flash fill in Excel to change text

You know the drill. Someone has typed lots of data but not kept to the input rules and you need to fix up some stuff. Just look at what they have done everything in lower case AND you only needed the first three letters of the month!          ...