Your Business Quick Tip Newsletter
Vol 19 No #192 – 1st December 2020
- Must Know Shortcuts – MS Office & Google Doc’s
- Removing Duplicates in Excel / Google Sheets
- Take Control / Build Your Website Webinar
- Home Productivity – Holiday Present Tip
1. Must Know Shortcuts – MS Office & Google Doc’s
If you’re using Office or Google software – these are not to miss shortcuts.
MS Office – any program
- Ctrl + O – Open a new file
- Ctrl + W – Close a file
- Ctrl + N – Create a new document
Google Docs – any program (follow the precedent of .new)
You do need to have a Google account and Drive set up
- Type doc.new into www for new doc
- Type sheets.new into www for new sheet
2. Removing Duplicates in Excel / Google Sheets
If you have ever merged two lists that has double ups in it, you’ll know the pain of finding them and manually removing your duplicates.
There is a better way than one by one by one. Both Excel and Google Sheets has a function called Remove Duplicates and it makes your work so much easier. They simply ask you which column to check for the duplicate values (and you can do multiple columns). You’ll find remove duplicates:
- Google Documents – the data menu towards the bottom
- Excel: Data Ribbon> Data Tools Menu> Icon with two blue rectangles and a red x (see below)
3. Take Control / Build Your Website Webinar
Are you held hostage by your web designer? Is it costing too much or taking too long to make changes?
Are you thinking of starting a new business?
Today’s Website software is easy to use. However, there are some basic rules and tips to make your website easy to find (by Google) and easy to use.
This Webinar will cover
- The different Website design software and their pros and cons
- The items and issues you should consider in setting up / working on your Website
- What you need to know to create and/or maintain a Website
4. Home Productivity Tip One – Holiday Present Tip
Several years ago Mary Lambie and I co-wrote a 101 Quick Tip Book, Surviving the Kids. Link is here
It has a tip from when our kids were small. I was lamenting to a colleague about the rip, tear and early morning gift frenzy our six children employed, She explained that their family practice is for their three children to open their gifts one at a time during the course of the day:
- It prolongs the pleasure for the entire day
- It allows each gift to get proper attention
- You can build up from small presents, to the ‘big one’.
Talk to You in 2021
This will be the last newsletter for 2020. I hope you don’t mind. I think we all can use a break from this difficult year.
May I wish you a happy holiday, a wonderful new year and we will connect once again in mid -January 2021.