Fill, Sort and Filter Data

Task: Fill, Sort and Filter Data		No	C3
No	Steps	Yes	No
C3.1 Fill
01	Open or create workbook
02	Click sheet
03	Type start number
04	Select start number cell
05	Homeàfillàseries
06	Select column/Row àSelect type
07	Type step number
08	Type stop numberàok
C3.2 Sort Data Base
01	Open or create workbook
02	Click sheet
03	*Type the data according to the sample datasheet provided sample document 01
04	Select database with heading
05	Dataàsort
06	Check “my list has header row”
07	Select field (Department)
08	Select orderàOk
	*Ask the instructor for the sample datasheet
C3.3 Filter data
01	Open or create workbook
02	Click sheet
03	*Type the data according to the sample datasheet provided sample document 01
04	Select database heading
05	Data àfilter
06	Click a 'Drop down' button on the field (Bsal)
07	Choose number filter
08	Select a condition (greater than)
09	Type a value (10000)
10	Click 'OK' button
11	*Ask the instructor for the sample datasheet
C3.4 Filter data using Advance filter
01	Open or create workbook
02	Click sheet
03	*Type the data according to the sample datasheet provided sample document 01
04	Select database heading
05	Copy database heading and paste heading two time bellow the Database
06	Type condition in the criteria range
07	Select database with heading
08	Data àadvance filter
09	Select copy to the another location
10	Select criteria range and copy to range
11	Click 'OK' button
	*Ask the instructor for the sample datasheet

Sorting

Sorting lists is a common spreadsheet task that allows you to easily reorder your data. The most common type of sorting is alphabetical ordering, which you can do in ascending or descending order.

To Sort in Alphabetical Order:

1.       Select a cell in the column you want to sort (In this example, we choose a cell in column A).

2.       Click the Sort & Filter command in the Editing group on the Home tab.

3.       Select Sort A to Z. Now the information in the Category column is organized in alphabetical order.

4.       A Microsoft Excel spreadsheet can contain a great deal of information. With more rows and columns than previous versions, Excel 2007 gives you the ability to analyze and work with an enormous amount of data. To most effectively use this data, you may need to manipulate this data in different ways. In this lesson, you will learn how to sort, group, and filter data in various ways that will enable you to most effectively and efficiently use spreadsheets to locate

5.       and analyze  information. You can Sort in reverse alphabetical order by choosing Sort Z to A in the list.

To Sort from Smallest to Largest:

1.       Select a cell in the column you want to sort (a column with numbers).

2.       Click the Sort & Filter command in the Editing group on the Home tab.

3.       Select From Smallest to Largest. Now the information is organized from the smallest to largest amount.

4.       You can sort in reverse numerical order by choosing From Largest to Smallest in the list.

To Sort Multiple Levels:

1.       Click the Sort & Filter command in the Editing group on the Home tab.

2.       Select Custom Sort from the list to open the dialog box. OR

3.       Select the Data tab.

4.       Locate the Sort and Filter group.

5.       Click the Sort command to open the Custom Sort dialog box. From here, you can sort by one item, or multiple items.

6.       Click the drop-down arrow in the Column Sort by field, and choose one of the options. In this example, Category.

7.       Choose what to sort on. In this example, we'll leave the default as Value.

8.       Choose how to order the results. Leave it as A to Z so it is organized alphabetically.

9.       Click Add Level to add another item to sort by.

10.   Select an option in the Column Then by field. In this example, we chose Unit Cost.

11.   Choose what to sort on. In this example, we'll leave the default as Value.

12.   Choose how to order the results. Leave it as smallest to largest.-->Click OK.]

The spreadsheet has been sorted. All the categories are organized in alphabetical order, and within each category, the unit cost is arranged from smallest to largest.

Remember all of the information and data is still here. It's just in a different order.