Posts
Beware of scammers impersonating ATO
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
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 MoreNAB Superpay Closing
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
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- « Previous
- 1
- 2
- 3