Microsoft Excel 2007 - Sort and Filter
Sorting and Filtering allow you to manipulate data in a worksheet based on given set of criteria.Basic SortsTo execute a basic descending or ascending sort based on one column:Highlight the cells that will be sortedClick the Sort & Filter button on the Home tabClick the Sort Ascending (A-Z) button or Sort Descending (Z-A) buttonCustom SortsTo sort on the basis of more than one column:Click the Sort & Filter button on the Home tabChoose which column you want to sort by firstClick Add LevelChoose the next column you want to sortClick OKFilteringFiltering allows you to display only data that meets certain criteria. To filter:Click the column or columns that contain the data you wish to filterOn the Home tab, click on Sort & FilterClick Filter buttonClick the Arrow at the bottom of the first cellClick the Text FilterClick the Words you wish to FilterTo clear the filter click the Sort & Filter buttonClick Clear
Description
Microsoft Excel 2007 has a completely redesigned user interface. The standard menus along the top have been removed and replaced with a series of toolbars Microsoft calls “The Ribbon.” These tool bars are changed using tabs at the top and try to automatically adjust themselves to the content you are working with. If you select an image it will automatically switch to the picture tools. The new layout seems to offer easier access to most of the features of Excel allowing for more complex documents to be created quicker.
Presentation Transcript
Your Facebook Friends on WizIQ