Sorting and Grouping


show more Sorting and Grouping provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

Sorting and Grouping

Before you can begin to group your data, you need to sort it. And that's what we're going to talk about in this movie. By selecting a cell within a particular table, you can then go to your Sort commands, in your Sort & Filter group on your Data tab, and click. It then presents you with the Sort window, where you identify the items that you want a sort on, and the way that you like to sort them on. First of all, you identify which column you want a sort on. In your drop-down list, you'll see all of the item titles that you have in your table.

Let's select Item Category. Next we decide how we're going to Sort On that information. I can Sort On it by Value or by Cell Color, Font Color or Cell Icon, if I'm using conditional formatting. In this case and a use Values. The final decision I need to make is what order am I going to sort the information on? In this case, I have two options. I can sort alphabetically from A to Z, or the reverse from Z to A. I could also crea...

Sorting and Grouping
Video duration: 5m 9s 5h 13m Beginner

Viewers:

Sorting and Grouping provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...