Microsoft Excel functions are over 100 built in functions that can be used to simplify many of the most repetitive and complex tasks that spreadsheet creators are likely to need to implement in their work. To enter an Excel function in to a worksheet cell, simply select the cell by clicking on it and then […]
Before you distribute any Microsoft Office Documents you have created it is very important that you delete Office metadata to maintain your privacy. When you create or edit a document with Microsoft Office, there is a whole host of potentially identifiable information stored as part of the document which for some users may constitute a […]
One of the nice features introduced with Office 2007 and 2010 is that of Live Preview. With Live Preview, gone are the days of making formatting changes to your document, hitting ‘Apply’ and hoping for the best. Now with Live Preview you can see the effects of your changes before they happen. First you will […]
As with the majority of all Windows based applications, the only way to efficiently work with your document is to master some of the most useful shortcut keys. Word has over 150 different, shortcut key combinations, so listing and expecting users to remember them all is impractical. However by remembering and using the most common […]
Note – This article refers exclusively to Outlook 2007 / 2010, if you want to create a template for Outlook 2003, please click here. If you regularly send out emails that are the same or very similar in content, then you will almost certainly benefit from the email template feature available for Outlook that will allow you […]
If you have been using a previous version of Outlook (or Outlook Express) then importing your data should be fairly painless as Outlook is very good at detecting the necessary files, and importing them. However, don’t despair if your data is in another format as Outlook contains some very good tools for converting and importing […]
If you’re someone who spends a long time looking at boring black and white Microsoft Excel spreadsheets you’ll appreciate this top to add some colour to your sheets. In Microsoft Office 2007 it is possible to use any picture you want as the background for all your spreadsheet data thus adding a bit of spice […]
For the 2007 release of Office Microsoft have completely redesigned the Office user interface and have done away with all the different menus and dialogue boxes in favour of a whole new interface that is commonly referred to as ‘Pick & Click’ This new Office user interface does away with all the searching through various […]