Free Microsoft Office Tutorials | Online Office Learning Guide | Microsoft Office Tips and Tricks

Sorting and Filtering allow you to manipulate data in a worksheet based on given set of criteria.

Basic Sorts
To execute a basic descending or ascending sort based on one column:

• Highlight the cells that will be sorted
• Click the Sort & Filter button on the Home tab
• Click the Sort Ascending (A-Z) button or Sort Descending (Z-A) button

Custom Sorts
To sort on the basis of more than one column:

• Click the Sort & Filter button on the Home tab
• Choose which column you want to sort by first
• Click Add Level
• Choose the next column you want to sort
• Click OK

Filtering
Filtering allows you to display only data that meets certain criteria. To filter:

• Click the column or columns that contain the data you wish to filter
• On the Home tab, click on Sort & Filter
• Click Filter button
• Click the Arrow at the bottom of the first cell
• Click the Text Filter
• Click the Words you wish to Filter

• To clear the filter click the Sort & Filter button
• Click Clear

Bookmark it:

Popularity: 11% [?]

Excel 2007 offers a wide range of customizable options that allow you to make Excel work the best for you. To access these customizable options:

• Click the Office Button
• Click Excel Options

Popular
These features allow you to personalize your work environment with the mini toolbar, color schemes, default options for new workbooks, customize sort and fill sequences user name and allow you to access the Live Preview feature. The Live Preview feature allows you to preview the results of applying design and formatting changes without actually applying it.

Formulas
This feature allows you to modify calculation options, working with formulas, error checking, and error checking rules.

Proofing
This feature allows you personalize how word corrects and formats your text. You can customize auto correction settings and have word ignore certain words or errors in a document through the Custom Dictionaries.

Save
This feature allows you personalize how your workbook is saved. You can specify how often you want auto save to run and where you want the workbooks saved.

Advanced
This feature allows you to specify options for editing, copying, pasting, printing, displaying, formulas, calculations, and other general settings.

Customize
Customize allows you to add features to the Quick Access Toolbar. If there are tools that you are utilizing frequently, you may want to add these to the Quick Access Toolbar.

Bookmark it:

Popularity: 3% [?]