Your Business Quick Tip Newsletter
Vol 21 No #216 – 28th July 2022
- When you Don’t Want to Use Email Rules
- Two Great Simple Excel Tips
- Six Teams Keyboard Shortcuts
- YouTube Video Watching Trick
1. When you Don’t Want to Use Email Rules
Outlook View Ribbon > Conditional Formatting.
Simply set the font (font, size, colour, bold, italic) and the condition you want met. For example, emails from specific people or with specific words in the subject or body. Once you create the condition it works retroactively through your inbox emails.
Gmail. A three-step process.
- Create a label (the equivalent to Outlook folders) from the top toolbar when you click on an email.
- Right click the label in the navigation pane to assign it a colour.
- Create a filter (the equivalent of Rules in Outlook) to apply the label when the condition is met by incoming emails. You’ll find filters by clicking the gear > settings > Filters and blocked addresses
2. Two Great Simple Excel Tips
- Wrap Text. You’ll love this if you don’t know it (yet)! If you have lots of text in one cell, and don’t want part to be hidden behind the adjoining column nor show in front of it, you can wrap the text into multiple lines within that one cell. Moving the left or right margin enables you to increase/decrease the width.
- Excel: Wrap Text is in the Home Ribbon, Alignment menu.
- Google Sheets Format Menu > Wrapping
Excel and Google Sheets
- 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.
3. Six Teams Keyboard Shortcuts
Here are six shortcuts to speed up the most common tasks you might do in Teams.
- Go to Search: Ctrl + E
- Turn your camera off: Ctrl+Shift+O
- Mute yourself: Ctrl+Shift+M
- Background blur: Ctrl+Shift+P
- Zoom: Ctrl+= to zoom in or Ctrl+- to zoom out
- Go to your files: Ctrl+6
4. YouTube Video Watching Trick
When watching YouTube videos on your phone in full screen mode; double tap the left to rewind 10 seconds. Double tap the right to fast forward 10 seconds. Tap multiple times for longer periods.