Monthly Archives: December 2013

Microsoft Outlook – displaying two time zones

If your boss is constantly travelling, you may want to show two time zones in your Outlook calendar, one reflecting where you are and the other where they are. If using Outlook 2007 or earlier: Click Tools – Options. The … Continue reading

Posted in Microsoft Outlook, Microsoft Outlook 2007, Microsoft Outlook 2010, Microsoft Outlook 2013, Microsoft Outlook 2016 | Tagged , | Leave a comment

Pulling a name out of a hat – or out of an Excel workbook!

A client contacted me to say they wanted to draw a prize winner out of an Excel database. The RANDBETWEEN function allows you to find a random whole number between two numbers you specify, so combining this with the INDEX … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , | Leave a comment

Microsoft Word – adding dummy text

If you are creating a mock-up of a newsletter or brochure in Microsoft Word, you may want to insert some dummy text to see how the text will fit into the layout, and also show the font and size to … Continue reading

Posted in Microsoft Word, Microsoft Word 2003, Microsoft Word 2007, Microsoft Word 2010, Microsoft Word 2013, Microsoft Word 2016 | Tagged , | Leave a comment

Microsoft Excel – column numbers instead or column letters

I was at a client site and one of the trainees opened Excel and we found that instead of having letters across the top of each column there were numbers. This is known as R1C1 or reference style. To switch … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , | Leave a comment

Microsoft Outlook – view two non-consecutive dates on a calendar

You may want to compare schedules on dates that are not consecutive within Outlook, for example all the dates you met with a certain client. To do so, from Calendar view, click on the Day view button, and in the … Continue reading

Posted in Microsoft Outlook | Tagged , , | Leave a comment

Microsoft Word – how do I edit links in Word 2007, Word 2010

If you have created a link to an Excel spreadsheet from Microsoft Word and the Excel spreadsheet gets moved to another location on the system, you will need to change the file path within Microsoft Word. In Word 2007: Click … Continue reading

Posted in Microsoft Word, Microsoft Word 2007, Microsoft Word 2010 | Tagged , | Leave a comment