DebbieSpeaks
Newsletter Sign UpSpeaking Quote
  • Home
  • Motivational Speaker
    • Speaking Topics
    • Speaking Quote
    • Training
    • Calendar
  • Profile
    • Testimonials
  • Training
    • Personal Training
    • 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
  • Newsletter
    • Newsletter – Current
    • Newsletter – Prior
    • Newsletter Sign Up
  • Contact
Menu

Your Business Quick Tip Newsletter
Vol 21 No #211 – 13th May 2022


Two Lovely & Useful Windows Key “Opening” Shortcuts

      1. Window & No# Key
        If you’ve pinned programs to your Taskbar (you can tell by the little icons that you can quickly open them with the Windows key + Number key.The number corresponds to location of the icon – first, second, third etc. So, , Windows key + 2 will open the second item on the Taskbar
      2. To launch a new app,
        Hit the Window Key and start typing the name of the app. It will pop up and you can click it. In Mac – Command + Space

Keeping the Cell Phone Zero in Excel and Google Sheets

What is your workaround for keeping cell phone numbers in your spreadsheets? Typing in the letter O? Adding spaces?

Instead, you can force Excel and Google Sheets to display placeholder 0 digits by applying a custom format. Here’s how:

Excel

  1. Select the cell, range or column.
  2. Home Ribbon > Number Menu select the Drop down arrow (it probably will say General);
  3. Select More Number Formats > Custom.
  4. Type in the number of zeros that comprise the entire cell phone number
  5. For example my phone number is 0275755359. So you’d need 10 zeros.

Google Sheets

  1. Select the cell, range or column.
  2. Select Format on the Menu
  3. Select Number > Custom Number Format
  4. Type in the number of zeros that comprise the entire cell phone number.
  5. For example with 0275755359 you’d need 10 zeros.

Password, Passwords – just a timely reminder

Once again compromised logins and passwords are in the news, here in New Zealand the AA has notified that it has one of its sites breache, so here are 5 tips for you to remember.

  1. Do not reuse/recycle passwords
  2. Do not make them easy to guess
  3. But make them easy to remember,
    – For example: instead of  P@SsT5y&R something like Get’s.Go.When!
  4. Change them regularly
  5. And finally use a Password Manager and 2FA (Two factor Authentication) for key sites.

You can also check to see if you’re part of a known breach by going to https://haveibeenpwned.com


If you like either of these tips – please:

  1. Call on +64 27 575 5359, or email me at debbie@successis.co.nz for a lovely quote on training or conference presentations 
  2. Refer your friends to the quick tip newsletter https://debbiespeaks.com/newsletter/newsletter-sign-up/

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

Copyright © 2022 - 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!