Sorting+Data

Sorting Data in Excel
(Based on Picture Yourself Learning Microsoft Office 2007 by Diane Koers p 209-212)

Dealing with worksheets containing a lot of data can be hard and time consuming. It is very helpful to be able to sort the data in a particular way and make it easier to manage.  When we have listed in continuous order and labeled for each column data it is a good idea to sort it by **__ascending__** or **__descending order__** depending on the needs //ASCENDING ORDER: // Choose Data -> Home (Editing) -> Sort and Filter -> Sort A to Z This option can be used not only for text but also for numbers, special characters and dates as well. //DESCENDING ORDER: // Choose Data -> Home (Editing) -> Sort and Filter -> Sort Z to A These options can be used not only for text but also for numbers, special characters and dates as well.

The same can be done in a similar way using Sort dialog box Choose Data -> Home (Editing) -> Sort and Filter -> Custom Sort The other options Sort dialog box offers are · sorting the data horizontally by pressing the Options button · selecting whether to include the headings <span style="font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol; msobidifontfamily: Symbol; msofareastfontfamily: Symbol; msolist: Ignore;">· <span style="font-family: 'Bodoni MT','serif';">adding secondary column or row to sort by clicking the Add level button (256 sorting levels possible) After ending up with nicely sorted data we may conclude we do not need some of the information or values. To get rid of any duplicates entries use the following: Choose Data -> Data Tools -> Remove Duplicates

<span style="font-family: 'Bodoni MT','serif'; font-size: 11pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: 'Times New Roman'; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;">It is worth to devote a time for arranging our data because working with well organized records is easier, faster and more efficient.

Beata Marek INFO 273-12