From the course: Excel Essential Training (Microsoft 365)
Join today to access over 24,300 courses taught by industry experts.
Sorting data - Microsoft Excel Tutorial
From the course: Excel Essential Training (Microsoft 365)
Sorting data
- [Instructor] If you work with lists in Excel, lists of any size, invariably you will want to sort the list. Sorting nearly always means move rows up and down. On this worksheet called Sorting, you can immediately see it appears to be sorted by Employee names over in column A. But we might want to move this up and down to sort the list by Department. And when you sort, it's important to recognize that you can sort on a given column based on the information there, but also secondarily sort on other columns. And the concept might not be clear until you actually work with real data. So let's imagine we've got a list here. This is over 700 rows. By the way, a little tip here too. If you're looking at a worksheet you haven't seen in a long time, or maybe never, if you click on a cell and hold down the Control key, press down arrow, it's going to take you down to the bottom of the row. It's actually going to take you until it sees an empty cell, and let's hope you've got data in the…
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.
