Beware of scammers impersonating ATO

By Colin Spooner / October 13, 2018

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 you need to take care. In a twist on the ‘fake […]

Read More

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

By Colin Spooner / September 1, 2018

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 how to solve this issue. The problem […]

Read More

NAB Superpay Closing

By Colin Spooner / July 20, 2018

Are you using NAB SuperPay to process your superannuation in the SuperStream format? If so, we’d like to inform you that NAB will be decommissioning NAB SuperPay from 30 July 2018, and therefore from this date, you will have read-only access to this service. To remain compliant with the ATO, you can move to another clearing house […]

Read More

How to use Flash fill in Excel to change text

By Colin Spooner / June 25, 2018

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! Flash fill to the rescue! Just give it an […]

Read More
Scroll to Top
Call Now Button