Your Business Quick Tip Alert from Debbie Mayo-Smith
Vol 16 No#137 20 July 2017
1. Correcting Database Mixed Upper/Lower & Webinar
Collect data online? You’ll know the pain of people responding in both upper and lower case. Solve this problem in Excel with the function Proper. This will capitalise the first letter of each ‘word’.
This tip along with many others was covered in my Affordable Training Webinar Excel – Fabulous Time Saving Tips Managing Lists & Databases.
or in the 16 week Quick Tips Excel Boot Camp
2. Productivity Tip – David Allen’s Two Minute Rule
Why not try David Allen’s simple two minute rule? When a new task comes up and it’s something that can be done in less than two minutes, do it right away. This simple rule can greatly increase your productivity as it keeps little things off your to-do list (and doesnt take much time to complete the task).
3. Return To Webpages Quickly
If you go back to a website/page often, why not bookmark it? The quick way is grab the url and drag it down to your book mark tab. Release. You can rename it or leave the icon.
4. Outlook Tip – Manage your inbox size.
Search folders (virtual folders for re-arranging or finding certain emails) live under your Outbox. One of the preset folders built in is Large Mail (under the Organise Category). Once clicked it will show you all your emails from every folder (including deleted and sent) separated into size categories. The largest is Enormous and holds files over 5 megabytes. You can delete emails here (delete twice as the email first goes into deleted items, then you need to permanently delete it). What a swift way to downsize and release mailbox space.
5. Gmail Tip – Colour Your Labels
You probably are using Labels in Gmail – which act as folders. You can create one by clicking the email you’re in and selecting the Label Tab on the menu. You might not know that you can color the labels – which flows through to the emails themselves. Simply click the little square box at the end of the label in the Inbox navigation pane on the left. A list of colours will appear that you can select from
4 Top Tips for Taking Great Smartphone Travel Photos
|Read last months’ Business Quick Tips |
Thank you to everyone that referred this newsletter to colleagues. It’s warmly appreciated.
New? Subscribe Now.
Please email Debbie to change your address at email@example.com
No more? Click here if you do not wish to continue your subscription
Join Debbie on Instagram
Published by SuccessIS. Debbie Mayo-Smith International Motivational Business Speaker and Author,
35 Chelmsford Ave, Glendowie, Auckland NZ. Phone 64 9 575 5359. Copyright 2016 SuccesslS.
| All rights reserved. SuccessIS is committed to protecting your privacy. |
We do not sell, trade, rent or otherwise disclose any personal information you provide to us.