From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Sorting data

Sorting data

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Sorting data

“

- Probably the most common tool for data management is called sorting. We got a list on this worksheet called sorting, it's in the workbook 12- Data Management Features The list is in no particular order right now but you could easily image wanting to sort this list based on the employee name in column A, possibly by the department, hire date, in fact almost any column in here could be the basis of sorting. Sorting most of the time for most people means rearranging the order of these rows. And if we sort, we want all the information for a single person, for example, Larry Weber here. We want this row to move up or down into its appropriate place. Based either on what's in column A or column C or whichever column we want to sort by. Most sorting means rearranging by rows. There is an option to rearrange by moving columns from left to right that's rarely used. We'd like to sort this data. And we can sort it in any number of different ways, and combinations of ways as well. The Data tab…

Contents