Your Business Quick Tip Newsletter
Vol 20 No #198 – 25th May 2021
- Lovely Problem-Solving Excel / Google Sheets Tip
- Outlook Safety Net
- Smarter Google Searching
- Bring A Small Sustainability Challenge To Your Office This July
- Microsoft: Five Ways to Save A Screen Shot.
1. Lovely Problem-Solving Excel / Google Sheets Tip
Hate wondering ‘where’s my text’ in your spreadsheet? Stretching a column or wrapping text?
Instead insert a Line Break. Have your text appear exactly where you want on separate lines within the same cell.
- Double-click the cell in which you want to insert a line break.
- Click the location where you want to break the line.
- Press ALT+ENTER to insert the line break.
2. Outlook Safety Net
Ever wish you had a chance to rethink that email you just sent? Have you wanted to try a personalised email merge without sending them in case there’s an error? Well, you might not have noticed it, but in the Outlook Send/Receive Ribbon, there’s a Menu > Preferences which enables you to Work Offline with a click.
3. Smarter Google Searching
Next time you search, try this tip on using a Search Operator. These are characters or words that give you much better search results. My top three? “”, AND, OR. Example if you want to search for managing directors in Tihape, you would put “managing director” AND Tihape. This will exclude results that only have managing or only director and includes Tihape. This also works in LinkedIn and BING.
Bonus Time!!!! The link to all Google’s search operators
4. Bring A Small Sustainability Challenge To Your Office This July
You know the damaging story of plastics already. Make a difference and encourage your office to join Plastic Free July. It’s a worldwide campaign spanning 177 countries focusing on reducing our use of single-use plastics with easy, simple swops.
Here’s how in three easy steps
- Sign up for the July campaign http://bit.ly/pfjj. Follow on Facebook http://bit.ly/pfjaf and Instagram http://bit.ly/pfjia for inspiration, updates, competitions and education
- Spread the word amongst colleagues, whānau, friends, employees and anyone else you can think of! There is a significant amount of support material available for home and office – contact email@example.com for logos, posters, case studies, swap ideas, stories and more.
- Participate during July and beyond. It can be as simple as using a bar of soap. Your own coffee cup. Buying items in glass jars instead of plastic. Making or baking instead of buying plastic wrapped food.
Why not copy this article and share it (or the entire newsletter) with everyone. Also do not hesitate to contact me if you’re interested or have questions. firstname.lastname@example.org
5. Microsoft: Five Ways to Save A Screen Shot.
1. Snip & Sketch (newish) Open it with the keyboard shortcut Windows key + Shift + S. Or start typing snip from the Start button. (Pin it to your taskbar). Your screenshot will be saved to your clipboard and show up momentarily as a notification in the lower-right corner of your screen. Click the notification to open the screenshot in the Snip & Sketch app to annotate, save or share it.
2. The Snipping Tool the oldie but goodie. (It’s not in the app list from the Start menu but easily got to via the search bar.
Click the New button to begin the screenshot process. The default snip type is a rectangular snip, but you can also take free-form, full-screen and window snips.
The Snipping Tool does not automatically save your screenshots — you will need to manually save them in the tool before you exit — but it does automatically copy your captures to the clipboard.
3. Print Screen (sometimes labelled PrtScn) key captures the entire screen.
4. Alt + Print Screen will copy only the window you’re working in (vs. the entire screen).
5. Windows key + Print Screen will capture your entire screen and automatically save the screenshot,
Well, it isn’t like three years ago, but activity is picking up, slowly. I’d be delighted to deliver training, present to a meeting or conference when I’m in your neck of the woods.
|31 July 2021||ICNZB Conference||Rotorua|
|26 June 2021||OFPANZ||Auckland|
|17 June 2021||Tullock Training||Masterton|
|15 June 2021||NZ Golf Managers Conference||Auckland|
|2 June 2021||Webinar Successful Email Marketing part 2||NZ Wide|
Email Debbie for specials available during June and July