Debbie Mayo Smith, International Motivational Speaker
Motivational Speakers, Sales, Marketing, Time Management, Productivity, Technology, Tips

Your Business Quick Tip Alert from Debbie Mayo-Smith

Vol 17 No#147  - 14th March 2018

1. Excel is Magic for Data Clean-Up

It doesn’t matter what database software you use to store your information as you can easily import it into Excel to manipulate, clean, de-duplicate and add to it. Then you can export it back in to your standard database.
Three outstanding quick functions include:

  • Text to columns - splits first and last names apart
  • Concatenate - will put last names back together (such as van Buren)
  • Proper - change each word to a capital instead of all lower or upper case.

2. Do You Have an Outlook Reply Signature Created

When you reply to an email, do you personally sign off every time with a salutation?
Or do you have your main (long) signature automatically attach? Why not create an automatic signature for your replies and forwards? I have a simple ‘thank you and best regards” along with my name and phone number. You’ll find Reply Signature setting in Outlook here: File>Options>Advanced>Mail>Signatures

reply signature

3. Free Up Time Using Gmail – Labels

Labels help you sort and categorise emails (like Outlook Folders), but they're hard to read. Solve this problem by color-coding some or all of your labels.
Simply mouse over to the left column and hover over a label you want to color-code. A small downward-pointing arrow appears. Click it to get the menu for label AND text colours. Simply clicking the colour will assign it.

4. Make More Sales by Treating Your Business Referrers Well

Do you have a distinct communication, thank you and reward plan for those business colleagues that refer business your way?
Here’s two easy ideas

  1. Create a recurring reminder/task to prompt you every few months to telephone for a hello and chat.
  2. Always ask a new client how they heard about you / what directed them to you. When it’s a referral – always, always pick up the phone to thank the referee.

5. Where's Debbie

Why not book a custom in-house workshop while I’m close to you? Simply email for a quick discussion




26 Apr



11 Apr

Insurance Advisernet


16 Apr

IBANZ Webinar, Smarter, Faster, Cheaper, Better


18 Apr



07 May

IBANZ Webinar, Google My Business


10 May

EMANZ Conference


17-20 May

Fiji Institute of Accountants 46th Annual Congress


11 Jun

IBANZ Webinar. Profit, Promotion, Productivity


15 Jun

SPANZ Conference


09 Jul

Social Media - The Good, Bad and Ugly


31 Jul -1 Aug

New Plymouth District Council

New Plymouth

 10 Aug

 Franchise Assoc Conference Tentitive


17 Aug

AAPNZ Conference


26 Aug- 16 Sept


Europe, USA

15-17 Oct

AA Practise Managers Conference


18 Oct

Meals On Wheels Conference

NSW, Australia

08 Nov


Webinar - Excel

19 Nov



20 Nov



Published by Debbie Mayo-Smith.
Read last months' Business Quick Tips
New? Subscribe Now
Join Debbie on Instagram | Website |LinkedIn | Speaking
Where's Debbie | Newsletter Sign-up
Debbie Mayo-Smith International Motivational Business Speaker and Author,
35 Chelmsford Ave, Glendowie, Auckland NZ. Phone +64 27 575 5359.
Copyright 2018 Mayo-Smth Limited. All rights reserved.

We are committed to protecting your privacy. We do not sell, trade, rent or otherwise disclose any personal information you provide to us.
To leave the newsletter mailing list, 
Click here


Free Quick Tips Newsletter
You'll love this succinct monthly tip newsletter focused on improving your business results and productivity.

View and sign up now!!!

Vinoté; James Wilson
"I really enjoy your newsletters. I generally read them more than once and always find at least one gem of great value. I recommend anyone who is getting in to e-marketing to first subscribe to your newsletters. Thanks for your help." Wes McMaster
"Your tips are valuable. I appreciate your advice and admire your passion. You are the only person I know that explains how to use Microsoft Office programs efficiently."

Stride Life Design; Stuart Flemming
"For eighteen months I've been receiving the Business Tip Newsletter. Each one helps me fine-tune my computer skills and gets me thinking 'how can I do this smarter?'. They're short, punchy and useful - one of the few publications I read in full before filing. Keep up the great work, Debbie!"