Basic and multi-field sorting


show more Basic and multi-field sorting provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

Basic and multi-field sorting

Another great database type feature that Excel has is the ability to sort data. Now sorting could be a matter of just one or two clicks or you could make it a little more interactive if you need. You can filter your data as you are sorting as well, which is pretty cool. Now if you aren't unfamiliar with database technology, Excel regards each row as like a record in a database and each column is like a field. So we have a Last Name field, First Name field, and so on. So let's say we want to sort by Department.

Click anywhere in the Department column. Now do not select the whole column and you don't have to select the whole area. Just clicking anywhere in the Department column is okay. Now, we want to be on the Home tab and over here on the right click Sort & Filter, and just choose Sort A to Z and boom, it's done. Let's say we want to sort by State. Click anywhere in the State column, click Sort & Filter, and maybe let's sort from Z to A. And now we have Ver...

Basic and multi-field sorting
Video duration: 6m 30s 6h 21m Beginner

Viewers:

Basic and multi-field sorting provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...