Many of you probably use Gmail, either for business or privately. Either way, it pays to
make life easier for you when you want to find an email.
Excel is also a common software to use, so read on for some great tips.
Gmail Tips - Labels
You probably use labels in Gmail, which basically act as folders.
How to create labels for your emails
The easiest way to create a new label is to click on the big + sign on the left-hand side of your screen. This opens the basics for your new label: the name and where to nest it under (your “filing cabinet” structure).
When you create names for your folders, be aware that they are sorted alphabetically by Gmail. If you want to sort them differently, an easy way to do this is by naming your folder i.e. 001 Finances, 002 Private, etc.
How to colour the labels
Once created, you can click on the three overflow dots beside the label to select colours and a lot of other things.
Excel Tips - shortcuts
Ctrl + Semi Colon
This enters today's date as a value and formats the cell as dd/mm/yyyy.
Double-click format painter
This will enable you to copy formats to more than one cell
Alt + Enter
This inserts new lines within a cell. It can be used to make lots of info simpler to read and look less cluttered.
Hold down Ctrl and drag the sheet to copy your worksheet
Much quicker than right-clicking the sheet name, selecting 'Move or Copy', selecting a position, then ticking the 'Copy' box.
Excel tips courtesy of Traci from Excel Ace Limited
If you have any difficulties with those tips, please don’t hesitate to get
in touch with me, I’m sure I can help you!
I’m a Virtual & In-Person Assistant and I work with small business owners. I specialise in helping them with administrative tasks, like updating and proofreading their website and their business documents.