Microsoft Office Productivity

If you have a worksheet that requires that a column or row only contain numeric values, you can limit the entry in the cell using Data Validation. This will prevent anyone from entering text or dates or any other type of data other than a number.

In Microsoft Word 2007 you can translate a word, phrase or entired document into another language.  This video will show you how to use this feature in Word 2007.

Using Microsoft Word 2010 you can translate a word, phrase or entire document into another language.  This tutorial will show you how to use this feature in Word 2010 only.

This operation allows you to extract specific data for review. You can create a ‘set’ of specific criteria to use to ‘Filter’ the data. In this example we will pull out specific information from a list of employees. We will create criteria that will display employees that were employed before a specific date, make more than $40,000 and work in one of three departments.  This will work the same in Excel 2010 and Excel 2007.