Sorting from the Sort menu


show more Sorting from the Sort menu provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010 show less
please wait ...

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 co...

Sorting from the Sort menu
Video duration: 4m 37s 1h 32m Appropriate for all

Viewers:

Sorting from the Sort menu provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010

Subjects:
Business IT
Software:
Excel
Author:
please wait ...