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! Comments are closed.
|
Details
AuthorHi, I am Marion of Marion Metz Solutions Archives
October 2024
Categories
All
|