Welcome to Excelling with Excel

Working Smarter

Database and quiz
There is a database assignment to complete first 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:

• Click in a cell
• Data Menu and select SORT
• A sort dialog box appears
• Select how you want your information sorted and click OK

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
• then there is another category - then by - 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 the sort menu

Diagram 2: the sort dialog box

there is more - NEXT