From the course: Excel 2010 Essential Training
Join today to access over 25,500 courses taught by industry experts.
Basic and multi-field sorting - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
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 Vermont at the top and…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.