Monthly Archives: March 2014

Microsoft Word – my Tab key won’t work for going to the next level in outline numbering

When training Word 2010 outline numbering recently, one learner was unable to use her Tab key to get to the next level of numbers. This foiled me for a while but I decided it must be something in the settings. … Continue reading

Posted in Microsoft Word, Microsoft Word 2010, Microsoft Word 2013, Microsoft Word 2016 | Tagged , | 3 Comments

Microsoft Excel – creating a pdf from more than one worksheet in a workbook

I was recently asked whether you could incorporate more than one Excel worksheet into a single pdf. To do so, first group the worksheets – if they are not next to each other, select the first one, then holding down … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2010 | Tagged , | 1 Comment

Microsoft Excel – removing blanks from credit card numbers, phone numbers, etc.

  If you have a column of credit card numbers or phone numbers where blanks have been included and you want to remove the blanks, the SUBSTITUTE function can be used. This replaces existing text with new text in a … 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

Demise of Office 2003 and Windows XP

From 8th April 2014, Microsoft will no longer be supporting Office 2003 and Windows XP. See https://www.microsoft.com/en-gb/windows/endofsupport.aspx for more details. If you continue to use Windows XP, you are more likely to be less secure to hackers, etc.. If you … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Outlook – working with birthdays

If you fill in the Details section of Outlook contacts, you may want to see all those who birthdays are within the next week or the next month. In Outlook 2007, from the Contacts folder, click View – Current View … Continue reading

Posted in Microsoft Outlook | Tagged , | Leave a comment

Microsoft Access – removing Subdatasheet

If you have inserted a subdatasheet into an Access table, you may want to remove it. To do so, open your table in Datasheet view. On the Home tab, in the Records group, click the More dropdown, then select Subdatasheet … Continue reading

Posted in Microsoft Access, Microsoft Access 2007, Microsoft Access 2010 | Tagged , | 2 Comments

Microsoft Access – Parameter Query on months of year

How can I create a parameter query that lets me just specify a month period, i.e. July? If you have a date in a query and you just want to return items within a certain month set up as a … Continue reading

Posted in Microsoft Access, Microsoft Access 2003, Microsoft Access 2007, Microsoft Access 2010 | Tagged , , | Leave a comment