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

7 July 2015

Your Business Quick Tip Alert
Vol 14 No#107


1. Smartphone Apps: share the learning
2. OneDrive Your Freasy Office 2013
3. 12 Week Email Productivity At Your Desk
4. Shortcuts to zip around Microsoft Office

Smartphone Apps: Join in, share the learning

Several years ago I ran a 'share your favourite app' survey. Hundreds of people answered and we all joined in learning many new ways of using our phones.

It's time to repeat it. However I'll be smarter this time and ask for your response in a wee, quick survey (thus saving me hours of manual work sorting, removing duplicates, tallying from all those emailed responses).

Please, share your top three apps and don't miss the learning experience. I'll send you a beautiful outline of the apps and explanation. http://1drv.ms/1GYoe0F

OneDrive Your free Office 2013

The app survey is also an illustration of what you can do with the FREASY Cloud software that is available to everyone.

I made the smartphone survey using a complimentary subscription to Microsoft OneDrive. It is MS Office 2013 in the Cloud - Word, Excel, PowerPoint, OneNote, Surveys, plain text documents (as well as Outlook, Calendar and Contacts).

The survey function of Excel (see image here) gives you the ability to create a form and send a link to people for them to fill out. The magic is all the reponses populate an online Excel spreadsheet.

How can you use this?

An idea I introduced last year while doing a National Database Marketing Roadshow for LJ Hooker was to use Onedrive to create open home registration forms.

You create the form online (it's sooooo easy). It will generate a sharable link (like for my smartphone app survey), that can be sent to people interested in attending the open house. Likewise the survey itself can be open on a laptop or ipad at the open home for people to fill in, instead of typing in on a sheet of paper.

What you have here is a (begnining or addition to a) database. Elimination of hand typing in the information collected from the hand written open home forms. Better veracity of information from less typos. It's easy. It has no cost. It's available to anyone.

If you have Office 2013 on your laptop, you have a subscription available with one terabyte of online storage. Alternatively your OneDrive account has seven gigs without cost.

MS Office Shortcuts You'll Love

  • Control+F6 toggles between multiple Word or Excel files when you have more than one open, or between worksheets when you have more than one Excel file open.
  • F7 opens the Spell Check dialog box in Excel, Word, and Outlook.
  • Shift-F3 Change Case toggles the case of the selected text in Word and Outlook, rotating from sentence case to uppercase to lowercase and so on. Just highlight the text you want to format and continue to press Shift-F3 until the case you want appears.
  • F4  Repeat last action you performed in Word. For example, create a text box, insert a graphic, or draw a line, then press F4 and the action is duplicated.
  • Shift-F7 Opens the Thesaurus dialog and gives suggested synonyms for the selected word.
  • F11 in Excel creates a chart of the data in the active range of the active worksheet. Tip: highlight the range first could save time when editing the chart.

  • Get More Done In Less Time: Want to free-Up at least two working weeks a year?

    Time management is, was and continues to be a severe problem in every single industry I work with. Staff have too much to do in the time they have plus they are drowning under ever increasing volumes of email

    1. Training has still not recovered to pre-2008 days.
    2. Managers, owners, staff are too busy to search out solutons to teach themselves.
    3. New entrents from university only know Gmail, Hotmail - so have no idea of the shortcuts, integration and time saving features of Outlook/Calendars/Contacts.
    4. Software is constantly updating and changing.

    Solution: Debbie's 12 Week Outlook Productivity Bootcamp
    Instead of sending staff out of office or wasting time on webinars, each week they’ll get a personal email from me outlining an email woe; the solution and a 1 minute how-to video

    Each lesson takes less than 3 minutes:
    1. 30 seconds to read the email.
    2. One minute to watch the how-to video
    3. One minute to locate the function in their own Outlook program. Then hours of time saved per year per employee for your business.

    As a double launch special I’ll include three ebooks complimentary with your boot camp: 
    Conquer Your Email Overload; Make Your Database Your Goldmine; 101 Quick Tips Effective Communication.

    Simply click here to order online https://www.successis/Buy-book/bootcamp.htm  or  download the form and email / fax the form back

    Or if you like the personal touch, I'd be delighted to help with anything from small group training (minimum 6) through to conferences. Have a look below to see when I will be in a town close to you.

    1. Effective use of Cloud, Smartphones, software
    2. Email easing your pain, enhancing your gain
    3. Powerful presentations proposals people that sell
    4. Google and Social Media: the Good, Bad and Ugly
    5. Effective communication
    6. Database marketing

    Email me directly now or fill out the Speaking Quote before you lose your date.
    Debbie Mayo-Smith brief outline

    Where's Debbie

    Date 2015 Event Location
    6 Dec- Feb 15 Available for USA European Australian conferences USA Europe Australia
    30 November Avaialbe for private workshop Noumea Noumea New Caledonia
    15-25 Novmeber Available for private Australia workshops Australia
    13 November FBAA National Conference Gold Coast Australia
    7-12 Novembefr Available for private Australia workshops email Debbie Australia
    6 November Corporate Executive PA EA Masterclass Wellington
    4 November Corporate Executive PA EA Masterclass Auckland
    7 -30 September Istanbul, Italy, Paris Europe
    4 September Bayleys Administrator Day Auckland
    3 September Independent Tertiary Education NZ Rotorua
    28 August Bayleys Real Estate Auckland
    12 August NZTA Workshop Auckland
    11 August PGG Wrightson Real Estate Wellington
    10 August BDO Workshop Wellington
    10 August Contact Energy Exec PA Workshop Wellington
    29 July Kepa Business Leaders Auckland
    24 July Bradnams Conference Auckland
    23 July NZ Strong Auckland
    10 July Cranes NZ TaurangaZ
    10 July SurfLifesaving Workshop Tauranga
    9 July Wairiki Institute of Technology Workshop Rotorua
    8 July Althorp Retirement Villiage Workshop Tauranga


    Read last months' Business Quick Tips
    Please refer
    Thank you to everyone that referred this newsletter to colleagues. It's warmly appreciated

    New? Subscribe Now

    Please email Debbie to change your address 

    No more? Unsubscribe

    Published by SuccessIS. Debbie Mayo-Smith International Motivational Business Speaker and Author, 35 Chelmsford Ave, Glendowie, Auckland NZ. Phone 64 9 575 5359. Copyright 2015 SuccesslS.

    Debbie speaking at xerocon

    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.

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

    wesmcmaster.com 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!"