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