While there are many applications that provide a wide range of fantastic screen capturing features OS X also has built in shortcut keys for making many different types of screen captures. Capturing a Region Command & shift & 4 turns the mouse pointer into a cross-hair cursor allowing any region of the screen to be [...]

Do you use Business Contact Manager for Microsoft Outlook 2003? If you do then take a look at this great list of keyboard shortcuts from Microsoft to help you become more productive.

In previous versions of Dreamweaver creating a Site Definition was a process fraught with difficult questions. With Dreamweaver CS5 Adobe have massively simplified the creation of Site Definitions. Accessing the Site Setup Dialog Box via the Menu There are several ways to access the Site Setup Dialog Box. Selecting Site, New Site… from the Menu [...]

Every Word document is based on a template and it is likely that most documents are based on the NORMAL template. This short tutorial demonstrates how to change the default font for all new documents based on the Normal template in Word 2007. The instructions also apply to Word 2010 Open the Font Dialog Box [...]

PowerPivot for Excel 2010 is a FREE add-in from Microsoft.

Excel allows you to assign a name to an individual cell or a range of cells. That name can be used in a formula and can help to make the formula easier to understand. Names can also make it easier to navigate around a large spreadsheet. In Excel 2007 and 2010, names have a scope [...]

The Save As PDF command in MS Office 2007 allows you to create a PDF from a Microsoft Office document even if you haven’t got Adobe Acrobat installed. However, if the Office document contains images (and the images have been inserted using the Insert > Image command rather than copy and paste), the image in [...]

The Conditional Sum Wizard allows you to create totals for cell ranges based on multiple criteria. The SUMIF Function – Single Criteria Only In Excel, the SUMIF function adds up all the numbers in a range of cells, based on a given criteria. The screenshot is a sample spreadsheet that records details of training courses. [...]