From the course: Excel Essential Training (Microsoft 365)

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Sorting data

Sorting data

From the course: Excel Essential Training (Microsoft 365)

Start my 1-month free trial Buy for my team

Sorting data

“

- [Instructor] Among Excels many data management tools, most of which are found on the Data tab up on the ribbon, probably the most commonly used is sort. And nearly always in Excel, sort means we're moving rows up and down. We've got a list here in columns A through J. It's about 700 rows or so. And at different times we want to sort based on what we see in one of the columns one or more of the columns to be more accurate. Currently this list is sorted by hire date. Those people hired earliest appear at the top of the list here. Before sorting, always make sure that any other data that might be on this worksheet, like this data to the right, is separated from the list that we want to sort by at least one empty column as it is here. And when you're ready to sort, one other aspect particularly if it's new data or data sent to you that you're not too sure of, make sure there are no empty rows or columns within it. Now,…

Contents