Your Business Quick Tip Newsletter

Vol 18 No #168 – 27th of August 2019

Outlook Trick – Change Subject Lines
Smarter. Faster. Cheaper. Better.
How To Get Rid of Duplicates In Lists
20 Uses For Your Smartphone Camera

Outlook Trick – Change Subject Lines

Did you know that you can change the subject lines of emails you’ve received? Why would you want to do that? Well here’s three great reasons

To find that email more easily in the future
When sharing an email account, you can establish a code of who has looked after/completed inbox emails
To help categorise them

How-to
Depending on the version of Outlook you have you either

Simply open the email highlight the subject and start typing or
Open the email and ensure the little arrow on the right in the header area of the email is pointing up (which means it’s open)

Smarter. Faster. Cheaper. Better.

A mixture of wonderful tips and tricks on how to better use everyday business tools and cloud software to achieve freasy (free and easy) gains in business income, time management, communication and customer service.

The education, always entertaining and inspiring can be conducted via in-house customised training; webinars; national seminar series; conference presentations and customer appreciation events.

Email Debbie now to find out more

How To Get Rid of Duplicates In Lists

That database pain in your backside. Duplicates!!! Having the same person multiple times. You can remove the double-ups manually or you can be very clever!!!!

Removing Duplicates in Excel / Google Sheets

Excel: You have two options.

First simply click the Remove Duplicates icon in Excel. Didn’t know it existed, huh? Who would? It’s such a tiny icon (see the red arrow pointing to it in the image)? You’ll find it in the Data Ribbon>Data Tools Menu.

Second use the Exact Function in Excel. It compares if the informantion in one cell is the same as the infornation above/below it). It returns a “True” if it is the same.

Google Sheets: You’ll find Remove Duplicates in the Data Menu.

20 Uses For Your Smartphone Camera

Join in and email your ideas to me. I’d love to hear back from you:

Where you parked your car (my favourite)
Keep a record of important warranties and passwords (such as wifi, computer and software certificate of ownership)
Forgotten your reading glasses when you’re out to dinner? Take a photo of the menu and zoom in to make your choice. (no one even notices, it looks like you’re checking messages)
Capture conference, whiteboard or meeting notes
Before and after photos. Hair. Renovations. Autobody. Colours
Write a motivational note, snap it and use for your lock screen
Buying one screw? Take a pic of the bar code on the shelf to show the cashier
To remember details – specific items to buy, brand of cat food, your couch to match colours when out shopping
Video your home for content and dwelling insurance records
Your belongings in your suitcase before going off on a trip
When moving, take photos of the contents of boxes so you know what is in them
Photo the inside of your refrigerator and pantry before you go shopping
If you hand write your shopping list, take a photo in case it gets lost
Can’t find your glasses? Use your phone’s camera to help you see more clearly to find them
When you’re out shopping without the kids – send them the photo to see if they want it before you buy
Create a photobook of your work to give to prospects – for example hairstyles. Landscape designs. Automobile graphics
Take a photo of a recipe before going to the supermarket so you don’t miss any of the ingredients
Photograph a magazine article so you can finish reading it later
Travelling overseas and heading out for a big night on the town? Photograph your hotel and your hotel room door showing the room number! If you don’t speak the language, taxi drivers can look at the photo and get you home to the right hotel
When you loan something to a friend, take a photo of them with the loan item – so you can remember who you loaned it to & when