UpskillTips
Please note that you will only be able to access articles from the newsletters you are currently subscribed to.
DOWNLOAD PDF Next time you need to insert a hyperlink in an email or document, simply press the CTRL and K keys together to open the Hyperlink dialogue box.
DOWNLOAD PDF Cells already have addresses, such as A1, but you can assign names to single cells or multiple cells that you can then use in formulas instead of their
DOWNLOAD PDF To quickly create a dividing line in Word or in Outlook, type three hyphens (—) then press Enter. You can also use three tildes (~), underscores (_), asterisks
DOWNLOAD PDF From the File Explorer view you can open a new folder without leaving the folder you are viewing. Right click the folder you want to open from the
DOWNLOAD PDF If you wish to change all the references to your businesses name in a Word document so that they are formatted in a particular way (bold, colour, font
DOWNLOAD PDF If you have a large list of data to print off on multiple pages and want to see the column headings or titles on each page, go to
DOWNLOAD PDF In PowerPoint, once you have set up animations on a particular object you can quickly copy it to other objects in the file using the Animation Painter. Click
DOWNLOAD PDF If you need to summarize a set of data by month, insert a new column next to the date column and enter this formula: =month(A1) to extract the
DOWNLOAD PDF If you have been away from your desk for a couple of days, rather than processing your emails in date order, sort them by the senders name, that
DOWNLOAD PDF Converting a range to a table gives you instant filters and totals for each column. To do this quickly, select the cells you want to convert to a
DOWNLOAD PDF When you copy and paste information from a brochure or website, you may also paste icons or images you then need to remove. Rather than deleting each one
DOWNLOAD PDF If you need to see two sheets from the same workbook side by side, open one of the sheets and click on the View tab. Click the “New