Helios Visions

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.

If you have multiple non-adjacent cells and you need to make a change the contents in the cells at once, there is an easy way to do this without copying and pasting the new data. In this example the name of one of the products has changed, we are going to change the name in multiple cells at the same time.  This will work the same in Excel 2010, Excel 2007 and Excel 2003.

When typing text into a cell in Excel you may have reason to start a new line. There is a keyboard shortcut to force the text on the next line in Excel.