DebbieSpeaks
Newsletter Sign UpSpeaking Quote
  • Home
  • Motivational Speaker
    • Speaking Topics
    • Speaking Quote
    • Testimonials
    • Training
    • Calendar
  • Profile
    • Testimonials
  • Training
    • New Affordable Webinar & Video Training
      • Conquer Email Webinar – Save Hours of Your Time
      • Email Contacts Calendar & Tasks
      • Excel Fabulous Time Saving Tricks for Databases & Lists – Webinar
      • Google Business Webinar – Video Available
    • Add a workshop to your Conference
  • e-Store
    • Be More Memorable & Persuasive
    • Google Business
    • eBooks
      • Google Business
      • Conquer Your Email Overload
      • Make Your Database Your Goldmine
      • 101 Quick Tips: Effective Communication
      • 101 Quick Tips: Create A Great Customer Experience
      • 101 Quick Tips: Surviving The Kids
    • Webinars & Videos
    • Basket
  • New Webinars
  • Newsletter
    • Newsletter – Current
    • Newsletter – Prior
    • Newsletter Sign Up
  • Contact
Menu

Your Business Quick Tip Newsletter

Vol 18 No #168 – 27th of August 2019


Contents

  1. Outlook Trick – Change Subject Lines
  2. Smarter. Faster. Cheaper. Better.
  3. How To Get Rid of Duplicates In Lists
  4. 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:

  1. Where you parked your car (my favourite)
  2. Keep a record of important warranties and passwords (such as wifi, computer and software certificate of ownership)
  3. 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)
  4. Capture conference, whiteboard or meeting notes
  5. Before and after photos. Hair. Renovations. Autobody. Colours
  6. Write a motivational note, snap it and use for your lock screen
  7. Buying one screw? Take a pic of the bar code on the shelf to show the cashier
  8. To remember details – specific items to buy, brand of cat food, your couch to match colours when out shopping
  9. Video your home for content and dwelling insurance records
  10. Your belongings in your suitcase before going off on a trip
  11. When moving, take photos of the contents of boxes so you know what is in them
  12. Photo the inside of your refrigerator and pantry before you go shopping
  13. If you hand write your shopping list, take a photo in case it gets lost
  14. Can’t find your glasses? Use your phone’s camera to help you see more clearly to find them
  15. When you’re out shopping without the kids – send them the photo to see if they want it before you buy
  16. Create a photobook of your work to give to prospects – for example hairstyles. Landscape designs. Automobile graphics
  17. Take a photo of a recipe before going to the supermarket so you don’t miss any of the ingredients
  18. Photograph a magazine article so you can finish reading it later
  19. 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
  20. 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

Sign up here for the Newsletter

Debbie Mayo-Smith | Mobile +64 27 575-5359 | Auckland New Zealand

Copyright © 2021 - All Rights Reserved.

Site Map Your Privacy Contact Us
Quick Tips Newsletter

Don’t miss learning wonderful time saving,business building tips, apps and shortcuts!