Highline Excel 2013 Class Video 33: Sorting In Excel. Excel Sort (13 Examples) скачать в хорошем качестве

Highline Excel 2013 Class Video 33: Sorting In Excel. Excel Sort (13 Examples)

Download workbook: http://people.highline.edu/mgirvin/Al... This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel. 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)