Your Business Quick Tip Newsletter
Vol 20 No #199 – 15th June 2021
- Outlook.com & Gmail trick
- (Glorious) Excel Subtotal
- Two FREASY Plastic Free July Wins
- Bespoke Online Training
Where do you go when you’re looking for a good recipe or perhaps a good hack for organising the garage? Well, the name above gives you the answer. Pinterest. When you search, you’re getting the curation of ideas and responses in one visual place. It’s a lot easier than a search engine.
2. Outlook.com & Gmail trick
If you use either Outlook.com (the webmail / online version of Outlook) OR Gmail, are you missing a great feature?
The ability to drag and drop emails into your calendar or to do list.
Outlook.com, on the upper right of the navigation bar, there’s a little icon of a calendar with a tic box in front of it. This is “My Day”
Click it to open on the right side of your screen (image below). You’ll be able to drag and drop an email into the top for a calendar item; or the bottom for a task item.
Outlook.com My Day
It’s similar with Gmail. You might not have noticed at the very bottom right hand of the screen, there is a tiny half arrow. Click it to open the navigation pane for: Contacts, Calendar, To Do and Keep. Click one of the four open. Similarly, you can drag and drop an email into calendar and To do.
3. (Glorious) Excel Subtotal
While writing an Excel training session for a small business this week, I thought of the ability to subtotal information with a couple of clicks without using a Pivot Table.
Do you know it? Have a look, it’s a wonderful feature that lets you subtotal any number of columns with sum, count and much more. For example, instead of creating a formula and dragging it down, a dialogue box opens and asks ‘
- At each change in (you select the column)
- Use this function (count, sum, max – etc.)
- Add subtotal to these columns (you can select multiple ones)
You will now find it in the Data Ribbon / Outline / Subtotal.
4. Two FREASY Plastic Free July Wins
- When not using covered containers, store leftovers in the fridge covered with plates instead of plastic wrap. You’ll save 65 metres of wrap per year
- Buy a metal or glass water bottle. If you normally buy a bottle of water a day avg. $2.50 per bottle, that is a monthly saving of $77.50. Even if your new bottle costs $25.00, you’re well ahead.
Please don’t forget to sign up if you’re interested here
5. Bespoke Online Training
If your business is looking to upskill staff with minimum disruption, consider one of my bespoke webinars. All the training is customised to your desired outcome, software and staff skills. For example:
- Conquer Email. Ease your pain. Enhance your gain
- Effective Communication – be more memorable & persuasive
- Fabulous Cloud, Office 365, Smartphones, Apps Tips and Tricks
- Microsoft Mastery – Word, Excel, PowerPoint
- Profitable Email Marketing
- Secret Diamonds of Google – More time. Grow business. Cut costs.
- Google My Business – Get a top Google ranking
- Understanding technology disruption
- Don’t get hacked!!! How to protect yourself & your business
- FREASY ways to improve Profits. Promotion. Productivity
Call +64 27 575 5359 or email email@example.com today.