Your Business Quick Tip Newsletter
Vol 19 No #180 – 3rd March 2020
Contents
- Too Much Open?
- Social Media Videoing Tip
- Make Excel Cells Stand Out
- Voice Activated Smartphone Photographs
1. Too Much Open?
The last issue covered cycling through all your open documents in Windows (See it here) If you accumulate a lot of open documents and programs on your screen, here is a lovely second trick to minimise all except the one you are working on.
Click & Shake
Click the title bar of the window you want to remain open to select it. Holding your mouse down, move the window back and forth quickly — shaking it. After a few quick shakes, you’re left with one.
Or
If you want everything to minimise in Windows, you can hit the small vertical bar on the bottom right-hand side of the screen. See image below.
2. Social Media Videoing Tip
When you’re shooting in selfie mode – you know you need to look at the camera itself for the best result. It’s hard to remember and easy to slip into speaking directly into your phone screen.
With your finger, find and cover the selfie camera. When you see your ‘skin’; put a little piece of coloured tape next to the camera hole. Then look directly at it when videoing.
Please let your colleagues, friends and family know about this newsletter and invite them to subscribe. It would me the most gracious of compliments. https://debbiespeaks.com/newsletter/newsletter-sign-up/
3. Make Excel Cells Stand Out
With Conditional Formatting. This feature allows you to colour text; a cell or apply an arrow automatically to information that meets a criteria you set. For example the top 10% of sales. Sales by Tom. Amounts over or under $5000. Rank sales by size and so on.
Here is a how-to video (1 minute 40 seconds) https://youtu.be/AH9KyVJtX_A
If you like this tip, I have an Excel online learning program with 16 -weekly tips. Email for more information debbie@debbiespeaks.com
4. Voice Activated Smart Phone Photographs
One of my favourite smart phone tricks over the past year has been to simply say “smile” when I wanted to take a photo. Easy. Lovely. No fiddling or jiggling. Though you might have to weather a stare or two in a crowd if you are taking a lot of pictures.
Check your phone’s camera settings for voice activation.
Group Training and Conference Keynote or Workshop
Productivity How to Free Up ½ An Hour A Day!
A treasure of practical, easy, business changing Microsoft Office productivity how-to’s and eye openers. All focused to free up heaps of time to do what needs to be done; or what individuals love to do. Presented in a memorable, entertaining, unforgettable manner. Call or email now for a proposal +64 27 575 5359 debbie@debbiespeaks.com