Sorting from the Sort menu

Whenever you work with large amounts of data, whether it's an HR list like we see…here on the sheet or on the next sheet, scientific type data, the need to sort…the data, rearrange the order of the rows, is a common need.…And let's say that sorting is something that is probably the key action that we…take to manage our data.…We need to see at them this particular order.…Often we'll print this.…Before actually working with data, a couple of quick tips here.…Let's imagine you have never seen this worksheet or maybe you've only seen it once or twice.…

You forget how big it is.…It's something you'd want to know.…Get in a habit of pressing Ctrl+End.…This is not a perfect keystroke shortcut, but many times it gives you that quick read.…Notice that the active cell has moved to cell O742.…What can we say about that?…In this particular worksheet, remember we just pressed Ctrl+End, we can be sure…there is no data anywhere below row 742 nor is there any data to the right of…column O. Press Ctrl+Home to go back to the upper left-hand corner.…