Multi-key sorting


show more Multi-key sorting provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010 show less
please wait ...

Multi-key sorting

Using the Sort command, you can sort on multiple columns at the same time and Excel has expanded this capability substantially in versions 2007 and in 2010. As we look at this data, it may be important to you to see the data in order possibly by department, but in some of these departments, we have over 100 people. And so we'd like to be able to look at that portion of the list and see it in order perhaps by Status, maybe by Employee Name, maybe by Salary, or maybe a combination of those.

If your needs are to sort on more than one column and if you have not used the Sort buttons, which have their limitations and yet could work if you are only thinking about two columns or possibly three, go to the Sort command. Now, once again, click on a single cell within the data. Go to the Sort command button on the Data tab. Let's imagine that our major grouping that we're looking for here, in other words the very first column, the dominant sorting arrangement here, is to be by departme...

Multi-key sorting
Video duration: 3m 4s 1h 32m Appropriate for all

Viewers:

Multi-key sorting provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010

Subjects:
Business IT
Software:
Excel
Author:
please wait ...