Welcome to Excelling with Excel 2007

Working Smarter

Database and quiz
there is a database assignment to complete first and then the quiz - remember to email me for the database and then the quiz

Excel is also used to manage lists of information (databases)
What makes Excel powerful in list management is that it can sort and filter information. This means Excel can give you precise information from a long list.

The basic steps involve doing the following: email me for the practice database

• Click in a cell
• DATA Tab and select SORT
• A sort dialog box appears

The sort dialog box gives you several options for sorting.

• when the box opens you see sort by - there is a box there with a down arrowhead at the end. This is where you select how you want Excel to sort . In a list - would it be by last name, city, state or? You have to decide
• click on the ADD LEVEL button- Excel will sort first by the first box and then by the second box and then by the third box
• use the down arrowheads to select the categories you want Excel to sort by use the practice database for this - you might want to make several copies of the original practice database - then you can practice and practice and practice

Diagram1: selecting the cell and using the dialog box.

Diagram2: You can also do a quick sort by using the Ascending/Descending buttons.

there is more - NEXT