Sorting In Excel. Excel Sort (13 Examples)
by
Video Lecture 33 of 50
Not yet rated
Views: 914

### Lecture Description

Topics in this video:
1. Most sorting is done on a Proper Data Set (00:16 min)
2. Click in single cell and use Sort Button (00:43 min)
3. Whole data set is sorted, not just selected column (00:43 min)
4. Sort upon more than 1 column (01:35 min)
5. Sorting can be done on a set that does not have a field name (04:30 min)
6. Sort Hierarchy (05:13 min):
1. Numbers
2. Text/words (including Null Text Strings)
3. FALSE
4. TRUE
5. Errors (in the order they occur)
6. Empty Cells (Empty Cells are always sorted to the bottom whether or not you do A to Z or Z to A).
AND
ASCII Characters. Example C = 67 and c = 99.
7. Empty always goes to bottom (A to Z or Z to A) (07:42 min)
8. Errors sort to top if you use Z to A (Descending) (08:30 min)
9. Use extra column with RAND() to sort randomly. (09:54 min)
10. Formula To Extract Random Sorted List of Names (11:08 min)
11. Sort Horizontally (14:25 min)
12. Sort by color (15:00 min)
13. Change Major sort, or change which sort gets applied first (16:01 min)
14. In order to use the Subtotal feature, you must Sort FIRST (16:30 min)

### Course Description

This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel. It contains 50 video lectures teaching the basics of Excel, as well as advanced concepts.

Be sure to download the workbook to follow along with the examples. They are found on the official course website.