Your Business Quick Tip Newsletter

Vol 18 No #170 – 26th of September 2019

Gmail: Un-send an email
Excel / Google Sheets– Concatenate. The Follow on from Text to Columns.
Best Smartphone Tip Ever
Bespoke Webinars

Gmail: Un-send an email

Made a mistake? Had an oh no!!! Gmail gives you up to 30 seconds to catch that blooper.

Simply go to settings>select General. Scroll down four options to Undo Send and decide between a 5 and 30 second grace period.

P.S. you can do this in Outlook (it’s called Recall the message). The caveat is you have to be on a networked system an both using and Office 365 or Microsoft Exchange email account in the same organisation

Excel / Google Sheets– Concatenate. The Follow on from Text to Columns.

In our last issue (link is here) you learnt that Text to Columns will split information from one column into many. But what happens when you use it for names? On a large list you’ll have people with double last names. This is where Concatenate comes in handy. It’s the opposite action – putting multiple columns together into one

In Excel it is under the Functions Menu.
In Google Sheets it is Insert > Functions > Text > Concatenate

Best Smartphone Tip Ever

It is unbelievable how much that little device in your hand can do. I think we use only 1% of our smartphone functions and features.

This is something I do every time I get a new phone or every time the operating system updates. No matter if you have a new phone or one you’ve had for years – you’ll learn heaps:

Go to YouTube.
Type the name of your phone and 50 tips. Or the name of the updated operating system.
Select the most recent one with the most tips.
Watch with your phone in hand; stopping the video to try out the tips you like.

You’ll be amazed at how much you learn by seeing and implementing.

Bespoke Webinars

If you’re interested in training, but budget is a problem – travel, accommodation, time; then why not consider a private small group training webinar? While in-house and in-person training is always best, when resource dictates otherwise, a simple quick webinar with staff in the meeting room or on their individual computers would also work wonders.